SAP Knowledge Base Article - Preview

2031461 - How to troubleshoot Threads Deadlocking with MS SQL Server 2012

Symptom

When Does a Deadlock Occur?

Deadlocks can happen when:

  • When at least two objects try to access the same resource; each of them trying to get a lock on the resource to avoid a dirty read
    • There is a workaround where the SQL Server could be set with the NO-LOCK option, but this is inelegant because it means disregarding dirty reads. 
  • On a multi-nodes system (clustering).
  • When there is insufficient isolation on the database engine.
  • When there is a mode incompatibility on the hybris platform.

Note: Only MS SQL Server 2008 is fully supported. MS SQL Server 2012 is not supported on hybris releases earlier than hybris Version 5.0.

 

 


Read more...

Environment

Versions 5.0 and earlier

MS SQL Server 2012, 2008 

Product

hybris Commerce Suite 4.4 ; hybris Commerce Suite 4.5 ; hybris Commerce Suite 4.6 ; hybris Commerce Suite 4.7 ; hybris Commerce Suite 4.8 ; hybris Commerce Suite 5.0

Keywords

MS SQL , KBA , CEC-COM-CPS-OTH , Other topics , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.