cancel
Showing results for 
Search instead for 
Did you mean: 

Error at PHASE LOADCRE_TMP in 4.71 upgrade

Former Member
0 Kudos

hi,

i am getting the below error in R/3 Upgrade:

UPGRADE/SWITCH: START OF PHASE LOADCRE_TMP

working ...

Creating empty ABAP load tables

ERROR: 1 error messages found in LOADCRT.ELG.

Analyze the log (refer to the upgrade

guide and the notes) and remove the problem(s)

that caused the error(s). After that,

repeat this phase until it is error free.

LOADCRT.ELG:

>>LOADCRE ERROR:, log file "EX000020.DPR": only 0 times "R3load.exe: job completed" found.

Analyze the log file EX000020.DPR for error messages or program abort.

Edited by: giridhar on Mar 23, 2008 6:44 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

What message in EX000020.DPR ?

Former Member
0 Kudos

hi

below is the error:

C:\usr\sap\put\exe\R3load.exe: START OF LOG: 20090323182824

C:\usr\sap\put\exe\R3load.exe: sccsid @(#) $Id: //bas/640_LO_REL/src/R3ld/R3load/R3ldmain.c#1 $ SAP

C:\usr\sap\put\exe\R3load.exe: version R6.40/V1.4

C:\usr\sap\put\exe\R3load.exe -i C:\usr\sap\put\exchange\compack\EX000020.COD -p C:\usr\sap\put\log\EX000020.DPR -s C:\usr\sap\put\log\EX000020.DST -o d -datacodepage 1100 -dbcodepage auto

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) INFO: CO2MAP dropped

(DB) INFO: CO2MAP created

(DB) ERROR: DDL statement failed

(DROP INDEX "CO2MAP~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: CO2MAP~0 created

(DB) ERROR: DDL statement failed

(DROP INDEX "CO2MAP~IDX")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: CO2MAP~IDX created

(DB) INFO: CO2MAPINF dropped

(DB) INFO: CO2MAPINF created

(DB) ERROR: DDL statement failed

(DROP INDEX "CO2MAPINF~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: CO2MAPINF~0 created

(DB) INFO: DDFTX dropped

(DB) INFO: DDFTX created

(DB) ERROR: DDL statement failed

(DROP INDEX "DDFTX~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: DDFTX~0 created

(DB) ERROR: DDL statement failed

(DROP INDEX "DDFTX~1")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: DDFTX~1 created

(DB) INFO: DYNPLOAD dropped

(DB) INFO: DYNPLOAD created

(DB) ERROR: DDL statement failed

(DROP INDEX "DYNPLOAD~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: DYNPLOAD~0 created

(DB) INFO: DYNPTXTLD dropped

(DB) INFO: DYNPTXTLD created

(DB) ERROR: DDL statement failed

(DROP INDEX "DYNPTXTLD~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: DYNPTXTLD~0 created

(DB) INFO: O2PAGINC dropped

(DB) INFO: O2PAGINC created

(DB) ERROR: DDL statement failed

(DROP INDEX "O2PAGINC~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: O2PAGINC~0 created

(DB) INFO: O2PAGRT dropped

(DB) INFO: O2PAGRT created

(DB) ERROR: DDL statement failed

(DROP INDEX "O2PAGRT~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: O2PAGRT~0 created

(DB) INFO: REPOLOAD dropped

(DB) INFO: REPOLOAD created

(DB) ERROR: DDL statement failed

(DROP INDEX "REPOLOAD~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: REPOLOAD~0 created

(DB) INFO: D010LINF dropped

DbSl Trace: ORA-1031 occured when executing SQL statement (parse error offset = 12)

(DB) ERROR: DDL statement failed

(CREATE VIEW "D010LINF" ( "PROG" , "R3STATE" , "MACH" , "UNAM" , "UDAT" , "UTIME" , "L_DATALG" , "Q_DATALG" , "SDAT" , "STIME" , "MINOR_VERS" , "MAJOR_VERS" ) AS SELECT T0001."PROGNAME", T0001."R3STATE", T0001."MACH", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."L_DATALG", T0001."Q_DATALG", T0001."SDAT", T0001."STIME", T0001."MINOR_VERS", T0001."MAJOR_VERS" FROM "REPOLOAD" T0001)

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: TCVIEW_P dropped

DbSl Trace: ORA-1031 occured when executing SQL statement (parse error offset = 12)

(DB) ERROR: DDL statement failed

(CREATE VIEW "TCVIEW_P" ( "MANDANT" , "TCPROGRAM" , "TCCONTROL" , "DNUM" ) AS SELECT T0001."MANDANT", T0001."TCPROGRAM", T0001."TCCONTROL", T0002."DYNPNUMBER" FROM "TCVIEW" T0001, "DYNPLOAD" T0002 WHERE T0001."TCPROGRAM" = T0002."PROGNAME")

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: disconnected from DB

C:\usr\sap\put\exe\R3load.exe: job finished with 2 error(s)

C:\usr\sap\put\exe\R3load.exe: END OF LOG: 20090323182833

C:\usr\sap\put\exe\R3load.exe: START OF LOG: 20090323183205

C:\usr\sap\put\exe\R3load.exe: sccsid @(#) $Id: //bas/640_LO_REL/src/R3ld/R3load/R3ldmain.c#1 $ SAP

C:\usr\sap\put\exe\R3load.exe: version R6.40/V1.4

C:\usr\sap\put\exe\R3load.exe -i C:\usr\sap\put\exchange\compack\EX000020.COD -p C:\usr\sap\put\log\EX000020.DPR -s C:\usr\sap\put\log\EX000020.DST -o d -datacodepage 1100 -dbcodepage auto

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) ERROR: DDL statement failed

(DROP VIEW "D010LINF")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: ORA-1031 occured when executing SQL statement (parse error offset = 12)

(DB) ERROR: DDL statement failed

(CREATE VIEW "D010LINF" ( "PROG" , "R3STATE" , "MACH" , "UNAM" , "UDAT" , "UTIME" , "L_DATALG" , "Q_DATALG" , "SDAT" , "STIME" , "MINOR_VERS" , "MAJOR_VERS" ) AS SELECT T0001."PROGNAME", T0001."R3STATE", T0001."MACH", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."L_DATALG", T0001."Q_DATALG", T0001."SDAT", T0001."STIME", T0001."MINOR_VERS", T0001."MAJOR_VERS" FROM "REPOLOAD" T0001)

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) ERROR: DDL statement failed

(DROP VIEW "TCVIEW_P")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: ORA-1031 occured when executing SQL statement (parse error offset = 12)

(DB) ERROR: DDL statement failed

(CREATE VIEW "TCVIEW_P" ( "MANDANT" , "TCPROGRAM" , "TCCONTROL" , "DNUM" ) AS SELECT T0001."MANDANT", T0001."TCPROGRAM", T0001."TCCONTROL", T0002."DYNPNUMBER" FROM "TCVIEW" T0001, "DYNPLOAD" T0002 WHERE T0001."TCPROGRAM" = T0002."PROGNAME")

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: disconnected from DB

C:\usr\sap\put\exe\R3load.exe: job finished with 2 error(s)

C:\usr\sap\put\exe\R3load.exe: END OF LOG: 20090323183205

C:\usr\sap\put\exe\R3load.exe: START OF LOG: 20090323184248

C:\usr\sap\put\exe\R3load.exe: sccsid @(#) $Id: //bas/640_LO_REL/src/R3ld/R3load/R3ldmain.c#1 $ SAP

C:\usr\sap\put\exe\R3load.exe: version R6.40/V1.4

C:\usr\sap\put\exe\R3load.exe -i C:\usr\sap\put\exchange\compack\EX000020.COD -p C:\usr\sap\put\log\EX000020.DPR -s C:\usr\sap\put\log\EX000020.DST -o d -datacodepage 1100 -dbcodepage auto

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) ERROR: DDL statement failed

(DROP VIEW "D010LINF")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: ORA-1031 occured when executing SQL statement (parse error offset = 12)

(DB) ERROR: DDL statement failed

(CREATE VIEW "D010LINF" ( "PROG" , "R3STATE" , "MACH" , "UNAM" , "UDAT" , "UTIME" , "L_DATALG" , "Q_DATALG" , "SDAT" , "STIME" , "MINOR_VERS" , "MAJOR_VERS" ) AS SELECT T0001."PROGNAME", T0001."R3STATE", T0001."MACH", T0001."UNAM", T0001."UDAT", T0001."UTIME", T0001."L_DATALG", T0001."Q_DATALG", T0001."SDAT", T0001."STIME", T0001."MINOR_VERS", T0001."MAJOR_VERS" FROM "REPOLOAD" T0001)

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) ERROR: DDL statement failed

(DROP VIEW "TCVIEW_P")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: ORA-1031 occured when executing SQL statement (parse error offset = 12)

(DB) ERROR: DDL statement failed

(CREATE VIEW "TCVIEW_P" ( "MANDANT" , "TCPROGRAM" , "TCCONTROL" , "DNUM" ) AS SELECT T0001."MANDANT", T0001."TCPROGRAM", T0001."TCCONTROL", T0002."DYNPNUMBER" FROM "TCVIEW" T0001, "DYNPLOAD" T0002 WHERE T0001."TCPROGRAM" = T0002."PROGNAME")

DbSlExecute: rc = 99

(SQL error 1031)

error message returned by DbSl:

ORA-01031: insufficient privileges

(DB) INFO: disconnected from DB

C:\usr\sap\put\exe\R3load.exe: job finished with 2 error(s)

C:\usr\sap\put\exe\R3load.exe: END OF LOG: 20090323184248

Former Member
0 Kudos

hi,

Please run sapconn_role.sql and sapdba_role.sql.

How to execute must be given in the sql file itself. Open it and check how to run those files..

Regards,

Suhas

Former Member
0 Kudos

Thank you very much

Answers (0)