2578487 - CX_SY_OPEN_SQL_DB exception, Database returned the SQL code 131. Error text: transaction rolled back by lock wait timeout: Lock timeout occurs while waiting RECORD_LOCK of mode EXCLUSIVE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2578487 - CX_SY_OPEN_SQL_DB exception, Database returned the SQL code 131. Error text: transaction rolled back by lock wait timeout: Lock timeout occurs while waiting RECORD_LOCK of mode EXCLUSIVE

Symptom

The following error occurs when running the Lite Optimize data manager (DM) package in SAP Business Planning and Consolidation (BPC), version for SAP NetWeaver:

[Message]
An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause
Database returned the SQL code 131. Error text: transaction rolled back by lock wait timeout: Lock timeout occurs while waiting RECORD_LOCK of mode EXCLUSIVE(TRANSACTION_ID=X, UPDATE_TRANSACTION_ID=Y)
Model: <ModelName>. Package status: SUCCESS
06-Dec-17 4-02-28 PM.png

This error may also appear in the HANA index server log:

C  *** ERROR => EXECUTE C_0520 on connection 0, rc=131 [dbslsdb.cpp  9788]
C  SQLCODE    : 131
C  SQLERRTEXT : transaction rolled back by lock wait timeout: Lock timeout occurs while waiting RECORD_LOCK of mode \
C               EXCLUSIVE(TRANSACTION_ID=129, UPDATE_TRANSACTION_ID=592533764)
C  sc_p=000000000368B300,no=520,idc_p=00000000036F23A0,con=0,act=1,slen=63,smax=256,#vars=1,stmt=00000000066B29E0,table
C  stmtid = <0/SAPLRSAPOADM                            /238026818/20151121024940>
C  SELECT TOP 1 * FROM "RSAPOADM" WHERE "INFOCUBE" = ? FOR UPDATE ;
B  ***LOG BY4=> sql error 131    performing FET on table RSAPOADM [dbdbslst     3763]
B  ***LOG BY0=> transaction rolled back by lock wait timeout: Lock timeout occurs while waiting RECORD_LOCK of mode EXC


Read more...

Environment

  • SAP Business Planning and Consolidation version for SAP NetWeaver
  • SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation, version for SAP NetWeaver all versions ; SAP NetWeaver 7.4

Keywords

EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC, light optimization, module environment failed failure triggered via schedule, compressed infocube manually process chain , KBA , /cpmb/light_optimize , lite optimize , EPM-BPC-NW , NetWeaver Version , How To

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.