115
Is there any NAV 2013 users who happen get a lots of table locked from user using NAV 2013. Is there any solution to "locked by user" in NAV 2013
p.s:
- locked by another user happen in varies of process and tables
- already ask to nav partner and they havent found the solid solution for this problem
*This post is locked for comments
HI,
"- locked by another user happen in varies of process and tables"...
not normal in standard configutation but possible on big implementations
> if big implementation, use post with job queue technology (Mohana post)
Some issues:
First:
if not a new implementation but an upgrade to NAV 2013, verify that are you using repeteable read instead of serializable locking system
After:
check your sql server configuration
check datafile structure
check free memory\CPU usage on NAV Servers
check TempDB on SQL Server (you need a separate device)
all this issues can reduce thread off on datafiles & indirectly table locks
Last
Use NAV Best Practices Analyzer to check entire system configuration (.. sometimes problem revelator)
You can find more help here
Does it include Posting Sales Documents and Purchase Document?
There is a field called Post with Job Queue in Sales & Receivables setup and Purchase & Payable Setup.
"It Specifies if your business process uses job queues in the background to post sales and purchase documents, including orders, invoices, return orders, and credit memos. Select this check box to enable background posting."
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (