Reservation Entry Locking

sdeore

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

nunomaia

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.

kapamarou

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

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

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

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

Thanks for the reply.