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
- 311 Dynamics CRM
- 110 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 locking Problem becomes a major issue !
southindian
Member Posts: 247
Dear all,
Am getting a Table lock error.
Following are the options that i have tried to resolve table locking but i have failed
1. Set the transaction type to "Update Locks" in Property
2. Removed unwanted code and tuned it well.
3. Checked Option like Updating Statistics , indexing the Objects in MS-SQLand it is updated
till date.
But Still we are getting Table lock problem in almost every form , report dataport., especially Sales Line table.
(Kind Note : Recently Our Client has migrated from Version 4.0 to 2009. I felt that due to this This Problem is arising. Kindly Suggest me Best option to resolve this.)
Microsoft Dynamics NAV Classic
The Sales Line table cannot be changed because it is locked by another user.
Wait until the user is finished and then try again.
OK
Kindly Suggest me Best option to resolve this.
With regards,
Vijay
Am getting a Table lock error.
Following are the options that i have tried to resolve table locking but i have failed
1. Set the transaction type to "Update Locks" in Property
2. Removed unwanted code and tuned it well.
3. Checked Option like Updating Statistics , indexing the Objects in MS-SQLand it is updated
till date.
But Still we are getting Table lock problem in almost every form , report dataport., especially Sales Line table.
(Kind Note : Recently Our Client has migrated from Version 4.0 to 2009. I felt that due to this This Problem is arising. Kindly Suggest me Best option to resolve this.)
Microsoft Dynamics NAV Classic
The Sales Line table cannot be changed because it is locked by another user.
Wait until the user is finished and then try again.
OK
Kindly Suggest me Best option to resolve this.
With regards,
Vijay
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
If you did an in place upgrade with a 32 bit SQL Server, you may be hitting memory constraints.
You would get faster responses if you post this in the SQL Performance section and added some more information about your operating environment:
SQL Server 2005 version
Disk configuration
RAM
http://mibuso.com/blogs/davidmachanick/
http://dynamicsuser.net/blogs/stryk/archive/tags/Locking/default.aspx
At first you have to identify the origin of your blocking problem, then you could think about a potential solution (either technical or process wise).
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
- Blocked
- Wait Time (ms)
- Blocking Connection ID
- Blocking User ID
- Blocking Host Name
- Blocking Object