 |
|
|
 |
Joined: 1/30/2007
Posts: 690
|
|
|
Ok... midnight here now so I see what happens with leaving it all disabled except the 2 forum email schedule items.
In the time it took from my post about the errors until now... there have been over 250 errors come up in the log. With my settings I've no idea how that can be.
Hoping someone can help point me the right way... DNN setup tables, files etc... wherever I need to start looking to find out what's wrong.
Even managed to kinda break this thread in DNN!
|
| |
|
|
 | |
|
|
|
Joined: 1/30/2007
Posts: 690
|
|
|
Now... been 7hrs running like that and looks like an average of 4 errors per minute. That is with just the 2 email schedule items selected.
Errors all just seem to be the same now though (plus some bots & a DotNetNuke.Entities.Modules.EventMessageProcessor, DotNetNuke I think I can fix):
| 23/03/2008 05:37:01 Scheduler Exception AssemblyVersion: -1; PortalID: -1; PortalName ... |
AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Scheduling.DNNScheduling.SqlDataProvider.GetSchedule(String Server) at DotNetNuke.Services.Scheduling.DNNScheduling.SchedulingController.GetSchedule(String Server) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.LoadQueueFromTimer() at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.Start()
Source:
Server Name: DEDL55
|
|
Looking into that message... is it something a table could be turning up, or in the DNN files (or a combination)?
The only way forward I can think of now... full backup, then start copying files over from the fresh DNN 4.6.2 installation folder into this one, just a folder at a time. Then I will look at config type files.
Are there certain tables in the database I should look into and possibly compare? Tables for just setup & DNN stuff behind the scenes? Will look at what I can to find out where possible errors or glitches may have happened.
|
| |
|
|
| |
|
|
|
Joined: 1/30/2007
Posts: 690
|
|
|
On the file replacements... in the bin folder I noticed the following when changing from old to new.
RadCalendar.Net2.dll went from 352Kb to 344Kb
RadTreeView.Net2.dll went from 268Kb to 260Kb
Also in the DotNetNuke.Data.Log:
| DotNetNuke.Data.Log |
No. |
| System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_EventLogTypes'. Cannot insert duplicate key in object 'dbo.tacuk_EventLogTypes'. |
10 |
| Violation of PRIMARY KEY constraint 'PK_EventLogTypes'. Cannot insert duplicate key in object 'dbo.tacuk_EventLogTypes'. |
45 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_Permission'. Cannot insert duplicate key in object 'dbo.tacuk_Permission'. |
6 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_Schedule'. Cannot insert duplicate key in object 'dbo.tacuk_Schedule'. |
9 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_SearchCommonWords'. Cannot insert duplicate key in object 'dbo.tacuk_SearchCommonWords'. |
369 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_SearchIndexer'. Cannot insert duplicate key in object 'dbo.tacuk_SearchIndexer'. |
1 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_EventLogConfig'. Cannot insert duplicate key in object 'dbo.tacuk_EventLogConfig'. |
11 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_DesktopModules'. Cannot insert duplicate key in object 'dbo.tacuk_DesktopModules'. |
28 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_Lists'. Cannot insert duplicate key in object 'dbo.tacuk_Lists'. |
357 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_ModuleControls'. Cannot insert duplicate key in object 'dbo.tacuk_ModuleControls'. |
107 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_ModuleDefinitions'. Cannot insert duplicate key in object 'dbo.tacuk_ModuleDefinitions'. |
28 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_Modules'. Cannot insert duplicate key in object 'dbo.tacuk_Modules'. |
13 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_TabModules'. Cannot insert duplicate key in object 'dbo.tacuk_TabModules'. |
13 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_TabPermission'. Cannot insert duplicate key in object 'dbo.tacuk_TabPermission'. |
13 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_Tabs'. Cannot insert duplicate key in object 'dbo.tacuk_Tabs'. |
13 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_ModuleSettings'. Cannot insert duplicate key in object 'dbo.tacuk_ModuleSettings'. |
23 |
| Violation of PRIMARY KEY constraint 'PK_tacuk_ProfilePropertyDefinition'. Cannot insert duplicate key in object 'dbo.tacuk_ProfilePropertyDefinition'. |
19 |
| The statement has been terminated. |
1056 |
| at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) |
1 |
| at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) |
1 |
| at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) |
1 |
| at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) |
1 |
| at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) |
1 |
| at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) |
1 |
| at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() |
1 |
| at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) |
1 |
| at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) |
1 |
some of that might be perfectly normal... but I just don't know!
Apart from all that (& without going into desktop modules) everything else looked the same... (apart from some Locale files but was to be expected)
Will see what I can in the database... stored queries etc... must be something not right somewhere!
|
| |
|
|
| |
|
|
|
Joined: 1/30/2007
Posts: 690
|
|
|
Well.. the Rad* files just affected the Sigma Live, but that was easily fixed. Other things, little difference.
I restarted the Schedule with just 2 schedule items enabled, and checked the history of those which say they run ok (but still email is not actually sent - schedule history says there's none to send!).
I think there must be a problem with the schedule module itself. What can I check on to sort this? Within the database I am expecting as the files seem ok (I think) since I went through them all.
The error message is:
| 23/03/2008 18:32:48 Scheduler Exception AssemblyVersion: -1; PortalID: -1; PortalName ... |
AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Scheduling.DNNScheduling.SqlDataProvider.GetSchedule(String Server) at DotNetNuke.Services.Scheduling.DNNScheduling.SchedulingController.GetSchedule(String Server) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.LoadQueueFromTimer() at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.Start()
Source:
Server Name: DEDL55
|
|
Any help please?
Would it be a bad idea to upgrade from 4.6.2? I heard 4.7 has some probs for modules I may have, but think 4.8.2 would be the way to go. Would upgrading to 4.8.2 be possible direct from 4.6.2, or do I need to go to 4.7 on the way (& run the installer too)?
Thanks
|
| |
|
|
| |
|
|
|
Joined: 1/30/2007
Posts: 690
|
|
|
Battling on as best I can... I updated from DNN v4.6.2 to v4.8.2 - and no errors showing at all! Was very easy too so recommend just doing it (but backup everything first)
Unfortunately still not single any forum notifications at all, but going through tests, settings etc to do the best I can. At least scheduler appears to be running without probs.
Is it true - Scheduler may not actually work if using Windows Authentication? Found someone saying that here (and noone says otherwise) - http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/108/threadid/161032/scope/posts/Default.aspx
|
| |
|
|
| |