logging Locks

MaikWalter
MaikWalter Member Posts: 2
edited 2012-07-02 in NAV/Navision Classic Client
hi,

we have some problems with some night jobs and table locking.
in our old nav 3,7 we were able to see locking users but in nav 2009 we only see that we were locked.
is there any way to log the lockings in session table?

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Did you swap from native to SQL?

    In native, you could see who was blocking you. In SQL it is not possible to see it in the session that is blocked.
    In the session-table you can see which ID is locking another but you need to start another session to see it.
    You can implement a NAS that regularly controls the Session table and save that info in some other table. A better way would be to do that directly in SQL, but for C/AL developers, this is a little more difficult.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I use this at my customers.

    http://dynamicsuser.net/blogs/stryk/arc ... ripts.aspx
    Marije Brummel | Freelance Business Central Specialist

Categories