Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
table purchase line is locked
mpudja
Member Posts: 32
Hi,
we have NAV 5.0 and we using sql server 2005.
In one company when user wants to press F9 Statistics, error appers "The Purchase Line table cannot be changed because it is locked by another user. Wait until the user is finished and then try again".
I have checked in file/database/information --> blocking user Id, also I have executed procedure to see who's blocking table, but I do not get any information.
Can any suggest how to check what's going on ?
we have NAV 5.0 and we using sql server 2005.
In one company when user wants to press F9 Statistics, error appers "The Purchase Line table cannot be changed because it is locked by another user. Wait until the user is finished and then try again".
I have checked in file/database/information --> blocking user Id, also I have executed procedure to see who's blocking table, but I do not get any information.
Can any suggest how to check what's going on ?
0
Answers
one user has started two clients. After loggin off all users from nav, one user was still had one session opened (something like zombie process).
After I killed that process everything is normally.
But, I still don't know why I didn't saw which user was lock the table.