Error: Unable to execute stored procedure CtsStartTaskExecution

Products

• IT Management Suite

Issue/Introduction

Error found in the NS log includes:

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)

Environment

ITMS 7.x, 8.x

Cause

SQL server was renamed and SQL was not updated to reflect this change.

Resolution

Update the server name in SQL as documented in the following KB article:

180029 How to rename SQL server after renaming the server it is installed on