Deadlock or locktable occour while posting in sql 2008 r2

rakeshranjan

Hi all

I am using NAV 6.0 SP1, SQL server 2008 R2. LS retail.
I am faceing problem, i.e each and every time while i post a sale order , or item journal line ,or general journal line or any type of posting , the system give a error , that this is locked by another user , or deadlock occour on table , the table is not specified some time it is journal line dimension , some time ILE, some time sales header.....

please help me on this topic.



Regards
Rakesh Ranjan

Cem_Karaer

How many users are working concurrently on Navision?

sudhakarsv

Seems to be No.of concurrent users are more in number.
Use Batch Posting To avoid the Table Locking issue.
Batch Posting : Documents (PO/SO/Invoice/Journals) will be put in queue and posted according to the priority defined in the batch posting setup.
Can use the standard functionality of LS Retail but need some customization to use batch posting concept.

rakeshranjan

As i am a single user for posting , still same Issues.