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

Article:TECH187099  |  Created: 2012-04-23  |  Updated: 2014-11-26  |  Article URL http://www.symantec.com/docs/TECH187099
Article Type
Technical Solution


Issue



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

 


Error



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

 


Environment



SMP 7.1 SP1, 7.1 SP2 , 7.1 SP2 MP1


Cause



Rogue tasks were generating empty ResourceGuids in task tables 

 


Solution



[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


Attachments

Error details
Task Error.JPG (197 kBytes)
Use this to see how many items should be deleted with the Resolve script
Select problem counts all 0 guid.sql (806 Bytes)


Use this to resolve the issue by deleting any entries with a resource guid of all 0's
Resolve all 0 guid problem.sql (768 Bytes)

Supplemental Materials

SourceETrack
Value3444113
Description

Pointfix for ITMS 7.1 SP2 MP1 Rollup v8


SourceETrack
Value3041068
Description

The issue is already fixed in ITMS 7.5



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


Terms of use for this information are found in Legal Notices