SAP Knowledge Base Article - Preview

2796568 - Cannot create Unique Index SMT_D_TPLN_DSCR~AK; duplicate keys found

Symptom

  • You are running an upgrade to Solution Manager 7.2 SP8 or higher using the Software Update Manager (SUM)

  • You receive following error in the phase MAIN_NEWBAS/PARCONV_UPG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Check Batch job and RETURN CODE in NCONV00.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4 ED0314 PCTINCREASE 0000
4 ED0314 FREELISTS 001)
2 ED0313 SQL error 1452: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
4 EDA093 "DDL Time(___1):" ".........9" milliseconds
2EEGT236 The SQL statement was not executed
2EEDI006 Index " " could not be created completely in the database
2EEGT082 "Index" "SMT_D_TPLN_DSCR-AKY" could not be created
2 EGT067 Request for "SMT_D_TPLN_DSCR" could not be executed
1 ED0302X=========================================================================
1 ED0314 DD: Execution of Database Operations
1 ED0302 =========================================================================
1 ED0327 Process..................: "solman_9_34613"
1EED0319 Return code..............: "8"


1 ED0306 "Preprocessing of TBATG"
1 ED0322 End phase "001" ***********************************************************
1 ED0320XStart phase "002" **********************************************************
1 ED0306 "Partitioning"
1 ED0301 *************************************************************************
1 EGT014XNumber of objects: "1", partition: "1"
1 ED0301X*************************************************************************
1 ED0306 "Partitioning"
1 ED0322 End phase "002" ***********************************************************
1 ED0327XProcess..................: "smpcibpix_40_32464"
2 EGT052XRequest: Create "Index SMT_D_TPLN_DSCR-AKY (DDIC/26.02.19/18:35)"
4 EGT281 sql:
4 ED0313 CREATE UNIQUE INDEX "SMT_D_TPLN_DSCR~AK" ON "SMT_D_TPLN_DSCR"
4 ED0314 ("MANDT",
4 ED0314 "PARENT_KEY",
4 ED0314 "LANGUAGE_CODE")
4 ED0314 PCTFREE 10
4 ED0314 INITRANS 002
4 ED0314 TABLESPACE PSAPSR3
4 ED0314 STORAGE (INITIAL 0000000016 K
4 ED0314 NEXT 0000002560 K
4 ED0314 MINEXTENTS 0000000001
4 ED0314 MAXEXTENTS UNLIMITED
4 ED0314 PCTINCREASE 0000
4 ED0314 FREELISTS 001)
2 ED0313 SQL error 1452: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
4 EDA093 "DDL Time(___1):" ".........8" milliseconds
2EEGT236 The SQL statement was not executed
2EEDI006 Index " " could not be created completely in the database
2EEGT082 "Index" "SMT_D_TPLN_DSCR-AKY" could not be created
2 EGT067 Request for "SMT_D_TPLN_DSCR" could not be executed
1 ED0302X=========================================================================


Read more...

Environment

Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

KBA , SV-SMG-TWB , Test Management , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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.