Lock in Many Transactions

redroseredrose Member Posts: 36
Dear all,

Most of my transactions are deadlocked with other users Process.So i searched and tried one solution for reducing the lock. I did some modification in Code in Code Unit 22. I replaced the

IF GlobalItemLedgEntry.FIND('+') THEN

with the Below Code


IF GlobalItemLedgEntry.FINDLAST THEN



But after the Code modification also i am getting the same Lock.Any one please help me to solve this problem.

Users are getting lock when they do--Invoice POst,WR Post, Shipment Post etc.....



Please help ](*,)

Thanks & Regards

Rose

Comments

  • kinekine Member Posts: 12,562
    THis is not your source of problems. If there are deadlocks, you need to look into locking order in the processes which are deadlocking.

    1) You need to find out which two processes are in the deadlock (it would be e.g. two different postings like purchase and sales posting etc.)
    2) You need to look into order in which the tables are locked. You will find out that some tables are locked in oposite order. You need to lock the tables in same order.
    3) You can use client monitor and the "extended" client monitor (can be downloaded as fob from partner source or from download section) to look for more details
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.