search cancel

FATAL error in the reconciliation message queue, and our assets are not matched or reconciled


Article ID: 8663


Updated On:


CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


We are receiving these messages in the reconciliation message queue:

FATAL CA.Applications.HardwareReconciliation.Engine - Asset Match Processing Error: You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

Our assets are not reconciling or matching and the 'Asset Viewer - Discovered information' link is not present on the asset. 



CA Asset Portfolio Management 17.0


This is a known issue in the CA APM 17.0 GA release. 


Contact support for an updated stored procedure named:  AL_SP_GET_MATCH_QUERY_SN_HN.sql

Also, this correction is planned for inclusion in the APM 17.0 #1 Rollup patch