Joel Alar asks:
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?
Browser: Chrome 21
System: Windows server 2008 R2
Tagged: business, mysql, software issue, software tips
System: Windows server 2008 R2
Tagged: business, mysql, software issue, software tips
4 Answers -
susendeep dutta
September 6, 2012Does this deadlock situation existed even before recent hotfix update? Try updating SAP to latest version.
Bruce Epper
September 6, 2012What 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.
Joel Alar
September 9, 2012Thanks!, I will try to update our sap to 8.82.
Joel Alar
September 9, 2012Hi 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.