KNOWN ISSUE: TS7: Error in log: Could not find stored procedure ''dbo.tmLockTaskInstanceTables''
|Article:TECH122199|||||Created: 2010-02-24|||||Updated: 2010-02-24|||||Article URL http://www.symantec.com/docs/TECH122199|
|NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.|
Looking at our logs, we're seeing the following error:
Date: 18-Feb-10 2:12:08 PM
Tick Count: 26172062
Host Name: LEOALTIRIS
Process: AtrsHost (12156)
Thread ID: 37
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'. ....
TS7 / Task Server v7.x
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]
-- 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.
|Description||Logged in Etrack (Symantec) database|
Article URL http://www.symantec.com/docs/TECH122199