GL table error

dapodadadapodada Member Posts: 3
pls Our systems all over have being giving us an error telling us that

'THe GL Table Has being locked by another user'

its benig known over the years to be a system error any quick solution to that.

thank you

Comments

  • kapamaroukapamarou Member Posts: 1,152
    Have you searched the forum for Locked, locks, deadlocks, performace etc?

    There is plenty of info available.
  • ara3nara3n Member Posts: 9,256
    find out who the other user it is and tell them to stop doing that. :mrgreen:



    On serious note, I suggest to get an experienced person to check your system and make sure it running at optimal speed.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • krikikriki Member, Moderator Posts: 9,110
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • dapodadadapodada Member Posts: 3
    The errror table locked by user

    ' The GL Entry Table Can not be Changed because it has bein locked by another user'

    what could be responsible for this DeadLock? It has being an issue on the NAV SQL 2009

    Pls, if anyone has a solution to dat, pls notify me ASAP.
  • kapamaroukapamarou Member Posts: 1,152
    The error you describe is a "big topic". It involves Indexes, Sum Indexes, Performance Optimization, Code reviewing, Locking order, Hardware setup and so on...
    kapamarou wrote:
    Have you searched the forum for Locked, locks, deadlocks, performace etc?

    Did you follow the above advise? Please do a little research and come back with more specific questions... I don't think we can help you much with such a general description.
  • DenSterDenSter Member Posts: 8,305
    dapodada wrote:
    ' The GL Entry Table Can not be Changed because it has bein locked by another user'

    what could be responsible for this DeadLock?
    The error you are describing there is NOT a deadlock.
Sign In or Register to comment.