CA Service Management

 View Only

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

Tags and Keywords

Comments

Jun 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)

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

May 04, 2016 09:19 AM

Thanks for sharing Micah!!  Good find

Jon I.

Related Entries and Links

No Related Resource entered.