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
Rogue tasks were generating empty ResourceGuids in task tables
[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:
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