Table lock issue after upgrade to the NAV business Central

Harshahnk
Harshahnk Member Posts: 9
in NAV Three Tier
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

  • SanderDk
    SanderDk Member Posts: 507
    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, use forum instead, perhaps other people have the same question, or better answers.
  • Harshahnk
    Harshahnk Member Posts: 9
    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.

Categories