Integration record table locked by another user

(0) Share

Report

Posted on by Community Member Microsoft Employee

User was trying to post a sales credit memo and got the message " operation could not be completed because a record in the integration record table was locked by another user".

I understand if other users are posting documents and you get an lock error. But this looks different to me. The table is unlocked now. Is there a way I can go back and check who locked that table. I am using NAV 2013

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Integration record table locked by another user

thanks , will give it a try
geordie on at

Like (0)

Report

RE: Integration record table locked by another user

Hi, you can use sys.dm_tran_locks dynamic view.

Plese refer to this page for documentation: msdn.microsoft.com/.../ms190345.aspx

Otherwise it's possible to use sp_who and sp_lock standard stored procedures.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Integration record table locked by another user

As we are using NAV 2013 , so the sessions feature inside NAV development environment is not there. Is there a sql query I can use to find out the user who is blocking the tables.