3321967 - SQL code: 131 on BTCDELAY table | SAP Knowledge Base Article

Symptom

The database is getting hundreds of lock wait timeouts for table BTCDELAY, which generates the following ABAP dumps:

Database error text: SQL message: transaction rolled back by lock wait timeout: TrexColumnUpdate failed on table 'SAPHANADB:BTCDELAY' with error: transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=8162061157, TYPE=RECORD_LOCK, CURRENT_MODE=EXCLUSIVE Return value of the database layer: "SQL dbsl rc: 99"

21:38:23.476193 i TraceContext TraceContext.cpp(01347) : UserName=SAPHANADB, ApplicationUserName=SAPSYS, ApplicationName=ABAP:<SID>, ApplicationSource=SAPMSSY2:8582, Client=<Client>, StatementHash=645899faec5d835fc6e3b8dc5136672f, EppRootContextId=0A98556FE82A1EEDA589C45C00DE363E, EppTransactionId=D68DF2EBB6A503E0E0063C1C354F2B0D, EppConnectionId=00000000000000000000000000000000, EppConnectionCounter=0, EppComponentName=<SID>/<Application_Server>, EppAction=%_EVENT_SCHEDULER, StatementExecutionID=844441291454081

indexserver_ad1hdxsh0001.30003.expensive_statements.508.trc:359125;939;1542430230686581;SAPHANADB;6:SAPSYS;1676026744374855;1800001915;SAPHANADB.BTCDELAY;DELETE;131;transaction rolled back by lock wait timeout: TrexColumnUpdate failed on table 'SAPHANADB:BTCDELAY' with error: transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=13355859153, TYPE=RECORD_LOCK, CURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE],rc=4628;18446744073709551615;1;1800000634;18446744073709551615;18446744073709551615;2;40:<JOB_NAME>,14:SYSTEM_FAILURE;13536;18446744073709551615;1563;0619095F656C1EEDAAA5E9AC5A144260;B52674DE18461A80E0063DE07B18EBCA;00000000000000000000000000000000;0;1676026744374855;13:SAPMSSY2:8582;8:ABAP:<SID>;13357263506;645899faec5d835fc6e3b8dc5136672f;29895656;0;0;_SYS_DEFAULT;5;13;500;844441808084147;;9:SAPHANADB;1076:{

Environment

SAP NetWeaver
SAP NetWeaver Application Server for SAP S/4HANA
ABAP PLATFORM - Application Server ABAP

Product

ABAP platform all versions ; SAP NetWeaver all versions ; SAP Web Application Server for SAP S/4HANA all versions

Keywords

BTCDELAY, SQL code: 131 on BTCDELAY table, SQL, 131, HANA, Database, EVENT_SCHEDULER, RSBTCCNS, SAP_BTC_TABLE_CONSISTENCY_CHECK, BTCTRNS1, TBTCS-DELANFREP , KBA , BC-CCM-BTC , Background Processing , 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.

3321967 - SQL code: 131 on BTCDELAY table