Inventory data classes are missing after changing the computer to Retired and back to Active. Inventory corresponding data is still stored in ResourceUpdateSummary SQL table.

book

Article ID: 157638

calendar_today

Updated On:

Products

Altiris Software Development Kit (ASDK) Inventory Solution

Issue/Introduction

This issue was addressed in Inventory Solution 7.1 SP2 MP1.
For database cleanup scripts see: Inventory hash codes are out of date (http://www.symantec.com/docs/TECH202934)

When a computer resource status is set to "Retired" and then back to "Active" some inventory data classes that had previously existed become missing.

The issue is that when a computer is Retired background process remove the associated inventory data classes to release a license to Inventory Solution. The process that removes the inventory data does not remove the corresponding ResourceUpdateSummary SQL table data. If the computer is set back to Active the inventory data that had previously been contained after reinstatement contained no data. The conflict exists in the ResourceUpdateSummary table.

The ResourceUpdateSummary records are not removed; and records contain hash values that would prevent data with the same hash value from being stored to the inventory data class tables. This would especially effect data classes with essentially fixed data, such as Processor and Serial Number.
 

No error is seen in the logs the error is the missing inventory data classes
 

Resolution

This issue has been fixed in ITMS 7.1 SP2 MP1 

If Asset Management is installed on 7.1 SP2, there is a task called Inventory Clean Up in the System Jobs and Tasks that will remove the conflicting data and allow the inventory data classes to be saved. This task is located in Jobs and Tasks -> System Jobs and Tasks -> Service and Asset Management -> CMDB.

 


Applies To

7.1 SP2

If Asset Management is installed, there is a task called Inventory Clean Up in the System Jobs and Tasks that will remove the conflicting data and allow the inventory data classes to be saved. This task is located in Jobs and Tasks -> System Jobs and Tasks -> Service and Asset Management -> CMDB.