recurring locking/contention issues on several critical tables

(1) Share

Report

Posted on by CU04061555-0

2 Microsoft Employee

We would like to report a critical incident affecting our production Microsoft Dynamics 365 Business Central environment integrated with LS Retail.

For five months, we have been experiencing recurring locking/contention issues on several critical tables, which are having a significant impact on our retail operations.

Affected tables:

Sales Line

Item Ledger Entry

Item Journal Line

Preaction

Isolated Storage

Analysis

Replen Planned Stock Demand

These recurring locking issues are causing significant performance degradation, operational disruptions, and delays in retail transactions. We would appreciate Microsoft's assistance in investigating the root cause and providing recommendations to mitigate or resolve these locking/contention problems.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Grigorios Mavrogeorgis 2,272 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

just to be careful - that screenshot only prove the symptom, ILE locked by another session during a warehouse receipt. It does not tell you the cause yet, so I would not commit to one thing. Five months across that many tables can be more than one issue.
Where I would start digging: Inventory Setup, if Automatic Cost Posting is on and adjustment set to Always, posting try to adjust cost inline and lock ILE - worth ruling out by setting adjustment to Never and running Adjust Cost - Item Entries as a night job queue. Then No. Series, if Allow Gaps in Nos. is off it serialize people on the same number. And Preaction with Replen Planned Stock Demand are LS replenishment, check it is not running in the POS peak.

But really you want the actual blocking data, who block who and the SQL, before you decide. Which version you are on?

Hope this help.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards

Gregory Mavrogeorgis

Work: GMSOFT Limited
Blog: Inside Business Central
LinkedIn: www.linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No