Lock on G/L Entry Table

himabindumlh

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

kriki

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]

kine

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.)

himabindumlh

Hi Kamil,

Could you please provide more details what all parameters I need to check and how to check?

kine

Study the performance posts on this forum, study documentation, it is not something you will learn by one post...

David_Singleton

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=254

stryk

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örg