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

Locking issue in Nav2013 if multiple people are using scanners in the Warehouse

(1) Share

Report

Posted on by Bharath_Kommuru

Hi MVP,

As part of solutioning with third party scanners in Nav2013 (Real time), we were expecting Locking issue in Base Nav in case 50-60 warehouse people uses at the same-time.
Can you please let us know is there any option on how to build a solution to minimize Locking?.. We have couple of options but want to get solid proof solution so that the customer will not run into any issues.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

The first thing you should do is to consider upgrading to the newest version of Business Central. Because your solution is no longer supported.

Table locking in Dynamics NAV is a well known issue and the handling of it depends on what table you are experiencing locking in.

On what table are you experiencing locking? Is it a standard table or a customized table?

Was this reply helpful? Yes No
Bharath_Kommuru 12 on at

Like (0)

Report

Hi Inge M.Bruvik,

Thanks for your reply. Our requirement is for both Standard and Custom table for a different ISV Provider.

Can batching of the requests work considering a time limit of 10 seconds??

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

Batching is generally a good idea. But it depends what you are trying to achieve and what tables you are working with.

I think you have to be much more specific around the issues you have for us to be able to help you.

If you are getting table locking during posting of document and transactions that is one thing. If you get them during entering of sales orders that is another issue.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

Hi, just adding some info.

As Inge mentioned, NAV2013 has been end of support this year.

https://learn.microsoft.com/en-us/lifecycle/products/dynamics-nav-2013-r2

There is a new handling in BC22 if you upgrade to the latest version.

Control database locking behavior
https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave1/smb/dynamics365-business-central/control-database-locking-behavior

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
KTA 1,200 on at

Like (0)

Report

Is that third party accesing to sql directly?

Was this reply helpful? Yes No
Bharath_Kommuru 12 on at

Like (0)

Report

Thanks Inge for your Comments. Appreciate it.

Was this reply helpful? Yes No