2573065 - Data Hub - Transaction deadlocks on SQL Server 2014 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2573065 - Data Hub - Transaction deadlocks on SQL Server 2014


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]



- Data Hub

- MS SQL Server 2014


SAP Hybris Commerce 6.1


Data Hub, deadlocks , KBA , CEC-COM-HUB , SAP Hybris Data Hub , Problem

About this page

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

Search for additional results

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