Certified Developer v7
|
gabriel.gasse-number41media
-
10/19/2012 5:04:32 PM
Error at SchedulingExecutor.ReInitCorruptedTasks() after upgrading
I'm in the process of upgrading a client's website from 3.1a to 6.0 (working on the 3.1a-->4.0 step at the moment). The update script runs fine, I updated the files just like I did with my previous client, only this time I get this error when I start the site.
[DataConnection.ExecuteQuery]: Query: UPDATE CMS_ScheduledTask SET [TaskName] = @TaskName, [TaskDisplayName] = @TaskDisplayName, [TaskAssemblyName] = @TaskAssemblyName, [TaskClass] = @TaskClass, [TaskInterval] = @TaskInterval, [TaskData] = @TaskData, [TaskLastRunTime] = @TaskLastRunTime, [TaskNextRunTime] = @TaskNextRunTime, [TaskProgress] = @TaskProgress, [TaskLastResult] = @TaskLastResult, [TaskEnabled] = @TaskEnabled, [TaskSiteID] = @TaskSiteID, [TaskDeleteAfterLastRun] = @TaskDeleteAfterLastRun, [TaskServerName] = @TaskServerName, [TaskGUID] = @TaskGUID, [TaskLastModified] = @TaskLastModified, [TaskExecutions] = @TaskExecutions WHERE [TaskID] = @TaskID: caused exception: Must declare the scalar variable "@TaskExecutions".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: UPDATE CMS_ScheduledTask SET [TaskName] = @TaskName, [TaskDisplayName] = @TaskDisplayName, [TaskAssemblyName] = @TaskAssemblyName, [TaskClass] = @TaskClass, [TaskInterval] = @TaskInterval, [TaskData] = @TaskData, [TaskLastRunTime] = @TaskLastRunTime, [TaskNextRunTime] = @TaskNextRunTime, [TaskProgress] = @TaskProgress, [TaskLastResult] = @TaskLastResult, [TaskEnabled] = @TaskEnabled, [TaskSiteID] = @TaskSiteID, [TaskDeleteAfterLastRun] = @TaskDeleteAfterLastRun, [TaskServerName] = @TaskServerName, [TaskGUID] = @TaskGUID, [TaskLastModified] = @TaskLastModified, [TaskExecutions] = @TaskExecutions WHERE [TaskID] = @TaskID: caused exception: Must declare the scalar variable "@TaskExecutions".
Source Error:
Line 159:
Line 160: // Re-initialize tasks which were stopped by application end
Line 161: SchedulingExecutor.ReInitCorruptedTasks();
Line 162: ModuleCommands.NewsletterClearEmailsSendingStatus();
Line 163: EmailInfoProvider.ResetSendingStatus();
Source File: c:\prj\n41\MiaBc\App_Code\Global.asax.cs Line: 161
Stack Trace:
[Exception: [DataConnection.ExecuteQuery]: Query: UPDATE CMS_ScheduledTask SET [TaskName] = @TaskName, [TaskDisplayName] = @TaskDisplayName, [TaskAssemblyName] = @TaskAssemblyName, [TaskClass] = @TaskClass, [TaskInterval] = @TaskInterval, [TaskData] = @TaskData, [TaskLastRunTime] = @TaskLastRunTime, [TaskNextRunTime] = @TaskNextRunTime, [TaskProgress] = @TaskProgress, [TaskLastResult] = @TaskLastResult, [TaskEnabled] = @TaskEnabled, [TaskSiteID] = @TaskSiteID, [TaskDeleteAfterLastRun] = @TaskDeleteAfterLastRun, [TaskServerName] = @TaskServerName, [TaskGUID] = @TaskGUID, [TaskLastModified] = @TaskLastModified, [TaskExecutions] = @TaskExecutions WHERE [TaskID] = @TaskID: caused exception: Must declare the scalar variable "@TaskExecutions".]
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +807
CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +13
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryText, Object[,] parameters, QueryTypeEnum queryType, Boolean transaction) +171
CMS.DataEngine.GeneralConnection.RunQueryObject(Query query, Object[,] parameters) +325
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns) +83
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters) +18
CMS.DataEngine.SimpleDataClass.Update() +120
CMS.DataEngine.AbstractInfo.Update() +444
CMS.Staging.SynchronizedInfo.Update() +26
CMS.Scheduler.TaskInfoProvider.SetTaskInfo(TaskInfo task) +33
CMS.Scheduler.SchedulingExecutor.ReInitCorruptedTasks() +303
Global.FirstRequestInitialization(Object sender, EventArgs e) in c:\prj\n41\MiaBc\App_Code\Global.asax.cs:161
Global.Application_BeginRequest(Object sender, EventArgs e) in c:\prj\n41\MiaBc\App_Code\Global.asax.cs:392
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
|