SAP Knowledge Base Article - Preview

3322926 - Deadlock with SQL error 129 occurring after implementing Note 3244609


You have successfully implemented the patches recommended in SAP Note 3244609 and are still observing deadlock with the database error message similar to the excerpt below.

Category               ABAP programming error
Except.                CX_SY_OPEN_SQL_DB
Application Component  BC-XXX

Database error number: "SQL code: 129" Database error text: SQL message: transaction rolled back by an internal error: table unique constraint violation on pos=0 for table xxxx

Before this, you can notice errors and cancelations related to transactions using ESH in indexserver traces.

[52xxx]{356xxx}[-1/-1] 2023-04-04 18:18:37.561761 e esh              BuiltinProcedureSearch.cpp(00707) : exception  1: no.2040026  (Basis/Execution/impl/JobExecutorUtil.cpp:666) TID: 52322
    Transaction was canceled
exception throw location:
   0: 0x00007fec33497366 in Execution::JobFinalObjectImpl::checkAndThrowException(bool, bool)+0x272 at Basis/Execution/impl/JobExecutorUtil.cpp:666 (
   1: 0x00007fec33460a55 in Execution::JobObjectImpl::wait(bool, bool)+0x151 at Basis/Execution/impl/JobExecutorImpl.cpp:1025 ( 



HANA 2.0


SAP HANA, enterprise edition all versions


rollback, deadlock, SQL error 129, unique constraint violation, kernel, patch, ESH_SEARCH error: exception 9620008: Query execution failed, DBSQL_SQL_INTERNAL_DB_ERROR , KBA , HAN-DB , SAP HANA Database , 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.