SAP Knowledge Base Article - Preview

3066406 - SQL code: 131" occurred while accessing table

Symptom

The following dump can be seen in the system:

ST22:

DBSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB
DD.MM.YYY HH:MM:SS

 SQL error "SQL code: 131" occurred while accessing table "<TABLE>".   
 Database error text: "SQL message: transaction rolled back by lock wait                       |
|     timeout: Lock-wait time out exceeded [OWNER=<owner id>, TYPE=RECORD_LOCK,                    |
|     CURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]" 


Corresponding dev wp trace:

M  *** WARNING => big time diff
C  *** ERROR => EXECUTE C_0037 on connection 0, rc=131
 [dbslsdb.cpp  10058]
C  SQLCODE    : 131
C  SQLERRTEXT : transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=<owner id>, TYPE=RE\
C               CORD_LOCK, CURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]
C  sc_p=7f76d0bded08,no=37,idc_p=7f76d0c53350,con=0,act=1,slen=<slen>,smax=<smax>,#vars=24,stmt=<stmt id>,table=<table name>
C  stmtid = <3/<table name>                                   /536870913/20180718113238>
C  UPDATE ... <statement text>
C  <statement text>
B  ***LOG BY4=> sql error 131    performing UPD on table <table>                          [dbtrtab      4033]

B  ***LOG BY0=> transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=<owner id>, TYPE=RECORD_LOCK, CURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE] [dbtrtab      4033]


Read more...

Environment

  • SAP Hana Platform Edition 1.0
  • SAP Hana Platform Edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0 ; SAP S/4HANA 1909

Keywords

hana 1.0, hana 2.0, sql code 131, sqlcode 131, 131, record lock, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, lock wait timeout , KBA , HAN-DB-PERF , SAP HANA Database Performance , 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.