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]'

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.