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.
Article Type
Technical Solution


Issue



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'.

....

Environment



TS7 / Task Server v7.x

Cause



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.

Solution



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.


Supplemental Materials

SourceDEFECT
ValueETK 1975996
DescriptionLogged in Etrack (Symantec) database

Legacy ID



51624


Article URL http://www.symantec.com/docs/TECH122199


Terms of use for this information are found in Legal Notices