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

book

Article ID: 8663

calendar_today

Updated On:

Products

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

Issue/Introduction

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. 

 

Cause

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

Environment

CA Asset Portfolio Management 17.0

Resolution

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