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