KNOWN ISSUE: TS7: Error in log: Could not find stored procedure ''dbo.tmLockTaskInstanceTables''
Last Updated February 24, 2010
Looking at our logs, we're seeing the following error:
Priority: 1 Date: 18-Feb-10 2:12:08 PM Tick Count: 26172062 Host Name: LEOALTIRIS Process: AtrsHost (12156) Thread ID: 37 Module: AtrsHost.exe Source: Altiris.TaskManagement.Data.TaskExecutionInstance.KillChildInstances Description: TaskExecutionInstance.TryKillChildInstances(): Error killing child instances for 2a2a0cb5-407d-4e8d-ac9d-9de48b4a839b: System.Exception: Unable to execute stored procedure CtsKillChildInstancesNotComplete as scalar ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.tmLockTaskInstanceTables'.
The SQL stored procedure called KillChildInstances calls another stored procedure called tmLockTaskInstanceTables. The second stored procedure does not exist or is missing. This SP is missing on all current installations as of NS 7.0 SP4.
To correct this issue, running the following directly in SQL against the Symantec CMDB database.:
create procedure [dbo].[tmLockTaskInstanceTables] as -- lock each table select top 1 1 from [dbo].[TaskInstances] with( TABLOCK, HOLDLOCK ) select top 1 1 from [dbo].[TaskInstanceParents] with( TABLOCK, HOLDLOCK ) select top 1 1 from [dbo].[TaskInstancesStarted] with( TABLOCK, HOLDLOCK ) select top 1 1 from [dbo].[TaskInstanceStatus] with( TABLOCK, HOLDLOCK ) select top 1 1 from [dbo].[TaskInstanceResults] with( TABLOCK, HOLDLOCK ) select top 1 1 from [dbo].[TaskInputParameterValue] with( TABLOCK, HOLDLOCK ) select top 1 1 from [dbo].[TaskOutputPropertyValue] with( TABLOCK, HOLDLOCK )
This is expected to be corrected in the next release and/or patch of Task Server after SP4 as currently tested.
Applies To TS7 / Task Server v7.x
ID: ETK 1975996
Etrack (Symantec) database
Imported Document ID: TECH122199
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe