Spam/saint error - problem

[Former Member]

Hi

I updating the SPAM/SAINT update of the version SAPKD62026. while i am trying to do the job it triggered the following error:

The following details help you to analyze the problem:

- Error in phase: IMPORT_PROPER

- Reason for error: TP_STEP_FAILURE

- Return code: 0008

- Error message: OCS Package ALL, tp step "6", return code 0008

Notes on phase IMPORT_PROPER

In this phase repository objects and table entries are imported. This

phase can terminate due to the following reasons:

after refering few post i have run the program RDDMNTAB and it shows

Transport step P.:Background job RDDMNTAB ended successfully.

then i am attaching the P and DS files to ur reference

P080122.SEQ

3 ETP399 "ADDON_REL",

3 ETP399 "IGN_CONFLI",

3 ETP399 "AP_ANCEST",

3 ETP399 "EPSFILSIZ",

3 ETP399 "HI_ANCEST",

3 ETP399 "COMP_REL",

3 ETP399 "COMPONENT",

3 ETP399 "DELIV_DATE",

3 ETP399 "DELIV_TIME")

3 ETP399 AS SELECT

3 ETP399 T1."EPSPCLORI",

3 ETP399 T1."EPSPCLNUM",

3 ETP399 T1."EPSPCLEXT",

3 ETP399 T1."EPSSUBJECT",

3 ETP399 T1."EPSCOMMENT",

3 ETP399 T1."EPSFILSIZ",

3 ETP399 T1."EPSRELFLG",

3 ETP399 T2."PATCH",

3 ETP399 T2."FROM_REL",

3 ETP399 T2."TO_REL",

3 ETP399 T2."OS",

3 ETP399 T2."DB",

3 ETP399 T2."PATCH_TYPE",

3 ETP399 T2."ANCESTOR",

3 ETP399 T2."STRICT_SEQ",

3 ETP399 T2."NO_GEN",

3 ETP399 T2."SPAMFIX",

3 ETP399 T2."ADDON_ID",

3 ETP399 T2."ADDON_REL",

3 ETP399 T2."IGN_CONFLI",

3 ETP399 T2."AP_ANCEST",

3 ETP399 T2."EPSFILSIZ",

3 ETP399 T2."HI_ANCEST",

3 ETP399 T2."COMP_REL",

3 ETP399 T2."COMPONENT",

3 ETP399 T2."DELIV_DATE",

3 ETP399 T2."DELIV_TIME"

3 ETP399 FROM

3 ETP399 "TEPSOUT" T1,

3 ETP399 "PAD03" T2

3 ETP399 WHERE

3 ETP399 T1."EPSPCLORI" = T2."ORIGIN" AND

3 ETP399 T1."EPSPCLNUM" = T2."PARCEL_NUM"

3 ETP399

2WETP000 00:55:15: Retcode 1: error in DDL statement for "V_PAD_PATS

" - repeat

2EETP345 00:55:27: Retcode 1: SQL-error "1031-ORA-01031: insufficient privileges

" in DDL statement

2EETP345 for "V_PAD_PATS "

2 ETP399 -

---

DB-ROLLBACK() -

---

2EETP334 00:55:27: error in DDL, nametab for "V_PAD_PATS" not activated

2 ETP301 -

---

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

2 ETP362 "1" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2008/01/22 00:55:15")

2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2008/01/22 00:55:27")

2 ETP301 -

---

1 ETP172 MOVE OF NAMETABS

1 ETP110 end date and time : "20080122005527"

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

1 ETP173 DISTRIBUTION OF DD-OBJECTS

1 ETP101 transport order : "ALL"

1 ETP102 system : "SEQ"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "340.16.37" "640"

1 ETP198

4 EDA506 -> "AVERS_EXT" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "CLNT_CVERS" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "CVERS_SUB" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "OCSCMPLOBJ" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "OCSPATNTCI" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "OCSSORTT" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PAD03" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT00" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT01" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT02" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT03" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT05" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT06" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT07" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT07_ACP" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "PAT08" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT08_ACP" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "PAT09" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT10" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT10B" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT11" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PAT13" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PATACP" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PATCHECK" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATCONFL" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATCONT" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATCONFL" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATCONT" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATEXCPT" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATHISTORY" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "PATHISTQ" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATLOG" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" - -

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

4 EDA506 -> "PATLOG3" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATPRDVRS" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "PATSTOP" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "PATSWFEATR" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "PRDVERS" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008" -

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

4 EDA506 -> "STACKCOMPS" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "STACKHEADR" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "SWFEATURE" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

4 EDA506 -> "TFDIR_INIM" Activation - - - "milbiwd1_5" "00:49:58" "22.01.2008"

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

2 ED0302X=======================================================================

==

2 ED0327 Process..................: "milbiwd1_5"

2 ED0319 Return code..............: "0"

2 ED0309 Program runtime..........: "< 1 sec."

2 ED0305 Date, time...............: "22.01.2008", "00:49:58"

2 ED0318 Program end============================================================

==

4 EDA409 - - - - - - - - - - - "milbiwd1_5" "22.01.2008" "00:49:58" - - - -

4 EDA484 --- S u m m a r y o f t h e L o g ---

4 EDA444 "116" o b j e c t s - t o t a l

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA442 "116" objects without input request (MODEFLAG = SPACE)

4 EDA443 "0" objects with MODIFY request (= delete - create)

4 EDA447 "0" objects with delete request (mass deletion program)

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA456 Activate "116"

4 EDA458 "0" tables for conversion

4 EDA441 "0" objects with mode flag 'F' or 'U': database modification using SQL

4 EDA440 "0" objects with mode flag 'X' or 'W': Delete nametab

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA453 "77" tables of type INTAB

4 EDA481 "0" Views

4 EDA454 "0" technical settings for tables

4 EDA455 "39" tables of type TRANSP

4 EDA446 "0" tables of type pool

4 EDA455 "39" tables of type TRANSP

4 EDA446 "0" tables of type pool

4 EDA445 "0" tables of type cluster

4 EDA494 "0" SQL tables

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA485 "0" action: CRE

4 EDA486 "0" action: ALT

4 EDA487 "0" action: CNV

4 EDA488 "0" action: DCI

4 EDA490 "0" action: MDF

4 EDA491 "0" action: DEL

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA492 Warnings: "0"

4 EDA483 Errors: "0"

4 EDA495 Total runtime: " "

1 ETP173 DISTRIBUTION OF DD-OBJECTS

1 ETP110 end date and time : "20080122004958"

1 ETP111 exit code : "0"

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

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

1 ETP173 DISTRIBUTION OF DD-OBJECTS

1 ETP101 transport order : "ALL"

1 ETP102 system : "SEQ"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "340.16.37" "640"

1 ETP198

4 EDA506 -> "AVERS_EXT" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "CLNT_CVERS" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "CVERS_SUB" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "OCSCMPLOBJ" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "OCSPATNTCI" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "OCSSORTT" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" -

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

4 EDA506 -> "PAD03" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT00" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT01" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT02" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT03" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT05" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT06" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT07" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT07_ACP" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

@

4 EDA506 -> "PAT07" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT07_ACP" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "PAT08" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT08_ACP" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "PAT09" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT10" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT10B" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT11" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PAT13" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PATACP" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PATCHECK" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" -

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

4 EDA506 -> "PATCONFL" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" -

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

4 EDA506 -> "PATCONT" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" -

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

4 EDA506 -> "PATEXCPT" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" -

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

4 EDA506 -> "PATHISTORY" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008"

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

4 EDA506 -> "PATHISTQ" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" -

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

4 EDA506 -> "PATLOG" Activation - - - "milbiwd1_5" "00:55:08" "22.01.2008" - -

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

4 EDA506 -> "PATLOG3" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008" -

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

4 EDA506 -> "PATPRDVRS" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008"

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

4 EDA506 -> "PATSTOP" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008" -

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

4 EDA506 -> "PATSWFEATR" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008"

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

4 EDA506 -> "PRDVERS" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008" -

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

4 EDA506 -> "STACKCOMPS" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008"

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

4 EDA506 -> "STACKHEADR" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008"

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

4 EDA506 -> "SWFEATURE" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008"

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

4 EDA506 -> "TFDIR_INIM" Activation - - - "milbiwd1_5" "00:55:09" "22.01.2008"

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

2 ED0302X=======================================================================

==

2 ED0327 Process..................: "milbiwd1_5"

2 ED0319 Return code..............: "0"

2 ED0309 Program runtime..........: "00:00:01"

2 ED0305 Date, time...............: "22.01.2008", "00:55:09"

2 ED0309 Program runtime..........: "00:00:01"

2 ED0305 Date, time...............: "22.01.2008", "00:55:09"

2 ED0318 Program end============================================================

==

4 EDA409 - - - - - - - - - - - "milbiwd1_5" "22.01.2008" "00:55:09" - - - -

4 EDA484 --- S u m m a r y o f t h e L o g ---

4 EDA444 "116" o b j e c t s - t o t a l

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA442 "116" objects without input request (MODEFLAG = SPACE)

4 EDA443 "0" objects with MODIFY request (= delete - create)

4 EDA447 "0" objects with delete request (mass deletion program)

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA456 Activate "116"

4 EDA458 "0" tables for conversion

4 EDA441 "0" objects with mode flag 'F' or 'U': database modification using SQL

4 EDA440 "0" objects with mode flag 'X' or 'W': Delete nametab

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA453 "77" tables of type INTAB

4 EDA481 "0" Views

4 EDA454 "0" technical settings for tables

4 EDA455 "39" tables of type TRANSP

4 EDA446 "0" tables of type pool

4 EDA445 "0" tables of type cluster

4 EDA494 "0" SQL tables

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA485 "0" action: CRE

4 EDA486 "0" action: ALT

4 EDA487 "0" action: CNV

4 EDA488 "0" action: DCI

4 EDA490 "0" action: MDF

4 EDA491 "0" action: DEL

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-

4 EDA492 Warnings: "0"

4 EDA483 Errors: "0"

4 EDA495 Total runtime: " "

1 ETP173 DISTRIBUTION OF DD-OBJECTS

1 ETP110 end date and time : "20080122005509"

1 ETP111 exit code : "0"

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

please help

regards

bala

[Former Member]

Hi

we have solved the problem by retrying the spam / saint three to four times

it successfully implemeted.

anyone could clarify how it has happened

regards

bala

[Former Member]

Hello Bala,

Can you paste the import log for the support package itself. It will given better explanation.

Regards.

Ruchit

[Former Member]

hi

the transport route is already set and there is no problem in configuration

since we have done many patch upgrade

regards

bala

[Former Member]

Hi,

The transport root is not defined probably.

Set the transport root.

Regards,

Vamsi.