Track Table Locking, Navision Userid

DanielF

Hi everyone,

I'm facing problems with table lockings. How can I determine which User sets the lock table command?

On SQL Server I can only see wich service tier blocks on sql process id. But I have actually no clue which User out of NAV sends the lock table command over service tier. Can some one help?

Thanks in advance
Daniel

Slawek_Guzek

In NAV 2017 Dev Envirnoment you have menu option Tools -> Debug -> Database Locks which may tell you which user and where in the C/AL code the table access caused a lock. Not sure if this menu option is available in NAV 2016 Dev Env, certainly not in 2015 or eariler

DanielF

Thanks for your quick reply. Unfortunately the problem occurs on an Nav 2013 Server.

txeriff

I had a query I found on the internet and with that you can see what is locking (nav, external processes) I cant access it now but I suggest google for object locking sql query. I used to put it on excel and easily filter and refresh.