SAP Knowledge Base Article - Preview

2573065 - Data Hub - Transaction deadlocks on SQL Server 2014

Symptom

When running Data Hub on MS SQL Server 2014 database transaction deadlocks can happen:

[ERROR] [c.h.d.s.c.i.CompositionActionHandler] Error during composition
with action id: 65
javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final]
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction
(Process ID 154) was deadlocked on lock resources with another process
and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) ~[sqljdbc42.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4965) ~[sqljdbc42.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1786) ~[sqljdbc42.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1039) ~[sqljdbc42.jar:na]


Read more...

Environment

- Data Hub

- MS SQL Server 2014

Product

SAP Hybris Commerce 6.1

Keywords

Data Hub, deadlocks , KBA , CEC-SCC-INT-DHI , Data Hub Integrations , Problem

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.