| Author | Messages | |
Darnell Jordan
 New Poster Posts:16
 | | 08/29/2008 4:34 PM |
| I think I am having problems with my SearchEngineScheduler: I keep getting these errors:  | | Description | Duration (seconds) | Succeeded | Start/End/Next Start | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 55.156 | False | S: 8/29/2008 3:30:27 PM
E: 8/29/2008 3:31:22 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 56.864 | False | S: 8/29/2008 3:29:25 PM
E: 8/29/2008 3:30:22 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 37.564 | False | S: 8/29/2008 3:28:43 PM
E: 8/29/2008 3:29:21 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 42.83 | False | S: 8/29/2008 3:26:37 PM
E: 8/29/2008 3:27:20 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 22.483 | False | S: 8/29/2008 3:25:59 PM
E: 8/29/2008 3:26:21 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 27.767 | False | S: 8/29/2008 3:24:52 PM
E: 8/29/2008 3:25:20 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 22.58 | False | S: 8/29/2008 3:23:58 PM
E: 8/29/2008 3:24:20 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 49.297 | False | S: 8/29/2008 3:22:30 PM
E: 8/29/2008 3:23:19 PM
N: 8/29/2008 3:31:27 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 57.613 | False | S: 8/29/2008 2:53:19 PM
E: 8/29/2008 2:54:17 PM
N: 8/29/2008 3:31:27 PM |
|
|
What is wrong? | | | |
| Darnell Jordan
 New Poster Posts:16
 | | 08/29/2008 4:35 PM |
| | OOPS, forgot to mention I am using DNN 4.8.2. | | | |
| Mitchel Sellers Site Admin/Owner
 Guru Posts:5607
 | | 08/29/2008 4:49 PM |
| Darnell,
Do you have any matching errors in the log file by chance?
| | -Mitchel Sellers MCITP, MCPD, MCTS Director of Development IowaComputerGurus Inc.

3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| Darnell Jordan
 New Poster Posts:16
 | | 08/29/2008 7:01 PM |
| Mitchel, as a matter of fact yes. I was getting the errors listed below. I would end up with up to 100 pages each day on the event viewer with the same error. What I did today was change the scheduler from once an hour to once every 6 hours. Since I made that change 2 hours ago, I have not had ANY errors registered in my Event Viewer. Here is the reoccuring error: AssemblyVersion: 04.08.02 PortalID: -1 PortalName: UserID: -1 UserName: ActiveTabID: -1 ActiveTabName: RawURL: /Forum/tabid/53/view/activetopics/Default.aspx AbsoluteURL: /Forum/tabid/53/view/activetopics/Default.aspx AbsoluteURLReferrer: http://www.lehighacreslive.com/Forum/tabid/53/forumid/54/postid/27209/view/topic/tpage/2/Default.aspx UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: d7e8d529-48e5-499d-86bc-76249ee67e7d InnerException: Could not load file or assembly 'DnnForge.SimpleGallery' or one of its dependencies. The system cannot find the file specified. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.RuntimeTypeHandle._GetTypeByName StackTrace: Message: System.IO.FileNotFoundException: Could not load file or assembly 'DnnForge.SimpleGallery' or one of its dependencies. The system cannot find the file specified. File name: 'DnnForge.SimpleGallery' at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at DotNetNuke.Framework.Reflection.CreateType(String TypeName, String CacheKey, Boolean UseCache, Boolean IgnoreErrors) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. Source: Server Name: MICRO109 | | | |
| Darnell Jordan
 New Poster Posts:16
 | | 08/29/2008 9:04 PM |
| OK, tonight when the DNN search engine schedule kicked it, it generated these errors in the event viewer: AssemblyVersion: 04.08.02 PortalID: -1 PortalName: UserID: -1 UserName: ActiveTabID: -1 ActiveTabName: RawURL: /Home/tabid/36/ctl/Login/Default.aspx?returnurl=%2fHome%2ftabid%2f36%2fDefault.aspx AbsoluteURL: /Home/tabid/36/ctl/Login/Default.aspx AbsoluteURLReferrer: http://www.lehighacreslive.com/Home/tabid/36/ctl/Login/Default.aspx?returnurl=%2fHome%2ftabid%2f36%2fDefault.aspx UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; FunWebProducts-MyWay; FunWebProducts; .NET CLR 1.0.3705; IEMB3; .NET CLR 2.0.50727; IEMB3) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 198d5cf3-4a52-4a55-a7d1-aa42fc6b5c38 InnerException: Could not load file or assembly 'DnnForge.SimpleGallery' or one of its dependencies. The system cannot find the file specified. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.RuntimeTypeHandle._GetTypeByName StackTrace: Message: System.IO.FileNotFoundException: Could not load file or assembly 'DnnForge.SimpleGallery' or one of its dependencies. The system cannot find the file specified. File name: 'DnnForge.SimpleGallery' at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at DotNetNuke.Framework.Reflection.CreateType(String TypeName, String CacheKey, Boolean UseCache, Boolean IgnoreErrors) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. Source: Server Name: MICRO109 EventQueue.ProcessMessage: Message Processing Failed ProcessorType: DotNetNuke.Entities.Modules.EventMessageProcessor, DotNetNuke Body: Sender: BusinessControllerClass: DnnForge.SimpleGallery.Entities.PhotoController, DnnForge.SimpleGallery DesktopModuleId: 141 UpgradeVersionsList: 01.00.00,01.02.00,01.05.00,01.05.01,01.06.00,01.06.01,01.06.02,01.07.00,01.08.00,01.08.01,01.08.02,01.08.03,01.08.04,01.09.01,01.09.02,01.09.03,01.09.04,01.09.05,02.00.00,02.01.02,02.01.05,02.02.00,02.02.06 ExceptionMessage: Value cannot be null. Parameter name: type Server Name: MICRO109 Then results from the scheduler: | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 57.347 | False | S: 8/29/2008 3:47:31 PM
E: 8/29/2008 3:48:29 PM
N: 8/29/2008 8:03:15 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE | Completed re-indexing content | 75.864 | True | S: 8/29/2008 3:46:40 PM
E: 8/29/2008 3:47:56 PM
N: 8/29/2008 9:46:40 PM |
| | | |
| Mitchel Sellers Site Admin/Owner
 Guru Posts:5607
 | | 08/30/2008 12:44 PM |
| Ok, it looks like the errors that you have in the last message are not search related, but they are related to a module un-install that did not go as planned.
What you should be able to do is simply run the following script.
UPDATE EventQueue SET IsCompleted = 1 WHERE IsCompleted = 0
This will ensure that no message processing is going on for the uninstalled module.
Also, you might check to see if this query returns any records.
SELECT * FROM DesktopModules WHERE SupportedFeatures < 0
If it does, update all records to have a value of 0. | | -Mitchel Sellers MCITP, MCPD, MCTS Director of Development IowaComputerGurus Inc.

3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| Darnell Jordan
 New Poster Posts:16
 | | 08/30/2008 8:24 PM |
| Mitchel, when I ran the UPDATE EventQueue
SETIsComplete=1
WHERE IsCompleted=0 I got this return: System.Data.SqlClient.SqlException: Invalid column name 'IsCompleted'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE EventQueue SET IsCompleted = 1 WHERE IsCompleted = 0
|
|  |
 | 
|
When I ran the
SELECT *
FROM DesktopModules
WHERE SupportedFeatures < 0
There was NO returnDoes this make any sense for you? | | | |
| Frozen DNN
 New Poster Posts:4
 | | 08/31/2008 12:09 AM |
| I am sorry to butt in but I am having the same problem and this is my error message. Thanks
System.Data.SqlClient.SqlException: Invalid column name 'IsCompleted'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE EventQueue SET IsCompleted = 1 WHERE IsCompleted = 0 | | | |
| Mitchel Sellers Site Admin/Owner
 Guru Posts:5607
 | | 08/31/2008 1:52 PM |
| I'm incredibly sorry about this, I shouldn't have typed the SQL from memory... Below is the correct script
UPDATE EventQueue SET IsComplete=1 WHERE IsComplete=0
The other query returning no entries is a good thing! | | -Mitchel Sellers MCITP, MCPD, MCTS Director of Development IowaComputerGurus Inc.

3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| Darnell Jordan
 New Poster Posts:16
 | | 08/31/2008 2:00 PM |
| OK Mitchel, this time I got:
[script removed]Run as Script
The Query completed successfully! I appreciate the help. I will give you feedback my friend! Darnell | | | |
| Mitchel Sellers Site Admin/Owner
 Guru Posts:5607
 | | 08/31/2008 2:15 PM |
| Perfect, lets see if this helps!
If not there are a few other things we can look at | | -Mitchel Sellers MCITP, MCPD, MCTS Director of Development IowaComputerGurus Inc.

3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| Darnell Jordan
 New Poster Posts:16
 | | 08/31/2008 3:47 PM |
| OK Mitchel, we did something, but not sure what. Here are the result of the last scheduled search, and below that will be the Event errors created, and there are a bunch.  | | Description | Duration (seconds) | Succeeded | Start/End/Next Start | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE | Completed re-indexing content | 68.563 | True | S: 8/31/2008 2:12:57 PM
E: 8/31/2008 2:14:06 PM
N: 8/31/2008 8:12:57 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 38.063 | False | S: 8/31/2008 2:11:35 PM
E: 8/31/2008 2:12:13 PM
N: 8/31/2008 2:42:14 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 48.533 | False | S: 8/31/2008 2:10:22 PM
E: 8/31/2008 2:11:11 PM
N: 8/31/2008 2:42:14 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 54.907 | False | S: 8/31/2008 2:09:17 PM
E: 8/31/2008 2:10:12 PM
N: 8/31/2008 2:42:14 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 55.25 | False | S: 8/31/2008 2:08:16 PM
E: 8/31/2008 2:09:11 PM
N: 8/31/2008 2:42:14 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 32.674 | False | S: 8/31/2008 2:07:38 PM
E: 8/31/2008 2:08:11 PM
N: 8/31/2008 2:42:14 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 42.924 | False | S: 8/31/2008 2:05:28 PM
E: 8/31/2008 2:06:10 PM
N: 8/31/2008 2:42:14 PM | | DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
| 62.687 | False | S: 8/31/2008 2:04:08 PM
E: 8/31/2008 2:05:10 PM
N: 8/31/2008 2:42:14 PM |
|
|
| | | | | | | |
[script removed]
AssemblyVersion: -1 PortalID: -1 PortalName: UserID: -1 UserName: ActiveTabID: -1 ActiveTabName: RawURL: AbsoluteURL: AbsoluteURLReferrer: UserAgent: DefaultDataProvider: ExceptionGUID: InnerException: Thread was being aborted. FileName: FileLineNumber: -1 FileColumnNumber: -1 Method: StackTrace: Message: System.Threading.ThreadAbortException: Thread was being aborted. at System.Web.PerfCounters.IncrementCounter(AppPerfCounter counter) at System.Web.Caching.CacheSingle.UpdateCache(CacheKey cacheKey, CacheEntry newEntry, Boolean replace, CacheItemRemovedReason removedReason, Object& valueOld) at System.Web.Caching.CacheMultiple.UpdateCache(CacheKey cacheKey, CacheEntry newEntry, Boolean replace, CacheItemRemovedReason removedReason, Object& valueOld) at System.Web.Caching.CacheInternal.DoGet(Boolean isPublic, String key, CacheGetOptions getOptions) at System.Web.Caching.Cache.get_Item(String key) at DotNetNuke.Services.Cache.FileBasedCachingProvider.FBCachingProvider.GetItem(String CacheKey) at DotNetNuke.Common.Utilities.CBO.GetPropertyInfo(Type objType) at DotNetNuke.Common.Utilities.CBO.HydrateObject(Object objObject, IDataReader dr) at DotNetNuke.Common.Utilities.CBO.CreateObject(Type objType, IDataReader dr) at DotNetNuke.Common.Utilities.CBO.FillCollection(IDataReader dr, Type objType) at DotNetNuke.Services.Search.SearchDataStore.GetSearchItems(Int32 ModuleId) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems) at DotNetNuke.Services.Search.SearchEngineScheduler.DoWork() Source: Server Name: MICRO109
|
|
| | |
[script removed]
AssemblyVersion: -1 PortalID: -1 PortalName: UserID: -1 UserName: ActiveTabID: -1 ActiveTabName: RawURL: AbsoluteURL: AbsoluteURLReferrer: UserAgent: DefaultDataProvider: ExceptionGUID: InnerException: Thread was being aborted. FileName: FileLineNumber: -1 FileColumnNumber: -1 Method: StackTrace: Message: System.Threading.ThreadAbortException: Thread was being aborted. at System.Web.PerfCounters.IncrementCounter(AppPerfCounter counter) at System.Web.Caching.CacheSingle.UpdateCache(CacheKey cacheKey, CacheEntry newEntry, Boolean replace, CacheItemRemovedReason removedReason, Object& valueOld) at System.Web.Caching.CacheMultiple.UpdateCache(CacheKey cacheKey, CacheEntry newEntry, Boolean replace, CacheItemRemovedReason removedReason, Object& valueOld) at System.Web.Caching.CacheInternal.DoGet(Boolean isPublic, String key, CacheGetOptions getOptions) at System.Web.Caching.Cache.get_Item(String key) at DotNetNuke.Services.Cache.FileBasedCachingProvider.FBCachingProvider.GetItem(String CacheKey) at DotNetNuke.Common.Utilities.CBO.GetPropertyInfo(Type objType) at DotNetNuke.Common.Utilities.CBO.HydrateObject(Object objObject, IDataReader dr) at DotNetNuke.Common.Utilities.CBO.CreateObject(Type objType, IDataReader dr) at DotNetNuke.Common.Utilities.CBO.FillCollection(IDataReader dr, Type objType) at DotNetNuke.Services.Search.SearchDataStore.GetSearchItems(Int32 ModuleId) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems) at DotNetNuke.Services.Search.SearchEngineScheduler.DoWork() Source: Server Name: MICRO109
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
|
|