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: 

Cant Upgrade to SPAM 26

Former Member

on ‎05-06-2008 8:03 PM

0 Kudos

While i'm upgrading to SPAM 26, i'm getting following error:

1 ETP172 MOVE OF NAMETABS

1 ETP101 transport order : "ALL"

1 ETP102 system : "SCC"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.10" "700"

1 ETP198

3 ETP399XMove Nametabs started in batch mode.

2 ETP399 processing modeflag 'A'

2 ETP301 -

2 ETP364 Begin: Act. of Shadow-Nametabs ("2008/05/06 10:57:09")

2 ETP301 -

2 ETP301 -

2 ETP338XActivation of Shadownametabs

2 ETP301 -

2 ETP301 -

3 ETP365 "0" Shadow-Nametabs activated

3 ETP362 "0" Shadow-Nametab activations failed

2 ETP364 Begin: Act. of Shadow-Nametabs ("2008/05/06 10:57:09")

2 ETP366 End: Act. of Shadow-Nametabs ("2008/05/06 10:57:09")

2 ETP301 -

2 ETP301 -

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2008/05/06 10:57:09"

)

2 ETP301 -

2 ETP399 processing modeflag 'W'

2 ETP301 -

2 ETP347XActivation of Shadownametabs (delete) with DDL

2 ETP301 -

2 ETP301 -

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 ("2008/05/06 10:57:09"

)

2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2008/05/06 10:57:09"

)

2 ETP301 -

2 ETP301 -

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2008/05/06 10:57:09"

)

2 ETP301 -

2 ETP399 processing modeflag 'X'

2 ETP301 -

2 ETP347XActivation of Shadownametabs (delete) with DDL

2 ETP301 -

2 ETP301 -

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 ("2008/05/06 10:57:09"

)

2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2008/05/06 10:57:09"

)

2 ETP301 -

2 ETP301 -

2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2008/05/06 10:57:09"

)

2 ETP301 -

2 ETP399 processing modeflag 'Y'

2 ETP301 -

2 ETP347XActivation of Shadownametabs (delete) with DDL

2 ETP301 -

2 ETP301 -

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 ("2008/05/06 10:57:09"

)

2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2008/05/06 10:57:09"

)

2 ETP301 -

2 ETP301 -

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2008/05/06 10:57:09")

2 ETP301 -

2 ETP399 processing modeflag 'F'

2 ETP301 -

2 ETP330XActivation of Shadownametabs with DDL

2 ETP301 -

3 ETP379X10:57:09: activating Nametab "OCSCCOMPAT":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "OCSCCOMPAT"

3 ETP399 ("COMPONENT" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CRELEASE" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMPR_COMP" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMPR_REL" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SP_NRULE" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "COMPR_SPNR" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SP_DIFF" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT '0000' NOT NULL,

3 ETP399 "COMPR_SPID" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT '0000000000' NOT NULL)

3 ETP399 IN "scc#STABD"

3 ETP399 INDEX IN "scc#STABI"

3 ETP399 LONG IN "scc#STABD"

3 ETP399

2WETP000 10:57:09: Retcode 512: error in DDL statement for "OCSCCOMPAT

" - repea

2WETP000 t

2EETP345 10:57:21: Retcode 512: SQL-error "-204-SQL0204N "scc#STABD" is an unde

fined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "OCSCCOMPAT "

2 ETP399 -

DB-ROLLBACK() -

2EETP334 10:57:21: error in DDL, nametab for "OCSCCOMPAT" not activated

3 ETP379X10:57:21: activating Nametab "OCSSPCOMPR":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "OCSSPCOMPR"

3 ETP399 ("COMPR_SPID" SAPDB6VARCHAR(000010)

3 ETP399 DEFAULT '0000000000' NOT NULL,

3 ETP399 "PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "SHORT_TEXT" SAPDB6VARCHAR(000060)

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 IN "scc#STABD"

3 ETP399 INDEX IN "scc#STABI"

3 ETP399 LONG IN "scc#STABD"

3 ETP399

2WETP000 10:57:21: Retcode 512: error in DDL statement for "OCSSPCOMPR

" - repea

2WETP000 t

2EETP345 10:57:33: Retcode 512: SQL-error "-204-SQL0204N "scc#STABD" is an unde

fined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "OCSSPCOMPR "

2 ETP399 -

DB-ROLLBACK() -

2EETP334 10:57:33: error in DDL, nametab for "OCSSPCOMPR" not activated

3 ETP379X10:57:33: activating Nametab "PAT07_ACP":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PAT07_ACP"

3 ETP399 ("ACP_PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHANGE_PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CONJUNCT" SAPDB6VARCHAR(000002)

3 ETP399 DEFAULT '00' NOT NULL,

3 ETP399 "SEQUENCE" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT '000' NOT NULL,

3 ETP399 "REQ_TYPE" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "REQUMENT" SAPDB6VARCHAR(000040)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CONFLICT_R" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "TRUTH" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "FLAG" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DESCRIPT" SAPDB6VARCHAR(000060)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "scc#STABD"

3 ETP399 INDEX IN "scc#STABI"

3 ETP399 LONG IN "scc#STABD"

3 ETP399

2WETP000 10:57:33: Retcode 512: error in DDL statement for "PAT07_ACP

" - repea

2WETP000 t

2EETP345 10:57:45: Retcode 512: SQL-error "-204-SQL0204N "scc#STABD" is an unde

fined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "PAT07_ACP "

2 ETP399 -

DB-ROLLBACK() -

2EETP334 10:57:45: error in DDL, nametab for "PAT07_ACP" not activated

3 ETP379X10:57:45: activating Nametab "PAT08_ACP":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PAT08_ACP"

3 ETP399 ("ACP_PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHANGE_PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "X_ATTRIB" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CNT" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT '000' NOT NULL,

3 ETP399 "VALUE" SAPDB6VARCHAR(000060)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "FLAG" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "DESCRIPT" SAPDB6VARCHAR(000060)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "scc#STABD"

3 ETP399 INDEX IN "scc#STABI"

3 ETP399 LONG IN "scc#STABD"

3 ETP399

2WETP000 10:57:45: Retcode 512: error in DDL statement for "PAT08_ACP

" - repea

2WETP000 t

2EETP345 10:57:57: Retcode 512: SQL-error "-204-SQL0204N "scc#STABD" is an unde

fined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "PAT08_ACP "

2 ETP399 -

DB-ROLLBACK() -

2EETP334 10:57:57: error in DDL, nametab for "PAT08_ACP" not activated

3 ETP379X10:57:57: activating Nametab "PATACP":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PATACP"

3 ETP399 ("ACP_PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHANGE_PATCH" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHANGE_ORIGIN" SAPDB6VARCHAR(000013)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHANGE_NUMBER" SAPDB6VARCHAR(000007)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHANGE_EXTENSION" SAPDB6VARCHAR(000003)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "scc#STABD"

3 ETP399 INDEX IN "scc#STABI"

3 ETP399 LONG IN "scc#STABD"

3 ETP399

2WETP000 10:57:58: Retcode 512: error in DDL statement for "PATACP

" - repea

2WETP000 t

2EETP345 10:58:10: Retcode 512: SQL-error "-204-SQL0204N "scc#STABD" is an unde

fined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "PATACP "

2 ETP399 -

DB-ROLLBACK() -

2EETP334 10:58:10: error in DDL, nametab for "PATACP" not activated

3 ETP379X10:58:10: activating Nametab "PATCHECK":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "PATCHECK"

3 ETP399 ("OCS_TOOL" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CHECK_NAME" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "ACTIVE" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RET_CODE" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "REASON" SAPDB6VARCHAR(000030)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MESSAGE" SAPDB6VARCHAR(000073)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "IGN_IN_DIA" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "IGN_IN_BTC" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "QUEUE_ID" SAPDB6VARCHAR(000040)

3 ETP399 DEFAULT ' ' NOT NULL)

3 ETP399 IN "scc#BTABD"

3 ETP399 INDEX IN "scc#BTABI"

3 ETP399 LONG IN "scc#BTABD"

3 ETP399

2WETP000 10:58:10: Retcode 512: error in DDL statement for "PATCHECK

" - repea

2WETP000 t

2EETP345 10:58:22: Retcode 512: SQL-error "-204-SQL0204N "scc#BTABD" is an unde

fined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "PATCHECK "

2 ETP399 -

DB-ROLLBACK() -

2EETP334 10:58:22: error in DDL, nametab for "PATCHECK" not activated

3 ETP379X10:58:22: activating Nametab "TRBAT3":

3 ETP355Xstatements:

3 ETP399 CREATE TABLE "TRBAT3"

3 ETP399 ("FUNCTION" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "TRKORR" SAPDB6VARCHAR(000020)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "AS4POS_FRM" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL,

3 ETP399 "AS4POS_TO" SAPDB6VARCHAR(000006)

3 ETP399 DEFAULT '000000' NOT NULL,

3 ETP399 "STATUS" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "RETCODE" SAPDB6VARCHAR(000004)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "TIMESTMP" SAPDB6VARCHAR(000014)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "LOGNAME" SAPDB6VARCHAR(000255)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "PID" SAPDB6VARCHAR(000011)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CLIDEPDT" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "CLIINDEPDT" SAPDB6VARCHAR(000001)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "MODIFIED" INTEGER

3 ETP399 DEFAULT 0 NOT NULL,

3 ETP399 "HOSTNAME" SAPDB6VARCHAR(000032)

3 ETP399 DEFAULT ' ' NOT NULL,

3 ETP399 "ERROR_CNT" INTEGER

3 ETP399 DEFAULT 0 NOT NULL,

3 ETP399 "WARN_CNT" INTEGER

3 ETP399 DEFAULT 0 NOT NULL)

3 ETP399 IN "scc#PROTD"

3 ETP399 INDEX IN "scc#PROTI"

3 ETP399 LONG IN "scc#PROTD"

3 ETP399

2WETP000 10:58:22: Retcode 512: error in DDL statement for "TRBAT3

" - repea

2WETP000 t

2EETP345 10:58:34: Retcode 512: SQL-error "-204-SQL0204N "scc#PROTD" is an unde

fined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "TRBAT3 "

2 ETP399 -

DB-ROLLBACK() -

2EETP334 10:58:34: error in DDL, nametab for "TRBAT3" not activated

2 ETP301 -

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

2 ETP362 "7" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2008/05/06 10:57:09")

2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2008/05/06 10:58:34")

2 ETP301 -

2 ETP301 -

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2008/05/06 10:58:34")

2 ETP301 -

2 ETP399 processing modeflag 'V'

2 ETP301 -

2 ETP330XActivation of Shadownametabs with DDL

2 ETP301 -

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 ("2008/05/06 10:58:34")

2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2008/05/06 10:58:34")

2 ETP301 -

1 ETP172 MOVE OF NAMETABS

1 ETP110 end date and time : "20080506105834"

1 ETP111 exit code : "8"

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

I have applied spam on other SAP system on same server and it works like a charm. But i'm doing on ECC 6.0 and its keep failing. Really need help.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎05-07-2008 7:27 PM
0 Kudos

I made some progress turns out to be that my sid was lower case in index tablespaces because whoever did post steps after system copy on the system he used lower case sid instead uppercase. SO i reran the script on db2 level and and status changed to yellow from red in ST04=> COnfiguration=>Data Classes now when i click on any data class it shows yellow and it give me message saying Missing COnfiguration entry for data - index relationship. Any help will be appreciate it. Thanks in Advance

Show replies
Show replies
Former Member
‎05-06-2008 10:05 PM
0 Kudos

Thanks i read the note but it doesnt have any solution for my problem that i posted on the thread

Show replies
Show replies
Former Member
‎05-06-2008 9:09 PM
0 Kudos

Hi

If you have multiple systems on one server, then your problem can be resolved by following note: 662191. Read it carefully, although it is for upgrade but it relates to the problem you are facing.

Hope this helps.

Regards

Rahul

Show replies
Show replies
Ask a Question