Table lock issue after upgrade to the NAV business Central

HarshahnkHarshahnk Colombo, Sri LankaPosts: 6Member
Item Ledger Entry table is locked always . When we checked this no user is entering data to the system but system is locked.

Inventory setup has already adjusted by ;

* Automatic cost posting - No
* Automatic Cost adjustment - Never

Please help me ASAP.

Answers

  • SanderDkSanderDk Posts: 340Member
    Hi @Harshahnk,
    When are you experienced database locks is there a specific task that sets of a lock?
    When you are expirence lock try running page 9511 - Database Locks and see which user is causing it.
    It might clear up why you are have locks. (To get a result with page 9511 you need to to a bit of setting up first https://docs.microsoft.com/en-us/dynamics-nav/monitoring-database-locks)

    If that doesn't give you any help try keeping a eye on the Activity monitor which kind of locks you are getting, and what is causing them.
    For help, do not use PM, but use forum instead, perhaps other people have the same question, or better answers.
  • HarshahnkHarshahnk Colombo, Sri LankaPosts: 6Member
    Dear SanderDk,

    I did this check . but when user has post consumption journal / output journal in the NAV this table lock issue is coming continuously even though there are no any other users using the system same time.

    this kind of situation did not found in the previous NAV2015 version. only this coming after we upgraded the database to the NAV Business Central.
Sign In or Register to comment.