Skip to Content
0

error during import (return code 0008)

Jan 11, 2017 at 03:34 PM

543

avatar image
Former Member

When doing all transport import to QAS i get error during import (return code 0008).

The log files as per the same is

Log File: \\NKCC-HQ-DEV1\sapmnt\trans\log\P161102.QAS I1 I2 I3 ED Log Text 3S 3T ###################################### Activate inactive nametabs Transport request : ALL / System : QAS tp path : tp Version and release: 380.13.43 740 processi ng modeflag 'A' Begin: Act ivation of shadow nametabs (2016/11/02 07:15:19) 3S Output of shadow nametabs Begin: Act ivation of shadow nametabs (2016/11/02 07:15:19) End: Ac tivation of shadow name tabs (2016/11/02 07:15:19) Start: Act ivation of shadow name tabs (deletions) with DDL (2016/11/02 07:15:19) processi ng modeflag 'W' 3S Activation of shadow nametabs (deletes) with DDL Start: Act ivation of shadow name tabs (deletions) with DDL (2016/11/02 07:15:19) End: Ac tivation of shadow nametabs (deletions) with DDL (2016/11/02 07:15:19) Start: Act ivation of shadow name tabs (deletions) with DDL (2016/11/02 07:15:19) processi ng modeflag 'X' 3S Activation of shadow nametabs (deletes) with DDL Start: Act ivation of shadow name tabs (deletions) with DDL (2016/11/02 07:15:19) End: Ac tivation of shadow nametabs (deletions) with DDL (2016/11/02 07:15:19) Start: Act ivation of shadow name tabs (deletions) with DDL (2016/11/02 07:15:19) processi ng modeflag 'Y' 3S Activation of shadow nametabs (deletes) with DDL Start: Act ivation of shadow name tabs (deletions) with DDL (2016/11/02 07:15:19) End: Ac tivation of shadow nametabs (deletions) with DDL (2016/11/02 07:15:19) Begin: Ac tivation of shadow nametabs with DDL (2016/11/02 07:15:19) processi ng modeflag 'F' 3T Activation of sample nametabs with appended fields 3S Activate shadow nametab ZQMCIP 3S Commands: CREATE UNIQUE INDEX ZQMCIP~0 ON ZQMCIP (MANDT, ZCIPNO) PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000040960 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001) 8R 07:15:19: Retcode 1024: error in DDL statement for ZQMCIP - repe 8R at 8O Error 955-ORA-00955: name is already used by an existing when executing ADD-FIELD of 8O Error in DDL statement for when executing ADD-FIELD of DB-ROLLBACK() 8O N o DDL commands fo un d for activation of ZQMCIP 3S Activate shadow nametab ZQMPROD 3S Commands: CREATE UNIQUE INDEX ZQMPROD~0 ON ZQMPROD (MANDT, ZPRODNO) PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000040960 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001) 8R 07:15:31: Retcode 1024: error in DDL statement for ZQMPROD - repe 8R at 8O Error 955-ORA-00955: name is already used by an existing when executing ADD-FIELD of 8O Error in DDL statement for when executing ADD-FIELD of DB-ROLLBACK() 8O N o DDL com mands fo un d for activation of ZQMPROD 0 shadow nametabs activated; DDL executed 2 shadow nametab activations resulted in errors Begin: Activation of shadow nametabs with DDL (2016/11/02 07:15:19) End: Ac tivation of shadow nametabs with DDL (2016/11/02 07:15:43) Begin: Ac tivation of shadow nametabs with DDL (2016/11/02 07:15:43) processi ng modeflag 'V' 3S Activation of sample nametabs with appended fields Begin: Ac tivation of shadow nametabs with DDL (2016/11/02 07:15:43) End: Ac tivation of shadow nametabs with DDL (2016/11/02 07:15:43) Begin: Act ivation of shadow nametabs (2016/11/02 07:15:43) 3T Output of shadow nametabs 0 shadow name tabs activated 0 shadow nametab activations resulted in errors Begin: Activation of shadow nametabs (2016/11/02 07:15:43) End: Ac tivation of shadow name tabs (2016/11/02 07:15:43) Activate i nactive nametabs End date and time : 20161102071543 / 8O Ended with return code: ===> 8 <=== ######################################

Kindly assist

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Jan 11, 2017 at 09:47 PM
0

Hi Haron,

Seems index already exists on table that's the reason it is throwing below error.

ORA-00955: name is already used by an existing when executing ADD-FIELD

Check if you already have index ZQMPROD~0 , delete it and reimport TR so that it get created automatically.


Regards,

Harish Karra

Share
10 |10000 characters needed characters left characters exceeded