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

Article Id: 156306

Status: Published

Updated On: 26-11-2014 09:09

Legacy Id: TECH187099

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'