Highlighted
Absent Member.
Absent Member.
158 views

<UCMDB Support Tip>Data push failed to AM with "Certain records will not be coherent" error

Symptom:

 

When pushing CIs from UCMDB 10.11 to AM 9.40 through AM adapter, users may see the following error in the UI and Adapter log.

 

Caused by: Error (12,001): This modification alters the behavior of an overflow link. Certain records in the table 'IT equipment' (overflow table of the table 'Portfolio items') will not be coherent with the new structure.

Agent 'COverflowChangeAgent' returned error : '-54

 

 

Solution:

 

 

The message means that error occurred when UCMDB tried to insert data into AM. One possible cause is that the data in UCMDB mismatches the current record in AM.

 

Check the details of Adapter log and look for the below error message.

 

Failed pushing to Asset Manager:

com.hp.ucmdb.adapters.ampush.exception.AMPushDataException: Failed executing AQL: UPDATE amComputer SET BiosAssetTag = null, CPUInternal = 'SPARC-T4 (chipid 0, clock 2998 MHz)', CPUType = 'SPARC-T4 (chipid 0, clock 2998 MHz)', ComputerDesc = 'oracle_corp oracle_sparc_t4_4', ComputerType = 'Unix server computer', OSBuildNumber = 's10s_u11wos_24a', OSServiceLevel = '5.10', OperatingSystem = 'SunOS', PhysicalAddress = '00144F F8FF3E', Portfolio.Asset.SerialNo = '84FBA89A', Portfolio.Asset.sMaxCnxCount = null, Portfolio.CMDBId = '31750407c6bad2476cf2e7d786d84cd7', Portfolio.lModelId = '58405018', Portfolio.zlastlogin = null, Portfolio.znewasst = '0', Portfolio.zucmdb = '1', ScannerDesc = 'Default Inventory Scanner', ScannerVersion = '10.11.000 build 378', TcpIpAddress = '10.240.245.146', TcpIpDomain = null, TcpIpHostName = 'dxb01-sol-hrcnt', Workgroup = null, bGroup = 0, bTcpIpRouting = 0, dtHardScan = #2015-04-14 09:44:40#, dtLastScan = #2015-04-14 14:27:49#, dtNetworkScan = #2015-04-14 09:44:40#, dtSoftScan = #2015-04-14 09:44:40#, fCPUNumber = 2.0, lCPUSpeedMHz = 2998, lDiskSizeMb = 279101.0, lLogicalCPUNumber = 16, lMaxMemory = null, lMemorySizeMb = 16384, lMinMemory = null, lNumCorePerCPU = 1, lNumCorePerSocket = 1, lNumSockets = 2, lSwapSizeMb = 16379 WHERE lComputerId = xxxxxx

 

 

Search the record "lComputerId = xxxxxx" in the table 'IT equipment' on AM side and then remove this record.

After that, re-run the push job on UCMDB. Data push should work successfully.  

 

If errors still occur, please contact with HP support for further investigation.

Cheers,
Alvin Li

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”

Click the KUDOS star on the left to say 'Thanks'
Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.