CA Service Management

READPAST Lock Error 

05-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.

0 Favorited
0 Files

Tags and Keywords


06-06-2016 03:13 PM

Take a look in my DOC too, its about READPAST error:


Publish schema with replication without delete replication (READPAST error)

05-19-2016 06:12 PM

Thanks for the tip Micah!


05-19-2016 02:12 PM

I have SDM is 14.1.1 here, and a offline BOXI replication.


I got the same error. Removing the replication solve the READPAST.


Im trying to find a way to remove READPAST without delete the replication.

05-04-2016 09:19 AM

Thanks for sharing Micah!!  Good find

Jon I.

Related Entries and Links

No Related Resource entered.