Table Locking became 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
-
0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions