SAP Knowledge Base Article - Preview

3066406 - SQL code: 131 occurred while accessing table

Symptom

  • The following ABAP dump is shown in ST22 transaction code:

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 is referring to below entries:

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 , HAN-DB-ENG , SAP HANA DB Engines , 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.