SAP Knowledge Base Article - Preview

3321967 - SQL code: 131 on BTCDELAY table

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:{


Read more...

Product

SAP NetWeaver 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.