SAP Knowledge Base Article - Preview

2681021 - Duplicate key issue in the phase MAIN_SHDCRE/SQLDB_DDNTT_UUID in SUM

Symptom

The SAP Software Update Manager(SUM) encounters duplicate key issue while creating index for table DDNTT~ in the upgrade phase  MAIN_SHDCRE/SQLDB_DDNTT_UUID.

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

SAP ERP 6.0

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-OP-AIX , IBM AIX , Problem

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.