<UCMDB Support Tip>Data push failed to AM with "Certain records will not be coherent" error
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”
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.
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'