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
Comments
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
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.
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
I know its been a while since you posted a solution, but can you elborate on the index that you dropped?
Thanks
Fred
Please go through the A222) SQL Index removed under Changes in NAV 5 0 SP1.doc document in 5.01 CD.
Cheers,
Swapnil