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 for Me (Login required).

Search for additional results

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