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
Logged in Etrack (Symantec) database
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.