How do I prevent deadlocks in SAP Business One?

Joel Alar September 6, 2012
Pinterest Stumbleupon Whatsapp

Our company is using SAP Business One 8.80.236 Hotfix1 PL18 and we are experiencing frequent deadlocks. Based on the logs from the SQL detector the deadlock is usually triggered by the SAP addon.

What can be done to prevent this in future?

Ads by Google

  1. Joel Alar
    September 9, 2012 at 8:51 am

    Hi Bruce,
    What storage engine are you using? = Microsoft SQL Server 2008 R2
    What is the transaction load?= Heavy
    Are the deadlocks only occurring at peak transaction times? = NO
    Is it only occurring with specific SAP modules? = Yes, Pick List Addon
    Is it only deadlocking in Accounting, Inventory, or Purchasing or is it happening with transactions throughout the system? = its all in the Pick List Addon
    What type of commands are deadlocking? = its more on select command
    Are you ending up with table locks instead of row locks due to a lack of appropriate indexes with inserts and updates? = No
    Without knowing at least some of these answers, it makes it hard to guess where the problem lies.

  2. Joel Alar
    September 9, 2012 at 8:42 am

    Thanks!, I will try to update our sap to 8.82.

  3. Bruce Epper
    September 6, 2012 at 6:23 pm

    What storage engine are you using? What is the transaction load? Are the deadlocks only occurring at peak transaction times? Is it only occurring with specific SAP modules? Is it only deadlocking in Accounting, Inventory, or Purchasing or is it happening with transactions throughout the system? What type of commands are deadlocking? Are you ending up with table locks instead of row locks due to a lack of appropriate indexes with inserts and updates? Without knowing at least some of these answers, it makes it hard to guess where the problem lies.

  4. susendeep dutta
    September 6, 2012 at 3:43 pm

    Does this deadlock situation existed even before recent hotfix update? Try updating SAP to latest version.