Reservation Entry Locking

sdeoresdeore Member Posts: 9
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

  • nunomaianunomaia 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/
  • kapamaroukapamarou 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.
  • sdeoresdeore 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
  • fredp1fredp1 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
  • sdeoresdeore 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
  • fredp1fredp1 Member Posts: 86
    Thanks for the reply.
Sign In or Register to comment.