SAP SUM error in dbclone phase

[Former Member]

Dear Experts,

I am facing issue in MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE phase.

Please find the below error log and suggest.

DBCLONE.ELG error log:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CLONING ERRORS and RETURN CODE in DBCLONE01.D01

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DROP TABLE "TMSALOG~"

3 ETGCLN CREATE TABLE "TMSALOG~" ("CNT" VARCHAR2 (000008) DEFAULT '00000000' NOT NULL, "SETSYS" VARCHAR2 (000010) DEFAULT ' ' NOT NULL, "ID" VARCHAR2 (000032) DEFAULT ' ' NOT NULL, "DOMNAM" VARCHAR2 (000010) DEFAULT ' ' NOT NULL, "SYSNAM" VARCHAR2 (000010) DEFAULT ' ' NOT NULL, "CLIENT" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "SERVICE" VARCHAR2 (000010) DEFAULT ' ' NOT NULL, "FUNCTION" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "ERROR" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "SEVERITY" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "TEXT" VARCHAR2 (000100) DEFAULT ' ' NOT NULL, "CONTEXT" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "MSGID" VARCHAR2 (000020) DEFAULT ' ' NOT NULL, "MSGTY" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "MSGNO" VARCHAR2 (000003) DEFAULT '000' NOT NULL, "MSGV1" VARCHAR2 (000050) DEFAULT ' ' NOT NULL, "MSGV2" VARCHAR2 (000050) DEFAULT ' ' NOT NULL, "MSGV3" VARCHAR2 (000050) DEFAULT ' ' NOT NULL, "MSGV4" VARCHAR2 (000050) DEFAULT ' ' NOT NULL, "CURDATE" VARCHAR2 (000008) DEFAULT '00000000' NOT NULL, "CURTIME" VARCHAR2 (000006) DEFAULT '000000' NOT NULL, "CURUSER" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "METHODPTR" VARCHAR2 (000032) DEFAULT ' ' NOT NULL, "EXECMODE" VARCHAR2 (000003) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPD01 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'TMSALOG~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "TMSALOG~0" ON "TMSALOG~" ("CNT", "SETSYS") PCTFREE 10 INITRANS 002 TABLESPACE PSAPD01 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

1EETGCLN ORA-00955: name is already used by an existing object

1EETGCLN TMSALOG

1EETGCLN Error when cloning table structure

###############################################################################################################################

Referred this blog:  ORA-00955: name is already being used by existing object tips

But it dint helped me.

[Nibu · Accepted solution]

HI Sudheer ,

You can drop the index if it already exist  and then proceed the SUM

Sudheer Garigipati wrote:

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'TMSALOG~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "TMSALOG~0" ON "TMSALOG~" ("CNT", "SETSYS") PCTFREE 10 INITRANS 002 TABLESPACE PSAPD01 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

###############################################################################################################################

regards,

[Former Member · Accepted solution]

Hi Nibu,

There are no index for the table.

[Nibu · Accepted solution]

Hi Sudheer, Please check with 'TMSALOG~' .

[former_member182657]

Hi Sudheer,

Please follow command as suggested by Ashutosh,he is correct here.Your issue will be resolved after that.

Good luck !!

[Former Member]

Hi Gaurav and Nicolas,

I have done the steps suggested in Note: 1233860 but issue still persists.

Please find the outputs for the other notes and suggest.

######################################################################################

SQL> select OWNER, INDEX_NAME, TABLE_NAME from DBA_INDEXES where INDEX_NAME='TMSALOG';

no rows selected

######################################################################################

SQL> select owner, object_name, object_type from ALL_OBJECTS where object_name = 'TMSALOG';

OWNER                          OBJECT_NAME

------------------------------ ------------------------------

OBJECT_TYPE

-------------------

SAPD01                         TMSALOG

TABLE

######################################################################################

As per note: 2092401, it suggested to delete the indexes manually. But I did not find the indexes for the table TMSALOG.

[former_member185239]

Hi Sudhir,

You need to fire the below command

sql> select OWNER, INDEX_NAME, TABLE_NAME from DBA_INDEXES where INDEX_NAME='TMSALOG~';

Delete the index of table TMSALOG~ not TMSALOG

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

The result is same. no rows selected

As per note:184436 it is suggested to drop the tables from the shadow schema user.

How can I connect to database with shadow user? I didnt set any password for this user.

[manumohandas82]

Hi Sudheer ,

Please execute the following and get us the results

If your DB is oracle ,

select USERNAME from DBA_USERS;

and

select owner, index_name, table_name from dba_indexes where INDEX_NAME like 'TMSALOG%'

Thanks ,

Manu

[former_member185239]

Hi Sudheer,

Logon to the database

sql> sqlplus "as sysdba"

Now to access the table in shadow system you can use below argument

sapsr3shd.TMSLOG~

select owner, index_name, table_name from sapsr3shd.dba_indexes where INDEX_NAME='TMSALOG~'

With Regards

Ashutosh Chaturvedi

[Reagan]

What you are suggesting is not correct.

"TMSALOG~" is not an index instead it is a shadow table.

The upgrade tool is creating the index "TMSALOG~0"

[Former Member]

I can see that there is an index TMSALOG~0 is still there. The table was deleted by SUM as we can see in DBCLONE.ELG

Now my question is how can I delete or rename this index?

I tried to delete it but no success.

######################################################################################

SQL> select owner, index_name, table_name from dba_indexes where INDEX_NAME like 'TMSALOG%';

OWNER                          INDEX_NAME

------------------------------ ------------------------------

TABLE_NAME

------------------------------

SAPD01                         TMSALOGAR^0

TMSALOGAR~

SAPD01                         TMSALOGAR~0

TMSALOGAR

SAPD01                         TMSALOG~0

TMSALOG1

OWNER                          INDEX_NAME

------------------------------ ------------------------------

TABLE_NAME

------------------------------

SAPD01                         TMSALOG~ID

TMSALOG1

######################################################################################

[manumohandas82]

Hi  Sudheer ,

Believe if you drop the index TMSALOG~0  the issue should be fixed

please execute the following command

SQL> select owner, index_name, table_name from dba_indexes where INDEX_NAME =TMSALOG~0 and

table_name =TMSALOG1

You should get one entry  .

Check the table status  ( whether active and consistent ) of  TMSALOG1 in SE11 and drop the index

Then retry SUM

Thanks ,

Manu

[Former Member]

Thank you for all your support. Issue is resolved by deleting the indexes.

drop index SAPD01."TMSALOG~ID";

drop index SAPD01."TMSALOG~0";

Missed double quotes.

[manumohandas82]

Hi Sudheer ,

Thanks for the update .

Please close the thread

Thanks ,

Manu

[former_member185239]

Hi Reagan,

Sorry i missed the ~0 part.

With Regards

Ashutosh Chaturvedi

[Nicolas]

Hello,

Please check note 2092401 - ORA-09555: name is already used by an existing object during EHP upgrade. To correct the issue, you have to drop the index of the table.

Best regards,

Nicolas

[former_member182657]

Hi,

Have you followed the resolution from SAP Notes   1233860 - ORA-00955 "Name is already used by existing object" &  1844436 - ORA-00955: name is already used by an existing object

Hope this will help you.

Good luck !!