Lock on G/L Entry Table
himabindumlh
Member Posts: 24
Hi
I have a problem with lock on G/L Entry table.Multiple users are posting transactions like Sales Invoice,Production Journal etc...And the users are getting the message that G/L entry table is locked.Therefore its blocking their process.
Could anyone please help out what would be the root causes for this and the solution for the same.
Environment : Nav 2009 with SQL Server db size: 20 Gb,db used size: 7GB
I have a problem with lock on G/L Entry table.Multiple users are posting transactions like Sales Invoice,Production Journal etc...And the users are getting the message that G/L entry table is locked.Therefore its blocking their process.
Could anyone please help out what would be the root causes for this and the solution for the same.
Environment : Nav 2009 with SQL Server db size: 20 Gb,db used size: 7GB
0
Comments
-
Because of how NAV is implemented, only 1 user at a time can post.
This way was needed for the native DB that only had tablelocks. For the moment there is no solution to it.
We can only hope that, when the native DB is dismissed, Microsoft redesigns the posting codeunits.
[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Main reason is that the posting took too long and the timeout is short. Check for performance problem on the server (disks, memory, indexes, fragmentation etc.)0
-
Hi Kamil,
Could you please provide more details what all parameters I need to check and how to check?0 -
Study the performance posts on this forum, study documentation, it is not something you will learn by one post...0
-
himabindumlh wrote:Hi
I have a problem with lock on G/L Entry table.Multiple users are posting transactions like Sales Invoice,Production Journal etc...And the users are getting the message that G/L entry table is locked.Therefore its blocking their process.
Could anyone please help out what would be the root causes for this and the solution for the same.
Environment : Nav 2009 with SQL Server db size: 20 Gb,db used size: 7GB
One solution is the RealTime IT solution http://www.mibuso.com/pdinfo.asp?FileID=254David Singleton0 -
Maybe you want to check out this one, as well:
http://dynamicsuser.net/blogs/stryk/archive/2010/05/19/decisions-spring-2010-nav-sql-performance-blocks-and-deadlocks.aspx
http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx
Cheers,
JörgJörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool0
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