Small and medium business | Business Central, N...

"Item Ledger entry locked by another User" In Navision 2018

(0) Share

Report

Posted on by NeoMatrix

240

Hi All,

I am facing the issue "Item Ledger entry locked by another user" while posting Transfer Order. In Transfer Order, there are huge records in One Transfer Order with LOT Tracking Functionality and Dimension . for eg. In one Item transfer line, it has 5000 lot. When this process is executed by two users simultaneously when the Post button is pressed. Its causing table locking issue.

We are unable to resolve locking issue.

we have tried the following options :

1. Automatic cost Adjustment = Never

2. In NAV Development "Alter database" window in "Transaction log files" in that unrestricted growth is "Checked".\

3. In DB we have set parameters as MAXDOP = 6, Timeout =60 and cost threshold for parallelism = 15.

4. In Navision Created Department wise NAS Services.

5. no changes to Posting code of Transfer Order.

Any suggestions are welcome.

All responses (2)

Answers (0)

NeoMatrix 240 on at

Like (0)

Report

RE: "Item Ledger entry locked by another User" In Navision 2018

Thanks for the Reply.

The Business process is that After Transfer Order execution the Production is generated while Production Order Posting with one user that time another user Post the Transfer order. during the same period which is holding the lock on the Item ledger table. So in that Process, the Massage "Item Ledger entry lock by another user" is a display on Transfer Order user.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: "Item Ledger entry locked by another User" In Navision 2018

If you execute a process by two users at the same time which takes a little longer then you would receive the table lock. Why two users are executing the same process at the same time? I would recommend posting that order when you don't have many users probably before the start of the end or end of the day.