CA Service Management

READPAST Lock Error 

May 03, 2016 11:39 PM

While working with support I found that there is an issue where the CMDB will not commit modifications on the nr object properly if ITAM is 14.1 and SDM is 14.1.2.  The modification will look to commit, the snapshot of the change will be made, but an error in the database will cause a rollback that will remove the modification.  In the logs you will see the following error:

 

SQL Execute Failed: [Microsoft OLE DB Provider for SQL Server] [SQL Code=650 SQL State=42000] You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

 

This error will be corrected by applying cumulative 2 to the ITAM server.  Based on the SQL the error is happening when a trigger on ca_owned_assets is causing updates to tables that are shared by APM & CMDB.

Statistics
0 Favorited
5 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.