Device syncing and reconciliation was not occurring for some assets\devices

Document ID : KB000005028
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Having an issue syncing between SAM and APM. It appears the appropriate fields are populated correctly between the 2 systems but reconciliation and data syncing does not occur.

Environment:
CA Asset Portfolio Management 12.9CA Software Asset Management 4.1.3
Cause:

The assets\devices in question had been manually renamed in both APM and SAM causing a duplicate record to be created in the al_discovered_hardware table with the same serial number and mac address. etc. Updates created in APM were creating an update file based on the original name. The device then would not be found in SAM and the update would fail.

 

Resolution:

To resolve the problem, the duplicated records were deleted from the al_discovered_hardware table. The corresponding records were also removed from the arg_reconcile_links table to force a new reconciliation with the correct entry in the al_discovered_hardware table.

Note: The device in SAM must be updated in order for a new record to flow over to the al_discovered_hardware table.

Updates flowed as expected once the asset\devices were reconciled.