SAP Knowledge Base Article - Preview

2961655 - Index fails to be created at phase MAIN_SHDIMP/PARMVNT_SHD during upgrade using SUM tool

Symptom

Error occurs on index creation at phase MAIN_SHDIMP/PARMVNT_SHD, for example:

Upgrade Log Directory:    /usr/sap/<SID>/SUM/abap/log
Log File Name:               PD<timestamp>_PARMVNT_SHD.<SID>

3 ETP000    CREATE
3 ETP000          INDEX "/UI2/CDM_CONVERTAC" ON "/UI2/CDM_CONVERT~"
3 ETP000      ("SO_ACTION")
3 ETP000      PCTFREE 10
3 ETP000      INITRANS 002
3 ETP000      TABLESPACE PSAPSR3
3 ETP000    NOCOMPRESS
3 ETP000   STORAGE (INITIAL     0000000016 K
3 ETP000               NEXT        0000000080 K
3 ETP000               MINEXTENTS  0000000001
3 ETP000               MAXEXTENTS  UNLIMITED
3 ETP000               PCTINCREASE 0000
3 ETP000               FREELISTS   001)
3 ETP000  
2WETP000 10:22:08: Retcode 1024: error in DDL statement for "/UI2/CDM_CONVERT              " - repe
2WETP000 at
2EETP345 10:22:20: Retcode 1024: SQL-error "955-ORA-00955: name is already used by an existing obje
2EETP345 ct" in DDL statement for "/UI2/CDM_CONVERT              "

In the example, error ORA-00955 indicates that index /UI2/CDM_CONVERTAC is already existing on database level, so it is not permitted to create the shadow index with the same name.


Read more...

Environment

Netweaver based systems

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

SQL0601N The name of the object to be created is identical to the existing name, SQL0601N, ORA-00955, ORA-00955: name is already used by an existing object, /UI2/CDM_CONVERT, /UI2/CDM_CONVMSG, /UI2/CDM_CONVORG, /UI2/PB_C_TMMLPD, MAIN_SHDIMP/PARMVNT_SHD, PARMVNT_SHD , KBA , BC-DWB-DIC-AC , ABAP Dictionary Activation and Conversion , 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 for Me (Login required).

Search for additional results

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