Deadlock or locktable occour while posting in sql 2008 r2

rakeshranjan
rakeshranjan Member Posts: 18
edited 2012-01-03 in NAV/Navision Classic Client
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

Answers

  • Cem_Karaer
    Cem_Karaer Member Posts: 281
    How many users are working concurrently on Navision?
    Cem Karaer @ Pargesoft
    Dynamics NAV Developer since 2005
  • sudhakarsv
    sudhakarsv Member Posts: 100
    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.
    Regards,
    S.V.Sudhakar
  • rakeshranjan
    rakeshranjan Member Posts: 18
    As i am a single user for posting , still same Issues.

Categories