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.