Hello,
we have a 4.6C system (windows/oracle) and we made an Oracle upgrade to 10.2 from 9i. Now we want to make a upgrade to ECC6.0 and we need ST-PI to be in the system. We started the import of ST-PI add-on 2005_1_46C and we get a error:
- 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
Here it is the log P070822.<SID>:
1 ETP199X######################################
1 ETP172 MOVE OF NAMETABS
1 ETP101 transport order : "ALL"
1 ETP102 system : "DDD"
1 ETP108 tp path : "tp"
1 ETP109 version and release : "305.12.77" "46D"
1 ETP198
2 ETP301 -
2 ETP364 Begin: Act. of Shadow-Nametabs ("20080722155720")
2 ETP301 -
3 ETP399 OPTIONS:
3 ETP399
3 ETP399 PRINT ONLY = no
3 ETP399 iNT-TIMESTAMP RESET = no
3 ETP399 DELETE iNT = yes
3 ETP399 DELETE iNT FIELDS = yes
3 ETP399 ACTIVATE iNT = yes
3 ETP399 TOLERATE UNCRITICAL STMTs = no
3 ETP399 COMPARE TIMESTAMPs IN MV40-Op. = yes
3 ETP399 SUPPRESS COMMITs = no
3 ETP399 CALL EXTERNAL NT_SYNC = no
3 ETP399 protocol output to file = yes,
dezvoltnew\sapmnt\trans\tmp\P080722.DDD
3 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 ETP366 End: Act. of Shadow-Nametabs ("20080722155720")
2 ETP301 -
2 ETP301 -
2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("20080722155720")
2 ETP301 -
3 ETP399 OPTIONS:
3 ETP399
3 ETP399 PRINT ONLY = no
3 ETP399 iNT-TIMESTAMP RESET = no
3 ETP399 DELETE iNT = yes
3 ETP399 DELETE iNT FIELDS = yes
3 ETP399 ACTIVATE iNT = yes
3 ETP399 TOLERATE UNCRITICAL STMTs = no
3 ETP399 COMPARE TIMESTAMPs IN MV40-Op. = yes
3 ETP399 SUPPRESS COMMITs = no
3 ETP399 CALL EXTERNAL NT_SYNC = no
3 ETP399 protocol output to file = yes,
dezvoltnew\sapmnt\trans\tmp\P080722.DDD
3 ETP301 -
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 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("20080722155720")
2 ETP301 -
2 ETP301 -
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("20080722155720")
2 ETP301 -
3 ETP399 OPTIONS:
3 ETP399
3 ETP399 PRINT ONLY = no
3 ETP399 iNT-TIMESTAMP RESET = no
3 ETP399 DELETE iNT = yes
3 ETP399 DELETE iNT FIELDS = yes
3 ETP399 ACTIVATE iNT = yes
3 ETP399 TOLERATE UNCRITICAL STMTs = no
3 ETP399 COMPARE TIMESTAMPs IN MV40-Op. = yes
3 ETP399 SUPPRESS COMMITs = no
3 ETP399 CALL EXTERNAL NT_SYNC = no
3 ETP399 protocol output to file = yes,
dezvoltnew\sapmnt\trans\tmp\P080722.DDD
3 ETP301 -
2 ETP301 -
2 ETP330XActivation of Shadownametabs with DDL
2 ETP301 -
3 ETP379X15:57:20: activating Nametab "/SDF/SMODICOMP ":
3 ETP355Xstatements:
3 ETP399 DROP VIEW "/SDF/SMODICOMP"
3 ETP399
2WETP354 15:57:20: Warning: Retcode 512: SQL-error "942" in DDL statement for "/SDF/SMODICOMP
2WETP354 " - IGNORED
3 ETP399 CREATE VIEW "/SDF/SMODICOMP"
3 ETP399 ("OBJ_TYPE",
3 ETP399 "SUB_TYPE",
3 ETP399 "INT_TYPE",
3 ETP399 "OPERATION",
3 ETP399 "INACTIVE",
3 ETP399 "COMPONENT",
3 ETP399 "SUB_NAME",
3 ETP399 "INT_NAME",
3 ETP399 "PGMID",
3 ETP399 "OBJECT",
3 ETP399 "OBJ_NAME",
3 ETP399 "DEVCLASS")
3 ETP399 AS SELECT
3 ETP399 T1."OBJ_TYPE",
3 ETP399 T1."SUB_TYPE",
3 ETP399 T1."INT_TYPE",
3 ETP399 T1."OPERATION",
3 ETP399 T1."INACTIVE",
3 ETP399 T3."COMPONENT",
3 ETP399 T1."SUB_NAME",
3 ETP399 T1."INT_NAME",
3 ETP399 T2."PGMID",
3 ETP399 T2."OBJECT",
3 ETP399 T2."OBJ_NAME",
3 ETP399 T3."DEVCLASS"
3 ETP399 FROM
3 ETP399 "SMODILOG" T1,
3 ETP399 "TADIR" T2,
3 ETP399 "TDEVC" T3
3 ETP399 WHERE
3 ETP399 T1."OBJ_TYPE" = T2."OBJECT" AND
3 ETP399 T1."OBJ_NAME" = T2."OBJ_NAME" AND
3 ETP399 T2."DEVCLASS" = T3."DEVCLASS"
3 ETP399 AND
3 ETP399 T2."PGMID"
3 ETP399 = 'R3TR'
3 ETP399
2WETP000 15:57:20: Retcode 1: error in DDL statement for "/SDF/SMODICOMP " - repeat
2EETP345 15:57:32: Retcode 1: SQL-error "1031-ORA-01031: insufficient privileges
2EETP345 " in DDL statement for "/SDF/SMODICOMP "
2 ETP399 -
DB-ROLLBACK() -
2EETP334 15:57:32: error in DDL, nametab for "/SDF/SMODICOMP" not activated
3 ETP379X15:57:32: activating Nametab "/SDF/SMODIDEVC ":
3 ETP355Xstatements:
3 ETP399 DROP VIEW "/SDF/SMODIDEVC"
3 ETP399
2WETP354 15:57:32: Warning: Retcode 512: SQL-error "942" in DDL statement for "/SDF/SMODIDEVC
2WETP354 " - IGNORED
3 ETP399 CREATE VIEW "/SDF/SMODIDEVC"
3 ETP399 ("OBJ_TYPE",
3 ETP399 "OBJ_NAME",
3 ETP399 "SUB_TYPE",
3 ETP399 "SUB_NAME",
3 ETP399 "INT_TYPE",
3 ETP399 "INT_NAME",
3 ETP399 "OPERATION",
3 ETP399 "MAIN_PROG",
3 ETP399 "INCLUDE",
3 ETP399 "MOD_NAME",
3 ETP399 "MOD_LANGU",
3 ETP399 "MOD_USER",
3 ETP399 "MOD_DATE",
3 ETP399 "MOD_TIME",
3 ETP399 "ACTIVE",
3 ETP399 "INACTIVE",
3 ETP399 "UPGRADE",
3 ETP399 "DEVCLASS",
3 ETP399 "PGMID",
3 ETP399 "COMPONENT")
3 ETP399 AS SELECT
3 ETP399 T1."OBJ_TYPE",
3 ETP399 T1."OBJ_NAME",
3 ETP399 T1."SUB_TYPE",
3 ETP399 T1."SUB_NAME",
3 ETP399 T1."INT_TYPE",
3 ETP399 T1."INT_NAME",
3 ETP399 T1."OPERATION",
3 ETP399 T1."MAIN_PROG",
3 ETP399 T1."INCLUDE",
3 ETP399 T1."MOD_NAME",
3 ETP399 T1."MOD_LANGU",
3 ETP399 T1."MOD_USER",
3 ETP399 T1."MOD_DATE",
3 ETP399 T1."MOD_TIME",
3 ETP399 T1."ACTIVE",
3 ETP399 T1."INACTIVE",
3 ETP399 T1."UPGRADE",
3 ETP399 T2."DEVCLASS",
3 ETP399 T2."PGMID",
3 ETP399 T3."COMPONENT"
3 ETP399 FROM
3 ETP399 "SMODILOG" T1,
3 ETP399 "TADIR" T2,
3 ETP399 "TDEVC" T3
3 ETP399 WHERE
3 ETP399 T1."OBJ_TYPE" = T2."OBJECT" AND
3 ETP399 T1."OBJ_NAME" = T2."OBJ_NAME" AND
3 ETP399 T2."DEVCLASS" = T3."DEVCLASS"
3 ETP399 AND
3 ETP399 T2."PGMID"
3 ETP399 = 'R3TR'
3 ETP399
2WETP000 15:57:32: Retcode 1: error in DDL statement for "/SDF/SMODIDEVC " - repeat
2EETP345 15:57:44: Retcode 1: SQL-error "1031-ORA-01031: insufficient privileges
2EETP345 " in DDL statement for "/SDF/SMODIDEVC "
2 ETP399 -
DB-ROLLBACK() -
2EETP334 15:57:44: error in DDL, nametab for "/SDF/SMODIDEVC" not activated
3 ETP379X15:57:44: activating Nametab "/SDF/UMOD_COMP ":
3 ETP355Xstatements:
3 ETP399 DROP VIEW "/SDF/UMOD_COMP"
3 ETP399
2WETP354 15:57:44: Warning: Retcode 512: SQL-error "942" in DDL statement for "/SDF/UMOD_COMP
2WETP354 " - IGNORED
3 ETP399 CREATE VIEW "/SDF/UMOD_COMP"
3 ETP399 ("SAPRL",
3 ETP399 "PGMID",
3 ETP399 "OBJECT",
3 ETP399 "OBJ_NAME",
3 ETP399 "UPGRMODE",
3 ETP399 "MODART",
3 ETP399 "DEVCLASS",
3 ETP399 "LASTTRKORR",
3 ETP399 "AS4USER",
3 ETP399 "AS4DATE",
3 ETP399 "AS4TIME",
3 ETP399 "STATUS",
3 ETP399 "PATCHTRID",
3 ETP399 "SAPKORR",
3 ETP399 "COMPONENT")
3 ETP399 AS SELECT
3 ETP399 T1."SAPRL",
3 ETP399 T1."PGMID",
3 ETP399 T1."OBJECT",
3 ETP399 T1."OBJ_NAME",
3 ETP399 T1."UPGRMODE",
3 ETP399 T1."MODART",
3 ETP399 T1."DEVCLASS",
3 ETP399 T1."LASTTRKORR",
3 ETP399 T1."AS4USER",
3 ETP399 T1."AS4DATE",
3 ETP399 T1."AS4TIME",
3 ETP399 T1."STATUS",
3 ETP399 T1."PATCHTRID",
3 ETP399 T1."SAPKORR",
3 ETP399 T2."COMPONENT"
3 ETP399 FROM
3 ETP399 "UMODOBJ" T1,
3 ETP399 "TDEVC" T2
3 ETP399 WHERE
3 ETP399 T1."DEVCLASS" = T2."DEVCLASS"
3 ETP399
2WETP000 15:57:44: Retcode 1: error in DDL statement for "/SDF/UMOD_COMP " - repeat
2EETP345 15:57:56: Retcode 1: SQL-error "1031-ORA-01031: insufficient privileges
2EETP345 " in DDL statement for "/SDF/UMOD_COMP "
2 ETP399 -
DB-ROLLBACK() -
2EETP334 15:57:56: error in DDL, nametab for "/SDF/UMOD_COMP" not activated
3 ETP379X15:57:56: activating Nametab "/SQLR/CUST ":
3 ETP355Xstatements:
3 ETP399 DROP VIEW "/SQLR/CUST"
3 ETP399
2WETP354 15:57:56: Warning: Retcode 512: SQL-error "942" in DDL statement for "/SQLR/CUST
2WETP354 " - IGNORED
3 ETP399 CREATE VIEW "/SQLR/CUST"
3 ETP399 ("SQLRPROG",
3 ETP399 "SQLRTAB",
3 ETP399 "SQLRFUNCID",
3 ETP399 "SQLRGROUP",
3 ETP399 "SQLLANGU",
3 ETP399 "SQLRRELUL",
3 ETP399 "SQLRRELOL",
3 ETP399 "SQLRPRIO",
3 ETP399 "SQLRBEFORE",
3 ETP399 "SQLRAFTER",
3 ETP399 "SQLRGROUPD",
3 ETP399 "SQLRFUNCDS")
3 ETP399 AS SELECT
3 ETP399 T1."SQLRPROG",
3 ETP399 T1."SQLRTAB",
3 ETP399 T1."SQLRFUNCID",
3 ETP399 T1."SQLRGROUP",
3 ETP399 T2."SQLLANGU",
3 ETP399 T1."SQLRRELUL",
3 ETP399 T1."SQLRRELOL",
3 ETP399 T1."SQLRPRIO",
3 ETP399 T1."SQLRBEFORE",
3 ETP399 T1."SQLRAFTER",
3 ETP399 T2."SQLRGROUPD",
3 ETP399 T3."SQLRFUNCDS"
3 ETP399 FROM
3 ETP399 "/SQLR/TAB" T1,
3 ETP399 "/SQLR/TEXT1" T2,
3 ETP399 "/SQLR/TEXT2" T3
3 ETP399 WHERE
3 ETP399 T1."SQLRFUNCID" = T2."SQLRFUNCID" AND
3 ETP399 T1."SQLRFUNCID" = T3."SQLRFUNCID" AND
3 ETP399 T1."SQLRGROUP" = T2."SQLRGROUP" AND
3 ETP399 T2."SQLLANGU" = T3."SQLLANGU"
3 ETP399
2WETP000 15:57:56: Retcode 1: error in DDL statement for "/SQLR/CUST " - repeat
2EETP345 15:58:08: Retcode 1: SQL-error "1031-ORA-01031: insufficient privileges
2EETP345 " in DDL statement for "/SQLR/CUST "
2 ETP399 -
DB-ROLLBACK() -
2EETP334 15:58:08: error in DDL, nametab for "/SQLR/CUST" not activated
3 ETP379X15:58:08: activating Nametab "/SQLR/_SQLRTEXT1 ":
3 ETP355Xstatements:
3 ETP399 DROP VIEW "/SQLR/_SQLRTEXT1"
3 ETP399
2WETP354 15:58:08: Warning: Retcode 512: SQL-error "942" in DDL statement for "/SQLR/_SQLRTEXT1
2WETP354 " - IGNORED
3 ETP399 CREATE VIEW "/SQLR/_SQLRTEXT1"
3 ETP399 ("SQLRFUNCID",
3 ETP399 "SQLRGROUP",
3 ETP399 "SQLLANGU",
3 ETP399 "SQLRGROUPD")
3 ETP399 AS SELECT
3 ETP399 T1."SQLRFUNCID",
3 ETP399 T1."SQLRGROUP",
3 ETP399 T1."SQLLANGU",
3 ETP399 T1."SQLRGROUPD"
3 ETP399 FROM
3 ETP399 "/SQLR/TEXT1" T1
3 ETP399
2WETP000 15:58:08: Retcode 1: error in DDL statement for "/SQLR/_SQLRTEXT1 " - repeat
2EETP345 15:58:20: Retcode 1: SQL-error "1031-ORA-01031: insufficient privileges
2EETP345 " in DDL statement for "/SQLR/_SQLRTEXT1 "
2 ETP399 -
DB-ROLLBACK() -
2EETP334 15:58:20: error in DDL, nametab for "/SQLR/_SQLRTEXT1" not activated
3 ETP379X15:58:20: activating Nametab "/SQLR/_SQLRTEXT2 ":
3 ETP355Xstatements:
3 ETP399 DROP VIEW "/SQLR/_SQLRTEXT2"
3 ETP399
2WETP354 15:58:20: Warning: Retcode 512: SQL-error "942" in DDL statement for "/SQLR/_SQLRTEXT2
2WETP354 " - IGNORED
3 ETP399 CREATE VIEW "/SQLR/_SQLRTEXT2"
3 ETP399 ("SQLRFUNCID",
3 ETP399 "SQLLANGU",
3 ETP399 "SQLRFUNCDS")
3 ETP399 AS SELECT
3 ETP399 T1."SQLRFUNCID",
3 ETP399 T1."SQLLANGU",
3 ETP399 T1."SQLRFUNCDS"
3 ETP399 FROM
3 ETP399 "/SQLR/TEXT2" T1
3 ETP399
2WETP000 15:58:20: Retcode 1: error in DDL statement for "/SQLR/_SQLRTEXT2 " - repeat
2EETP345 15:58:32: Retcode 1: SQL-error "1031-ORA-01031: insufficient privileges
2EETP345 " in DDL statement for "/SQLR/_SQLRTEXT2 "
2 ETP399 -
DB-ROLLBACK() -
2EETP334 15:58:32: error in DDL, nametab for "/SQLR/_SQLRTEXT2" not activated
2 ETP301 -
3 ETP361 "0" Shadow-Nametabs activated, DDL executed
2 ETP362 "6" Shadow-Nametab activations failed
2 ETP363 End: Act. of Shadow-Nametabs with DDL ("20080722155832")
2 ETP301 -
1 ETP172 MOVE OF NAMETABS
1 ETP110 end date and time : "20080722155832"
1 ETP111 exit code : "8"
1 ETP199 ######################################
Can you give as an ideea about this?
Thank you