(Asset Manager) Support Tip: Asset Manager Generic Adapter - deadlocks occurring through parallel push


In the event one may experience deadlocks involving Asset Manager table counters when pushing data from UCMDB to AM in Parallel Push -> Multi-processing mode

The Push job consisted of a Node Push and a Software Installations Push query and there were many incidences of the errors below arising from the Portfolio Items and amCounters tables causing many nodes not to be pushed:

[ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.amPortfolio' with unique index 'Asgmt_Code'. The duplicate key value is (<value> ) ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

 ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.


Additional tables for "amAssignment_Code",  "amComputer_Name" and  "amAsset_asstTag" were created using the steps in this link -  https://docs.microfocus.com/itom/Asset_Manager:9.80/TuneMSSQL 

and a full push was reattempted.  This will resolve the issue. 


Support Tip
Comment List