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 information 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-PERF , SAP HANA Database Performance , HAN-LM-INS-SAP , Installation of SAP Systems on HANA , How To

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.