Anyone know why the purge schedule history would continue to fail?
I SQL clean out the Schedule History, because it has created a gigantic file. Disable the purge schedule history process, then restart. The next day it fails again and again.
Scheduler Exception
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:fce35702-e26a-43d1-873f-27b906e1429d
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:pdGzBrP4+sSA/UEigE68NA==
Message:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This failure occurred while attempting to connect to the routing destination. The duration spent while attempting to connect to the original server was - [Pre-Login] initialization=16; handshake=23; [Login] initialization=0; authentication=0; [Post-Login] complete=0;
StackTrace:
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at PetaPoco.Database.Execute(String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String procedureName, Object[] commandParameters)
at DotNetNuke.Data.DataProvider.PurgeScheduleHistory()
at DotNetNuke.Services.Scheduling.DNNScheduler.PurgeScheduleHistory()
at DotNetNuke.Services.Scheduling.PurgeScheduleHistory.DoWork()
InnerMessage:The wait operation timed out
InnerStackTrace:
Source:.Net SqlClient Data Provider
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name: RD00155DF88E63
Scheduler Event Failure
THREAD ID:50
TYPE:DotNetNuke.Services.Scheduling.PurgeScheduleHistory,DOTNETNUKE
EXCEPTION:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This failure occurred while attempting to connect to the routing destination. The duration spent while attempting to connect to the original server was - [Pre-Login] initialization=16; handshake=23; [Login] initialization=0; authentication=0; [Post-Login] complete=0;
RESCHEDULED FOR:2/3/2016 5:58:02 PM
SOURCE:STARTED_FROM_TIMER
ACTIVE THREADS:0
FREE THREADS:1
READER TIMEOUTS:0
WRITER TIMEOUTS:0
IN PROGRESS:0
IN QUEUE:11
Server Name: RD00155DF88E63