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

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

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

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

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 , light lo , /cpmb/light_optimize , lite optimize , EPM-BPC-NW , NetWeaver Version , How To