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.