cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP SUM error in dbclone phase

Go to solution
Former Member

on ‎2015 May 26 6:58 AM

0 Kudos
629

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.

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Nibu
Contributor
‎2015 May 26 7:46 AM
0 Kudos

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,

Show replies
Show replies
Former Member
‎2015 May 26 9:19 AM
0 Kudos

Hi Nibu,

There are no index for the table.

Nibu
Contributor
‎2015 May 26 10:01 AM
0 Kudos

Hi Sudheer, Please check with 'TMSALOG~' .

Ask a Question