READPAST Lock Error

Document created by micah.garsidewhite on May 4, 2016
Version 1Show Document
  • View in full screen mode

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.

Attachments

    Outcomes