Error running Harvest 2.0 with Community Server 2008 Sp1 Enterprise Search

rated by 0 users
Answered (Verified) This post has 1 verified answer | 8 Replies | 3 Followers

Top 500 Contributor
99 Posts
Points 1,285
Navy#1 posted on Thu, Nov 20 2008 12:19 PM

I am getting the following error.
2008-11-20 13:15:13,222 [7504] ERROR [] - Exception while running job ES.SearchJob of type CommunityServer.Enterprise.Search.SearchJob
Exception: System.Reflection.TargetInvocationException
Message: Exception has been thrown by the target of an invocation.
Source: mscorlib
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at Telligent.Tasks.Task.?()
   at Telligent.Tasks.Task.?()

Nested Exception

Exception: System.TypeInitializationException
Message: The type initializer for 'CommunityServer.Components.CSCache' threw an exception.
Source: CommunityServer.Components
   at CommunityServer.Components.CSCache.Get(String key)
   at ?.?()
   at CommunityServer.Enterprise.Search.IndexInitializer.Load()
   at CommunityServer.Enterprise.Search.SearchJob..ctor()

Nested Exception

Exception: System.MissingFieldException
Message: Field not found: 'Telligent.Components.TCache.DayFactor'.
Source: CommunityServer.Components
   at CommunityServer.Components.CSCache..cctor()

 

  • | Post Points: 20

Answered (Verified) Verified Answer

Top 10 Contributor
4,034 Posts
Points 61,125
TelligentSupportTeam
Verified by Navy#1

The problem is in CS2008.5 there has been some significant refactoring of hte codebase, meaning that ES pre CS2008.5 is incompatible with ES for CS2008.5 and later (and vice versa).  So by using hte same instance of ES for both CS 2008 SP1 and Harvest (which uses the CS2008.5 binaries) you'll face some problems.  You will need to install two instances of the tasks service - one for the CS2008 SP1 version to use with ES, and another wiht the latest version of the tasks server for Harvest 2.0.  Instructions on installing two instances of the Tasks Service can be found at http://docs.communityserver.com/general-topics/installing-multiple-instances-of-windows-service/ .

  • | Post Points: 25

All Replies

Top 10 Contributor
4,034 Posts
Points 61,125
TelligentSupportTeam

Did you upgrade enterprise search to the latest version before installing harvest?

  • | Post Points: 20
Top 500 Contributor
99 Posts
Points 1,285
Navy#1 replied on Thu, Nov 20 2008 1:41 PM

You can run the same Enterprise Search with both 2008 and 2008.5?  I am still on 2008

 

  • | Post Points: 5
Top 500 Contributor
99 Posts
Points 1,285
Navy#1 replied on Thu, Nov 20 2008 1:47 PM

I am also getting errors running the actual Harvest tasks

Task: BlogCommentData @ 2008-11-20 02:40:14.949965 : Task Started.
2008-11-20 02:40:14.949965 - BlogCommentData - TaskBase.Execute() - Begin
    2008-11-20 02:14.949965 - BlogCommentData - ReadConfig(node) - Begin
    2008-11-20 02:14.949965 - BlogCommentData - ReadConfig(node) - End
    --- ---
    TRANSFER FROM(DB): CommunityServer - TO(DB): CommunityServerReporting
    --- ---
    2008-11-20 02:14.949965 - BlogCommentData - CalculateVariables(_destDP) - Begin
    Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'csr_BlogCommentData_A'.
    Task: BlogCommentData @ 2008-11-20 02:40:14.949965 : Exited on error.
2008-11-20 02:40:14.949965 - BlogCommentData - TaskBase.Execute() - End

Task: BlogCategoryData @ 2008-11-20 02:40:14.949965 : Task Started.
2008-11-20 02:40:14.949965 - BlogCategoryData - TaskBase.Execute() - Begin
    2008-11-20 02:14.949965 - BlogCategoryData - ReadConfig(node) - Begin
    2008-11-20 02:14.949965 - BlogCategoryData - ReadConfig(node) - End
    --- ---
    TRANSFER FROM(DB): CommunityServer - TO(DB): CommunityServerReporting
    --- ---
    2008-11-20 02:14.949965 - BlogCategoryData - CalculateVariables(_destDP) - Begin
    Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'csr_BlogCategoryData_A'.
    Task: BlogCategoryData @ 2008-11-20 02:40:14.949965 : Exited on error.
2008-11-20 02:40:14.949965 - BlogCategoryData - TaskBase.Execute() - End

 

  • | Post Points: 5
Top 500 Contributor
99 Posts
Points 1,285
Navy#1 replied on Thu, Nov 20 2008 1:53 PM

I am also getting Invalid Object Name errors while running the Harvest Jobs


Task: EventData @ 2008-11-20 02:40:14.996841 : Task Started.
2008-11-20 02:40:14.996841 - EventData - TaskBase.Execute() - Begin
    2008-11-20 02:14.996841 - EventData - ReadConfig(node) - Begin
    2008-11-20 02:14.996841 - EventData - ReadConfig(node) - End
    --- ---
    TRANSFER FROM(DB): CommunityServer - TO(DB): CommunityServerReporting
    --- ---
    2008-11-20 02:15.012467 - EventData - CalculateVariables(_destDP) - Begin
    Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'csr_EventData_A'.
    Task: EventData @ 2008-11-20 02:40:15.012467 : Exited on error.
2008-11-20 02:40:15.012467 - EventData - TaskBase.Execute() - End

 

  • | Post Points: 20
Top 500 Contributor
99 Posts
Points 1,285
Navy#1 replied on Thu, Nov 20 2008 2:19 PM

I fixed the Harvest Error by setting the default schema for the user.  However, even after upgrading Enterprise Search, I still get the error and the Search Job does not run

 

  • | Post Points: 20
Top 10 Contributor
4,034 Posts
Points 61,125
TelligentSupportTeam
Verified by Navy#1

The problem is in CS2008.5 there has been some significant refactoring of hte codebase, meaning that ES pre CS2008.5 is incompatible with ES for CS2008.5 and later (and vice versa).  So by using hte same instance of ES for both CS 2008 SP1 and Harvest (which uses the CS2008.5 binaries) you'll face some problems.  You will need to install two instances of the tasks service - one for the CS2008 SP1 version to use with ES, and another wiht the latest version of the tasks server for Harvest 2.0.  Instructions on installing two instances of the Tasks Service can be found at http://docs.communityserver.com/general-topics/installing-multiple-instances-of-windows-service/ .

  • | Post Points: 25
Not Ranked
Male
1 Posts
Points 20

Hi,

I'm getting the same 'Invalid object name' errors. How did you solve them? Did you solve it by setting the default schema for the user? If so where do you set this?

Thanks

 

 

  • | Post Points: 20
Top 500 Contributor
99 Posts
Points 1,285
Navy#1 replied on Mon, Nov 24 2008 5:46 AM

within SQL Server.  Go to Security --> Logins.  DoubleClick the user,  Go to User Mapping and the set schema for the harvest database.  In my instance, the user owned other schemas as well because I used an existing user.

 

  • | Post Points: 5
Page 1 of 1 (9 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com