Symptom
The SAP Software Update Manager(SUM) encounters duplicate key issue while creating index for table DDNTT~ in one of the following upgrade phases:
- MAIN_SHDCRE/SQLDB_DDNTT_UUID
- MAIN_SHDCRE/NTACT_NODBPOS
The error in the following pattern can be found in the log file SQLDBSCRIPT.OUT.
**************************
1 ETQ000 ==================================================
1 ETQ399 Executing SQL script '../var/SQLDBSCRIPT.TQL'.
2 ETQ399 Connecting to database '<db type>'.
4 ETQ399 Ignoring uncritical DB statements as requested by user.
4 ETQ010 Date & Time: <time stamp>
3 ETQ398 SQL: DROP INDEX "DDNTT___UPG"
4 ETQ399 Ignoring uncritical DB statements as requested by user.
3 ETQ398 SQL: CREATE UNIQUE INDEX "DDNTT___UPG" on "DDNTT~" ("UUID") ONLINE
4 ETQ010 Date & Time: <time stamp>
1EETQ008 Error message: <DB error>:
1EETQ008 <DB error code>: cannot CREATE UNIQUE INDEX;
1EETQ009Xduplicate keys found
1EETQ003 exit code: "20"
4 ETQ399 Rollback.
**************************
Read more...
Environment
IBM AIX Operating System
Product
Keywords
DDNTT___UPG, DDNTT~, ORA-01452, SQLDB_DDNTT_UUID, AIX, SUM, UPGRADE, UPDATE, SQLDBSCRIPT, INDEX, UNIQUE, DUPLICATE , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-DBI , DB Independent Database Interface , 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.
SAP Knowledge Base Article - Preview