Video Screencast Help

Update Summary Data task failing - Getting invalid resource Guid error

Created: 17 Aug 2012 | 1 comment

Hi,

Altiris NS 7 environment. I am having an issue with Task

 

I am attempting to follow TECH146046 (An unknown exception was thrown while running Update Summary Data task)

I started with the Step 1 to identify the name of the task(s) causing the problem.

  • Run "execute tmselecttaskrunsummarybyresource" against Symantec_CMDB database

           Done

  • Locate ResourceGuid with value '00000000-0000-0000-0000-000000000000'

           Done

  • Identify the TaskItemGuid associated with the zer whereo ResourceGuid
  • Done

           Run the following query:

  • SELECT Name  from Inv_Task_Summary_By_Task
    where TaskItemGuid = '[TASKITEMGUID FROM PREVIOUS STEP HERE]'
When I run the last query I am unable to get the name of the task. The query executes, but no results are returned. Does anyone have any ideas on how to identify the task?  In the past when I have had issues with Task the associated tables were truncated. But that too can have unpredictable results and cause more headaches than one your attempting to fix.

 

Comments 1 CommentJump to latest comment

adsys77's picture

Hi,
use the better solution:

1. Stop Services: „Altiris Client Task Data Loader“ and „Altiris Support Service“

2. Run SQL:
SELECT ti.[TaskInstanceGuid]
,ti.[ResourceGuid]
,ti.[TaskVersionGuid]
,ti.[InstanceType]
,tis.Name
,tis.ExecutedBy
,tis.StartTime
FROM [Symantec_CMDB].[dbo].[TaskInstances] ti
left join TaskInstanceSummaries tis
on ti.TaskInstanceGuid = tis.TaskInstanceGuid
where ti.ResourceGuid like '0000%'

3. Run second SQL:
(copy the TaskInstanceGuid from previous sql)

delete from taskinstanceresults
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstances
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstanceparents
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstancesstarted
where taskinstanceguid = 'put TaskInstanceGuid here'
delete from taskinstancestatus
where taskinstanceguid = 'put TaskInstanceGuid here'

4. Start services from Step 1

5. Start Update Summary Task manually for test

Finished.