SAP Knowledge Base Article - Preview

2681021 - Duplicate key issue for table DDNTT~ during SUM run

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

SAP NetWeaver all versions

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.