Table lock issue after upgrade to the NAV business Central

Harshahnk

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.

SanderDk

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.

Harshahnk

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.