Share
ReportWhen i trying to add/edit/delete any record from this customized table , I am unable to do that and it pops up with the error above mentioned.
ANy suggestions would help , Thanks.
You’re offline. This is a read only version of the page.
1,554
When i trying to add/edit/delete any record from this customized table , I am unable to do that and it pops up with the error above mentioned.
ANy suggestions would help , Thanks.
Hi Tanya,
Yes, if a TSQL user (or external process) is applying an update to the relevant custom table it may be holding SQL Server locks on the table. These locks could block NAV users while the TSQL user's transaction is running. This is certainly a possibility and should be visible in the sp_who2 output at the time the blocking problem is happening.
Hi Tanya,
It seems that your custom table is locked at the SQL Server level at the time you are attempting to add/edit/delete a record. If you are familiar with SQL Server you could try running the TSQL commands 'sp_who2' to see what SQL connection is causing the blocking. You can then investigate what the blocking process is doing (e.g. is it an external batch job or another NAV user etc.)
You can use the DBCC INPUTBUFFER(<connection id>) to see what SQL command the blocking process is running.
You could also consider extending the length of time your blocked process waits before giving up and showing you the error message you have mentioned above. You can do this in the Dynamics NAV Development environment under Files -> Database -> Alter -> Advanced (tab) -> Lock Timeout/Timeout Duration.
There may be issues in your custom C/AL code contributing to the blocking problem, e.g. long running transactions.
If the locking process relates to the G/L Entry table during sales, purchase and service posting then you may get an improvement by avoiding Legacy G/L Entry Locking if that would be appropriate in your environment. See here for more details: docs.microsoft.com/.../hh171562(v=nav.70)
It may also help to upgrade Dynamics NAV to a version that is currently supported by Microsoft, i.e. Dynamics NAV 2016 or later.
If all else fails then consider opening a support ticket with Microsoft via your Solution Provider or Business Central Partner.
I hope that helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
