he a.logs have the following entries:
Process: w3wp (2768)
Thread ID: 1
Module: w3wp.exe
Source: Altiris.TaskManagement.ClientTask.*
Description: BaseXmlHttpCallback Exception: System.Exception: Unable to execute stored procedure CtsStartTaskExecution ---> System.Data.SqlClient.SqlException: Invalid column name 'ParentTaskInstanceGuid'.
Invalid column name 'TaskVersionGuid'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
--- End of inner exception stack trace ---
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.BulkLoadAssignedResources(DataTable dt, SqlCommand cmd, TaskInstanceGuid taskInstanceGuid, IList`1 assignedResources)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.InsertAssignedResources(SqlCommand cmd, TaskInstanceGuid taskInstanceGuid, IList`1 assignedResources)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.SaveInputParameters(DatabaseContext ctx, ParameterValueCollection inputParams)
at Altiris.TaskManagement.Data.TaskExecutionInstance.OnCreate(DatabaseContext ctx)
at Altiris.TaskManagement.ServerTasks.ServerTaskExecutionInstance.OnCreate(DatabaseContext ctx)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.OnCreate(DatabaseContext ctx)
at Altiris.TaskManagement.Data.TaskExecutionInstance.TryOnCreate(DatabaseContext ctx, Object state)
at Altiris.TaskManagement.Data.AltirisSqlHelper.RepeatForDeadlocks(Int32 retries, Int32 sleep, Object state, RepeatForDeadlocksDelegate func)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.OnCreate()
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.Create()
at Altiris.TaskManagement.BaseTask.CreateTaskInstance(String name, String executedBy, Guid parentTaskInstanceGuid, JobNodeGuid jobNodeGuid, ParameterValueCollection inputParameterValues, IList`1 userRoles)
at Altiris.TaskManagement.ClientTask.BaseClientTask.CreateTaskInstance(String name, String executedBy, Guid parentTaskInstanceGuid, JobNodeGuid jobNodeGuid, ParameterValueCollection inputPropertyValues, IList`1 userRoles)
at Altiris.TaskManagement.BaseTask.ExecuteTask(TaskVersionGuid taskVersionGuid, String name, String executedBy, Guid parentTaskInstanceGuid, JobNodeGuid jobNodeGuid, ParameterValueCollection inputParameterValues, IList`1 userRoles)
at Altiris.TaskManagement.BaseTask.ExecuteTask(TaskVersionGuid taskVersionGuid, String name, ParameterValueCollection inputParameterValues)
at Altiris.TaskManagement.UI.XmlCallback.TaskInstanceRunNow.ProcessQuickRunNow(StringWriter sw)
at Altiris.TaskManagement.UI.XmlCallback.TaskInstanceRunNow.WriteResponse(StringWriter sw)
at Altiris.TaskManagement.Common.XmlHttp.BaseTextXmlHttpCallback.WriteResponseRaw(XmlTextWriter xwr)
at Altiris.TaskManagement.Common.XmlHttp.BaseXmlHttpCallback.ProcessRequest(HttpContext context)
Process: w3wp (2768)
Thread ID: 1
Module: w3wp.exe
Source: Altiris.TaskManagement.Data.AltirisSqlHelper.RepeatForDeadlocks
Description: AltirisSqlHelper.RepeatForDeadlocks(): Failed all retries
Process: w3wp (2768)
Thread ID: 1
Module: w3wp.exe
Source: Altiris.TaskManagement.Data.AltirisSqlHelper.RepeatForDeadlocks
Description: AltirisSqlHelper.RepeatForDeadlocks(): Non-deadlock exception: System.Exception: Unable to execute stored procedure CtsStartTaskExecution ---> System.Data.SqlClient.SqlException: Invalid column name 'ParentTaskInstanceGuid'.
Invalid column name 'TaskVersionGuid'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
--- End of inner exception stack trace ---
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.BulkLoadAssignedResources(DataTable dt, SqlCommand cmd, TaskInstanceGuid taskInstanceGuid, IList`1 assignedResources)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.InsertAssignedResources(SqlCommand cmd, TaskInstanceGuid taskInstanceGuid, IList`1 assignedResources)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.SaveInputParameters(DatabaseContext ctx, ParameterValueCollection inputParams)
at Altiris.TaskManagement.Data.TaskExecutionInstance.OnCreate(DatabaseContext ctx)
at Altiris.TaskManagement.ServerTasks.ServerTaskExecutionInstance.OnCreate(DatabaseContext ctx)
at Altiris.TaskManagement.ClientTask.Data.ClientTaskExecutionInstance.OnCreate(DatabaseContext ctx)
at Altiris.TaskManagement.Data.TaskExecutionInstance.TryOnCreate(DatabaseContext ctx, Object state)
at Altiris.TaskManagement.Data.AltirisSqlHelper.RepeatForDeadlocks(Int32 retries, Int32 sleep, Object state, RepeatForDeadlocksDelegate func)
Process: AtrsHost (1516)
Thread ID: 14
Module: AtrsHost.exe
Source: Altiris.TaskManagement.Data.AltirisSqlHelper.RepeatForDeadlocks
Description: AltirisSqlHelper.RepeatForDeadlocks(): Non-deadlock exception: System.Exception: Unable to execute stored procedure tmCompleteTaskInstance ---> System.Data.SqlClient.SqlException: Procedure or function tmCompleteTaskInstance has too many arguments specified.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
--- End of inner exception stack trace ---
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
at Altiris.TaskManagement.Data.TaskExecutionInstance.OnComplete(DatabaseContext ctx, Int32 returnCode, Boolean success)
at Altiris.TaskManagement.ServerTasks.ServerTaskExecutionInstance.CompleteTask(ExecutionResult result, DatabaseContext ctx)
at Altiris.TaskManagement.Data.TaskExecutionInstance.TryCompleteTask(DatabaseContext ctx, Object state)
at Altiris.TaskManagement.Data.AltirisSqlHelper.RepeatForDeadlocks(Int32 retries, Int32 sleep, Object state, RepeatForDeadlocksDelegate func)
Process: AtrsHost (1516)
Thread ID: 13
Module: AtrsHost.exe
Source: Altiris.TaskManagement.ClientTask.*
Description: Unable to complete task instance request for 57f581fa-9094-4707-ad73-932432ed94f5. System.Exception: Unable to execute stored procedure tmCompleteTaskInstance ---> System.Data.SqlClient.SqlException: Procedure or function tmCompleteTaskInstance has too many arguments specified.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
--- End of inner exception stack trace ---
at Altiris.DotNetLib.Data.DbHelper.ExecuteStoredProcNonQuery(SqlCommand cmd, String Name, Object[] NameTypeValueParams)
at Altiris.TaskManagement.Data.TaskExecutionInstance.OnComplete(DatabaseContext ctx, Int32 returnCode, Boolean success)
at Altiris.TaskManagement.ServerTasks.ServerTaskExecutionInstance.CompleteTask(ExecutionResult result, DatabaseContext ctx)
at Altiris.TaskManagement.Data.TaskExecutionInstance.TryCompleteTask(DatabaseContext ctx, Object state)
at Altiris.TaskManagement.Data.AltirisSqlHelper.RepeatForDeadlocks(Int32 retries, Int32 sleep, Object state, RepeatForDeadlocksDelegate func)
at Altiris.TaskManagement.Data.TaskExecutionInstance.CompleteTask(ExecutionResult result)
at Altiris.TaskManagement.ServerTasks.ServerTaskManager.RecordExecutionOperationResults(IBaseTaskExecutionInstance instance, ExecutionResult res)