SAP Knowledge Base Article - Preview

2678230 - "Lock-wait time out exceeded" during phase "MAIN_SWITCH / EU_SWITCH"

Symptom

"Lock-wait time out exceeded" when RENAME_TNEW_T01.TQL is run.
Following informatino can be found in trace.

1 ETQ399 Executing SQL script '../var/RENAME_TNEW_T01.TQL'.
2 ETQ399 Connecting to database 'HDB'.
4 ETQ399 Ignoring uncritical DB statements as requested by user.
4 ETQ010 Date & Time: **************  
3 ETQ398 SQL: RENAME TABLE "TABLENAME~" TO "TABLENAME"
4 ETQ010 Date & Time: **************   
1EETQ008 Error message: DBSL error 99 (db code 129): 
1EETQ008 transaction rolled back by an internal error:
1EETQ009Xindex delete error:Lock-wait time out exceeded [TYPE=RECORD_LOCK,
1EETQ009XCURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]
1EETQ003 exit code: "20"
4 ETQ399 Rollback.

Read more...

Environment

 HANA

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

upgrade, migration, S4HANA, S/4 HANA, hang, exclusive lock, lock_wait_timeout , KBA , HAN-DB , SAP HANA Database , 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.