while upgrading spam ddl statement is missing

Former Member · ‎04-02-2015

Dear Experts,

find the log

1 ETP199X######################################

1 ETP172 MOVE OF NAMETABS

1 ETP101 transport order : "ALL"

1 ETP102 system : "DEV"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "380.04.07" "720"

1 ETP198

3 ETP399XMove Nametabs started in batch mode.

2 ETP399 processing modeflag 'A'

2 ETP301 ----------------------------------------------------------------------

2 ETP364 Begin: Act. of Shadow-Nametabs ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP338XActivation of Shadownametabs

2 ETP301 ----------------------------------------------------------------------

3 ETP365 "0" Shadow-Nametabs activated

3 ETP362 "0" Shadow-Nametab activations failed

2 ETP364 Begin: Act. of Shadow-Nametabs ("2015/03/31 16:27:07")

2 ETP366 End: Act. of Shadow-Nametabs ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP399 processing modeflag 'W'

2 ETP301 ----------------------------------------------------------------------

2 ETP347XActivation of Shadownametabs (delete) with DDL

2 ETP301 ----------------------------------------------------------------------

3 ETP368 "0" Shadow-Nametabs deleted, DDL executed

3 ETP369 "0" Shadow-Nametab deletions failed

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP399 processing modeflag 'X'

2 ETP301 ----------------------------------------------------------------------

2 ETP347XActivation of Shadownametabs (delete) with DDL

2 ETP301 ----------------------------------------------------------------------

3 ETP368 "0" Shadow-Nametabs deleted, DDL executed

3 ETP369 "0" Shadow-Nametab deletions failed

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP399 processing modeflag 'Y'

2 ETP301 ----------------------------------------------------------------------

2 ETP347XActivation of Shadownametabs (delete) with DDL

2 ETP301 ----------------------------------------------------------------------

3 ETP368 "0" Shadow-Nametabs deleted, DDL executed

3 ETP369 "0" Shadow-Nametab deletions failed

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/03/31 16:27:07")

2 ETP301 ----------------------------------------------------------------------

2 ETP399 processing modeflag 'F'

2 ETP301 ----------------------------------------------------------------------

2 ETP330XActivation of Shadownametabs with DDL

2 ETP301 ----------------------------------------------------------------------

3 ETP379X16:27:07: activating Nametab "CVERS_SUB":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "CVERS_SUB"

3 ETP399 ("SUBCOMP" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SUBREL" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MASTERCOMP" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MASTERREL" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "UNUSED" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2WETP000 16:27:07: Retcode 1024: error in DDL statement for "CVERS_SUB " - repe

2WETP000 at

2EETP345 16:27:19: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.CVERS_SUB" of type "TABLE". SQLSTATE=42710" in DDL

2EETP345 statement for "CVERS_SUB "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:27:19: error in DDL, nametab for "CVERS_SUB" not activated

3 ETP379X16:27:19: activating Nametab "PAD03":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PAD03"

3 ETP399 ("ORIGIN" SAPDB6VARCHAR(000013)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PARCEL_NUM" SAPDB6VARCHAR(000007)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "EXTENSION" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "FROM_REL" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "TO_REL" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "OS" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DB" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PATCH_TYPE" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "ANCESTOR" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "STRICT_SEQ" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "NO_GEN" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SPAMFIX" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "ADDON_ID" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "ADDON_REL" SAPDB6VARCHAR(000012)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "IGN_CONFLI" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "AP_ANCEST" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "EPSFILSIZ" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "HI_ANCEST" SAPDB6VARCHAR(000002)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMP_REL" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMPONENT" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DELIV_DATE" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL,

3 ETP399 "DELIV_TIME" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL)

3 ETP399 IN "DEV#DDICD"

3 ETP399 INDEX IN "DEV#DDICI"

3 ETP399 LONG IN "DEV#DDICD"

3 ETP399

2WETP000 16:27:19: Retcode 1024: error in DDL statement for "PAD03 " - repe

2WETP000 at

2EETP345 16:27:31: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PAD03" of type "VIEW". SQLSTATE=42710" in DDL stat

2EETP345 ement for "PAD03 "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:27:31: error in DDL, nametab for "PAD03" not activated

3 ETP379X16:27:31: activating Nametab "PAT05":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PAT05"

3 ETP399 ("SYSID" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "EPS_MON" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SCENARIO" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "GENERATE" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "BACKUP" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CREATE_DF" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SAVE_DF" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DISP_CONT" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "START_DIR" SAPDB6VARCHAR(000100)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SAVE_LAST" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DEL_FILE" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INACT_IMP" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "C_MODE" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CREATE_VRS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "ONE_PATCH" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "HELP01" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INACTIMPAO" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "HELP02" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MIMPPRC_AO" SAPDB6VARCHAR(000002)

3 ETP399 DEFAULT '00' NOT NULL,

3 ETP399 "BTCHPRC_AO" SAPDB6VARCHAR(000002)

3 ETP399 DEFAULT '00' NOT NULL,

3 ETP399 "QUEUE_CALC" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MODADJ_BND" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "AUTO_SPAU" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DISP_INACT" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DISP_UNUSD" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "REQ_SFXREP" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SMP_USER" SAPDB6VARCHAR(000012)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "R3TRANSPRC" SAPDB6VARCHAR(000002)

3 ETP399 DEFAULT '00' NOT NULL,

3 ETP399 "HELP03" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "HELP04" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DDIC_ACT_SUBSET" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INT_CCHECK" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "NO_STDXPRA" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RTA_SNDFRM" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RTA_SYSTYP" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RTA_CNTACT" SAPDB6VARCHAR(000100)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#BTABD"

3 ETP399 INDEX IN "DEV#BTABI"

3 ETP399 LONG IN "DEV#BTABD"

3 ETP399

2WETP000 16:27:31: Retcode 1024: error in DDL statement for "PAT05 " - repe

2WETP000 at

2EETP345 16:27:43: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PAT05" of type "VIEW". SQLSTATE=42710" in DDL stat

2EETP345 ement for "PAT05 "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:27:43: error in DDL, nametab for "PAT05" not activated

3 ETP379X16:27:43: activating Nametab "PAT06":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PAT06"

3 ETP399 ("COMPONENT" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PATCH_TYPE" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "APPLY" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "USERID" SAPDB6VARCHAR(000012)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHG_DATE" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL)

3 ETP399 IN "DEV#DDICD"

3 ETP399 INDEX IN "DEV#DDICI"

3 ETP399 LONG IN "DEV#DDICD"

3 ETP399

2WETP000 16:27:43: Retcode 1024: error in DDL statement for "PAT06 " - repe

2WETP000 at

2EETP345 16:27:55: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PAT06" of type "VIEW". SQLSTATE=42710" in DDL stat

2EETP345 ement for "PAT06 "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:27:55: error in DDL, nametab for "PAT06" not activated

3 ETP379X16:27:55: activating Nametab "PAT09":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PAT09"

3 ETP399 ("OCS_TOOL" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "QUEUE" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT '000' NOT NULL,

3 ETP399 "SEQUENCE" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT '000' NOT NULL,

3 ETP399 "STEPCOND" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RET_CODE" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MESSAGE" SAPDB6VARCHAR(000073)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "REASON" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SCENARIO" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2WETP000 16:27:55: Retcode 1024: error in DDL statement for "PAT09 " - repe

2WETP000 at

2EETP345 16:28:07: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PAT09" of type "VIEW". SQLSTATE=42710" in DDL stat

2EETP345 ement for "PAT09 "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:28:07: error in DDL, nametab for "PAT09" not activated

3 ETP379X16:28:07: activating Nametab "PAT10B":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PAT10B"

3 ETP399 ("OCS_TOOL" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SEM_STATE" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "JOBNAME" SAPDB6VARCHAR(000032)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "JOBCOUNT" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMMAND" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "REPORT" SAPDB6VARCHAR(000040)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "IMM_START" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SDLSTRTDT" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL,

3 ETP399 "SDLSTRTTM" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL,

3 ETP399 "LASTSTRTDT" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL,

3 ETP399 "LASTSTRTTM" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL,

3 ETP399 "STATUS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#BTABD"

3 ETP399 INDEX IN "DEV#BTABI"

3 ETP399 LONG IN "DEV#BTABD"

3 ETP399

2WETP000 16:28:07: Retcode 1024: error in DDL statement for "PAT10B " - repe

2WETP000 at

2EETP345 16:28:19: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PAT10B" of type "VIEW". SQLSTATE=42710" in DDL sta

2EETP345 tement for "PAT10B "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:28:19: error in DDL, nametab for "PAT10B" not activated

3 ETP379X16:28:19: activating Nametab "PATCONFL":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PATCONFL"

3 ETP399 ("TRKORR1" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "TRKORR2" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "AS4POS" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL,

3 ETP399 "COMPONENT1" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RELEASE1" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMPONENT2" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RELEASE2" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PGMID1" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "OBJECT1" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "OBJ_NAME1" SAPDB6VARCHAR(000120)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PGMID2" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "OBJECT2" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "OBJ_NAME2" SAPDB6VARCHAR(000120)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CONFL_TYPE" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#DDICD"

3 ETP399 INDEX IN "DEV#DDICI"

3 ETP399 LONG IN "DEV#DDICD"

3 ETP399

2WETP000 16:28:19: Retcode 1024: error in DDL statement for "PATCONFL " - repe

2WETP000 at

2EETP345 16:28:31: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PATCONFL" of type "VIEW". SQLSTATE=42710" in DDL s

2EETP345 tatement for "PATCONFL "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:28:31: error in DDL, nametab for "PATCONFL" not activated

3 ETP379X16:28:31: activating Nametab "PATPRDVRS":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PATPRDVRS"

3 ETP399 ("QUEUE_ID" SAPDB6VARCHAR(000040)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PROD_ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "NAME" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VERSION" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VENDOR" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DESCRIPT" SAPDB6VARCHAR(000072)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INSTSTATUS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2WETP000 16:28:31: Retcode 1024: error in DDL statement for "PATPRDVRS " - repe

2WETP000 at

2EETP345 16:28:43: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PATPRDVRS" of type "VIEW". SQLSTATE=42710" in DDL

2EETP345 statement for "PATPRDVRS "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:28:43: error in DDL, nametab for "PATPRDVRS" not activated

3 ETP379X16:28:43: activating Nametab "PATSWFEATR":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PATSWFEATR"

3 ETP399 ("QUEUE_ID" SAPDB6VARCHAR(000040)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PROD_ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "NAME" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VERSION" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VENDOR" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DESCRIPT" SAPDB6VARCHAR(000072)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INSTSTATUS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2WETP000 16:28:43: Retcode 1024: error in DDL statement for "PATSWFEATR " - repe

2WETP000 at

2EETP345 16:28:56: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PATSWFEATR" of type "VIEW". SQLSTATE=42710" in DDL

2EETP345 statement for "PATSWFEATR "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:28:56: error in DDL, nametab for "PATSWFEATR" not activated

3 ETP379X16:28:56: activating Nametab "PRDVERS":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PRDVERS"

3 ETP399 ("ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "NAME" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VERSION" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VENDOR" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DESCRIPT" SAPDB6VARCHAR(000072)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INSTSTATUS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MOD_DATE" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL,

3 ETP399 "MOD_TIME" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2WETP000 16:28:56: Retcode 1024: error in DDL statement for "PRDVERS " - repe

2WETP000 at

2EETP345 16:29:08: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.PRDVERS" of type "VIEW". SQLSTATE=42710" in DDL st

2EETP345 atement for "PRDVERS "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:29:08: error in DDL, nametab for "PRDVERS" not activated

3 ETP379X16:29:08: activating Nametab "STACKCOMPS":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "STACKCOMPS"

3 ETP399 ("STACK_ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INST_ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PROD_ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMP_NAME" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMP_VERS" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMP_SPLVL" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT '0000' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2EETP345 16:29:08: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.STACKCOMPS" of type "VIEW". SQLSTATE=42710" in DDL

2EETP345 statement for "STACKCOMPS "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:29:08: error in DDL, nametab for "STACKCOMPS" not activated

3 ETP379X16:29:08: activating Nametab "STACKHEADR":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "STACKHEADR"

3 ETP399 ("ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "QUEUE_ID" SAPDB6VARCHAR(000040)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "TYPE" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PROD_ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DESCRIPT" SAPDB6VARCHAR(000072)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INSTSTATUS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INST_DATE" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL,

3 ETP399 "INST_TIME" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL,

3 ETP399 "RESPONSIBL" SAPDB6VARCHAR(000012)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "GEN_VERS" SAPDB6VARCHAR(000005)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "GEN_DATE" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL,

3 ETP399 "GEN_TIME" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2EETP345 16:29:08: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.STACKHEADR" of type "VIEW". SQLSTATE=42710" in DDL

2EETP345 statement for "STACKHEADR "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:29:08: error in DDL, nametab for "STACKHEADR" not activated

3 ETP379X16:29:08: activating Nametab "SWFEATURE":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "SWFEATURE"

3 ETP399 ("ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PROD_ID" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "NAME" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VERSION" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "VENDOR" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DESCRIPT" SAPDB6VARCHAR(000072)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INSTSTATUS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MOD_DATE" SAPDB6VARCHAR(000008)

3 ETP399 DEFAULT '00000000' NOT NULL,

3 ETP399 "MOD_TIME" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL)

3 ETP399 IN "DEV#STABD"

3 ETP399 INDEX IN "DEV#STABI"

3 ETP399 LONG IN "DEV#STABD"

3 ETP399

2EETP345 16:29:08: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.SWFEATURE" of type "VIEW". SQLSTATE=42710" in DDL

2EETP345 statement for "SWFEATURE "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:29:08: error in DDL, nametab for "SWFEATURE" not activated

3 ETP379X16:29:08: activating Nametab "TFDIR_INIM":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "TFDIR_INIM"

3 ETP399 ("FUNCNAME" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PNAME" SAPDB6VARCHAR(000040)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "INCLUDE" SAPDB6VARCHAR(000002)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MCASE" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "DEV#DDICD"

3 ETP399 INDEX IN "DEV#DDICI"

3 ETP399 LONG IN "DEV#DDICD"

3 ETP399

2EETP345 16:29:08: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.TFDIR_INIM" of type "VIEW". SQLSTATE=42710" in DDL

2EETP345 statement for "TFDIR_INIM "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:29:08: error in DDL, nametab for "TFDIR_INIM" not activated

2 ETP301 ----------------------------------------------------------------------

3 ETP361 "0" Shadow-Nametabs activated, DDL executed

2 ETP362 "14" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/03/31 16:27:07")

2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2015/03/31 16:29:08")

2 ETP301 ----------------------------------------------------------------------

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/03/31 16:29:08")

2 ETP301 ----------------------------------------------------------------------

2 ETP399 processing modeflag 'V'

2 ETP301 ----------------------------------------------------------------------

2 ETP330XActivation of Shadownametabs with DDL

2 ETP301 ----------------------------------------------------------------------

3 ETP361 "0" Shadow-Nametabs activated, DDL executed

3 ETP362 "0" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/03/31 16:29:08")

2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2015/03/31 16:29:08")

2 ETP301 ----------------------------------------------------------------------

2 ETP364 Begin: Act. of Shadow-Nametabs ("2015/03/31 16:29:08")

2 ETP301 ----------------------------------------------------------------------

2 ETP338XTouch Load of nametabs

2 ETP301 ----------------------------------------------------------------------

3 ETP365 "0" TouchLoad succeeded

3 ETP362 "0" TouchLoad failed

2 ETP364 Begin: TouchLoad of Nametabs ("2015/03/31 16:29:08")

2 ETP366 End: TouchLoad of Shadow-Nametabs ("2015/03/31 16:29:08")

2 ETP301 ----------------------------------------------------------------------

1 ETP172 MOVE OF NAMETABS

1 ETP110 end date and time : "20150331162908"

1 ETP111 exit code : "8"

1 ETP199 ######################################

former_member264034 · ‎06-06-2015

Hi Sagy,

Have you installed this system using deferred table creation?
Please refer to "Note 1151343 - DB6: Using "Deferred Table Creation"".

According to note 1224865 DB6: Materialization of virtual tables:
use the command

db2 " select viewname from syscat.views where TEXT like '% DDL_TABLE%'

to find all virtual tables that may exist in the system.

Regards,
Aidan

james_wong · ‎06-03-2015

Hi Sagy,

The issue reported looks like a DB issue. I will forward your thread to SAP on DB2 for Linux, UNIX, and Windows space so they can further assist you with this issue.

2EETP345 16:29:08: Retcode 1024: SQL-error "-601-SQL0601N The name of the object to be created is

2EETP345 identical to the existing name "SAPDEV.SWFEATURE" of type "VIEW". SQLSTATE=42710" in DDL

2EETP345 statement for "SWFEATURE "

2 ETP399 --------------- DB-ROLLBACK() ---------------

2EETP334 16:29:08: error in DDL, nametab for "SWFEATURE" not activated

Best regards,

James

Former Member · ‎04-02-2015

Hello Sagy,

Please repeat SPAM upgrade once or twice more... I guess it will work in that case.

Regards,

Serhat

AtulKumarJain · ‎04-02-2015

Hi Sagy,

Please check below thread it will surely help you.

BR

AKJ

while upgrading spam ddl statement is missing

Accepted Solutions (0)

Answers (4)

Answers (4)

sap.ui.RichTextEditor conflicting with sap cap app...

Re: Mass Update a Zfield in Std Table with Split &...

Re: Deploy failed. Detail: Request failed with sta...

Re: CAP Autentication error

Re: How to make a REST "PUT" call to a dynamic url...