Track Table Locking, Navision Userid

DanielF
DanielF Member Posts: 21
in NAV Three Tier
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

Comments

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    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
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • DanielF
    DanielF Member Posts: 21
    Thanks for your quick reply. Unfortunately the problem occurs on an Nav 2013 Server.
  • txeriff
    txeriff Member Posts: 515
    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.

Categories