Reservation Entry Locking

sdeore
sdeore Member Posts: 9
edited 2009-07-21 in NAV/Navision Classic Client
Hi All,

One of my customer is on NAV 5.00 (build 25653) on sql 2005.
Every sales orders is having 300+ lines and with reservation as always.
while I m trying to post sales orders and the same time another user is creating new sales order there is an error "Reservation entry locked by another user".

After some analysis I'v found the processes taking long time are :
CU 6500 - SumUpItemTracking(T337,TempHandlingSpecification,SumPerLine,SumPerLotSN)
CU 22 - ApplyItemLedgEntry(ItemLedgEntry,OldItemLedgEntry,ValueEntry,CausedByTransfer)
CU 99000845 - ClearSurplus()

Can someone help me on this ?

Thank you have great christmas time :D

Comments

  • nunomaia
    nunomaia Member Posts: 1,153
    It’s difficult to avoid that. Because posting unfortunately has to lock many tables. If you business allows, one way around is to post all your sales invoices during night has a batch.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • kapamarou
    kapamarou Member Posts: 1,152
    Search the forum on Optimization, Deadlocks,Lock Timeout.

    Locking is something that needs to happen for consistency. What you can do is Optimize your database to minimize the duration of your processes, thus minimizing the duration of the locks that are applied.
  • sdeore
    sdeore Member Posts: 9
    Hi Everyone

    Thank you for you replies.

    I am able to solve this issue and the reason behind poor performance (effectively locking) was sqlIndex in NAV 5.00 version. I'v just deleted sqlindex from few tables and the prformance is amazingly fast now.

    Thanks again and Happy New Year.

    - Swapnil
  • fredp1
    fredp1 Member Posts: 86
    Hi,

    I know its been a while since you posted a solution, but can you elborate on the index that you dropped?

    Thanks
    Fred
  • sdeore
    sdeore Member Posts: 9
    Hi Fred,

    Please go through the A222) SQL Index removed under Changes in NAV 5 0 SP1.doc document in 5.01 CD.

    Cheers,

    Swapnil
  • fredp1
    fredp1 Member Posts: 86
    Thanks for the reply.

Categories