System locks often requiring ledger entries to be compiled why.

(0) Share

Report

Posted on by Leebarn

Hallo.

At work we use MS Dynamics 2016. We experience performance degradation every day due to several “tables being locked by another user” error type problems. One of the ways in which we are able to temporarily resolve this challenge is by compiling vendor ledger entry and savings ledger entry tables. Sometimes we are forced to restart the application server. The system becomes quite fast after compiling the two tables. Is there a permanent solution.

All responses (2)

Answers (0)

Suresh Kulla 43,745 on at

Like (0)

Report

RE: System locks often requiring ledger entries to be compiled why.

Do you see any errors or warnings in the event log? there are many reasons for the table locks, poorly designed code or customization, there is a stryk sql block detection code which will track what causing the table locks and who is causing that may help to analyze the issue and fix it.

dynamicsuser.net/.../blocks-amp-deadlocks-in-nav-with-sql-server
Ahmed Mohamed Rafik 3,049 User Group Leader on at

Like (0)

Report

RE: System locks often requiring ledger entries to be compiled why.

Hi Leebarn,

Please check the folliwng solutions for the same issue:

[View:https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/213488/table-locked-by-another-user-ile-g-l-many-other-tables:750:50]

[View:https://docs.microsoft.com/en-us/dynamics-nav/monitoring-database-locks?redirectedfrom=MSDN:750:50]

If you find this information helpful, Click Yes to Verify the answer to share with other community members.