Error:An unknown exception was thrown, while running Update Summary Data task

Products

• Management Platform (Formerly known as Notification Server)
• Task Server

Issue/Introduction

The Update Summary Data task fails repeatedly (Console > Settings > Notification Server > Task Settings >  Update Summary Data)

 

An unknown exception was thrown ... Invalid column value 00000000-0000-0000-0000-000000000000, table 'Symantec_CMDB.dbo.ResourceUpdateSummary'; empty GUIDs are not allowed

 

Cause

Rogue tasks were generating empty ResourceGuids in task tables 

 

Resolution

[If you were directed to this article via the SMP Diag utility, skip to Step 2A]

1. Identify the name of the task(s) causing the problem:

A. Run "execute tmselecttaskrunsummarybyresource" against Symantec_CMDB database 

B. Locate ResourceGuid with value '00000000-0000-0000-0000-000000000000'

C. Identify the TaskItemGuid associated with the zero where ResourceGuid

D. Run the following query:

SELECT Name  from Inv_Task_Summary_By_Task

where TaskItemGuid = '[TASKITEMGUID FROM PREVIOUS STEP HERE]'

2. Delete the problem task and any associated custom managed policies that utilize the task.

A. Run the following queries to find out how many requires a cleanup of the existing zero ResourceGuids:

select count (*)  from TaskInstanceresults where taskinstanceguid in (select TaskInstanceGuid from TaskInstances where ResourceGuid = '00000000-0000-0000-0000-000000000000')

select count (*)  from TaskInstanceParents where taskinstanceguid in (select TaskInstanceGuid from TaskInstances where ResourceGuid = '00000000-0000-0000-0000-000000000000')

select count (*)  from TaskInstancesStarted where taskinstanceguid in (select TaskInstanceGuid from TaskInstances where ResourceGuid = '00000000-0000-0000-0000-000000000000')

select count (*)  from TaskInstanceStatus where taskinstanceguid in (select TaskInstanceGuid from TaskInstances where ResourceGuid = '00000000-0000-0000-0000-000000000000')

select count (*)  from TaskInstances where ResourceGuid = '00000000-0000-0000-0000-000000000000'

B. Run the following to delete the 000000000000 Guids.
 

delete from TaskInstanceresults
where taskinstanceguid in (
select TaskInstanceGuid from TaskInstances
where ResourceGuid = '00000000-0000-0000-0000-000000000000')

delete from TaskInstanceParents
where taskinstanceguid in (
select TaskInstanceGuid from TaskInstances
where ResourceGuid = '00000000-0000-0000-0000-000000000000')

delete from TaskInstancesStarted
where taskinstanceguid in (
select TaskInstanceGuid from TaskInstances
where ResourceGuid = '00000000-0000-0000-0000-000000000000')

delete from TaskInstanceStatus
where taskinstanceguid in (
select TaskInstanceGuid from TaskInstances
where ResourceGuid = '00000000-0000-0000-0000-000000000000')

delete from TaskInstances
where ResourceGuid = '00000000-0000-0000-0000-000000000000'
 

Related KBs:

Title: Taskinstances table growing rapidly  TECH144662

Applies To

SMP 7.1 SP1, 7.1 SP2 , 7.1 SP2 MP1