Mitchel's Forums

Subject: SearchEngineSchedule failing
Prev Next
You are not authorized to post a reply.

AuthorMessages
Darnell JordanUser is Offline
New Poster
New Poster
Posts:16

08/29/2008 4:34 PM  

I think I am having problems with my SearchEngineScheduler: I keep getting these errors:

 
Schedule History
[script removed]
   
 
DescriptionDuration (seconds)SucceededStart/End/Next Start
DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
55.156FalseS: 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.864FalseS: 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.564FalseS: 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.83FalseS: 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.483FalseS: 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.767FalseS: 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.58FalseS: 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.297FalseS: 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.613FalseS: 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 JordanUser is Offline
New Poster
New Poster
Posts:16

08/29/2008 4:35 PM  
OOPS, forgot to mention I am using DNN 4.8.2.
Mitchel SellersUser is Offline
Site Admin/Owner
Guru
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.

View Mitchel Sellers's profile on LinkedIn

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 JordanUser is Offline
New Poster
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 JordanUser is Offline
New Poster
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.347FalseS: 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.864TrueS: 8/29/2008 3:46:40 PM
E: 8/29/2008 3:47:56 PM
N: 8/29/2008 9:46:40 PM

Mitchel SellersUser is Offline
Site Admin/Owner
Guru
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.

View Mitchel Sellers's profile on LinkedIn

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 JordanUser is Offline
New Poster
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 return

Does this make any sense for you?

 

Frozen DNNUser is Offline
New Poster
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 SellersUser is Offline
Site Admin/Owner
Guru
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.

View Mitchel Sellers's profile on LinkedIn

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 JordanUser is Offline
New Poster
New Poster
Posts:16

08/31/2008 2:00 PM  

OK Mitchel, this time I got:


[script removed]Load

[script removed]Run as Script

The Query completed successfully!

 

I appreciate the help. I will give you feedback my friend!

Darnell

Mitchel SellersUser is Offline
Site Admin/Owner
Guru
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.

View Mitchel Sellers's profile on LinkedIn

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 JordanUser is Offline
New Poster
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.

Schedule History
[script removed]
   
 
DescriptionDuration (seconds)SucceededStart/End/Next Start
DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
Completed re-indexing content
68.563TrueS: 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.063FalseS: 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.533FalseS: 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.907FalseS: 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.25FalseS: 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.674FalseS: 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.924FalseS: 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.687FalseS: 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]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]
[script removed]