Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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
http://www.mibuso.com/forum/viewtopic.php?f=32&t=48143
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav