got error - table lock - it is used by another person..

JAYESHJAYESH Member Posts: 290
i got errror message ..like item journal table cannot be changes it is used by another user..while i import data.....
JAYESH PATEL

Comments

  • nunomaianunomaia Member Posts: 1,153
    If another user is doing some task that locks item journal, other users must wait. :)
    Can you confirm what the other user is doing?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • JAYESHJAYESH Member Posts: 290
    they only tell me another user used this table..but not mention name...we have lot many user..it is difficult to find it out..

    can u tell me ..it's is journal..fundamental..for navision. if another user working on same table..it locks ???
    JAYESH PATEL
  • nunomaianunomaia Member Posts: 1,153
    On posting it will lock journal batch in SQL Server and all table in native database.

    If that message doesn't disappear you probally have a deadlock or another user is importing somesthing that lock that table. But that normally is custom development.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • JAYESHJAYESH Member Posts: 290
    thanks
    JAYESH PATEL
  • kinekine Member Posts: 12,562
    You can find out more info who is blocking when you look into Session table (File - Database - Information - Sessions - Current Sessions - DrillDown).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.