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

0 Likes

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.

Solution

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. 

Ana Acosta
Software Engineer Asset Manager & Universal Discovery & CMDB
IT Operations Management Micro Focus Software

Labels:

Support Tip
Comment List
Anonymous
Related Discussions
Recommended