Error at PHASE LOADCRE_TMP in 4.71 upgrade

[Former Member]

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.

[Former Member · Accepted solution]

And provide please the EX000020.DPR log )

Regards.

[Former Member · Accepted solution]

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 · Accepted solution]

The oracle version is ? I'm think is 10g. You need to go -->\usr\sap\SID\DVEBMGS00\exe , find

sapconn_role.sql and sapdba_role.sql. Read this files and implement him. Also read the note 834917.

Regards. Award if helpful.

Edited by: Sergo Beradze on Mar 24, 2008 10:42 AM

[Former Member · Accepted solution]

hi,

i doesn't find any files in \usr\sap\sid\dvebmgs00\exe. it is empty.

[Former Member · Accepted solution]

The sid is your SAP Name like PRD. You can download sapconn_role.sql script from Attachments on Note 834917. Also read Note 134592 about sapdba_role.sql.

Read and implement this script. Regards.

Edited by: Sergo Beradze on Mar 24, 2008 11:25 AM

[Former Member · Accepted solution]

Thank u very much. Error was solved.