Error during R/3 IDES installation -

[Former Member]

Dear All

I am trying to install SAP R/3 4.7E IDES on Windows 2003 Enterprise with Oracle 10.2.0.4 version.

During the database load phase, i am encountering a problem during creation of D010LINF view which is using T0001 table and mentions that the table doesnot exist. I am copying the relevant log here. Also i see a error mentioning that could not access SAPUSER table. Please help

Log file - SAPVIEW.log

F:\usr\sap\R47\SYS\exe\run/R3load.exe: START OF LOG: 20100302102935

F:\usr\sap\R47\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

F:\usr\sap\R47\SYS\exe\run/R3load.exe: version R6.40/V1.4

Compiled Nov 30 2005 20:41:21

F:\usr\sap\R47\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPVIEW.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPVIEW.log -stop_on_error

(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

(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 = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

F:\usr\sap\R47\SYS\exe\run/R3load.exe: job finished with 1 error(s)

F:\usr\sap\R47\SYS\exe\run/R3load.exe: END OF LOG: 20100302102937

The line showing the SAPUSER error

DbSl Trace: ORA-1403 when accessing table SAPUSER

Lokesh

[Former Member]

Hi Markus

I have used the latest sapinst available for the said version, downloaded from SAP Marketplace. The label.asc states

SAP:ROOT-LABEL-PatchColl-NW04:640-2:IM-CD:*:AIX_PPC64 LINUX_I386 HPUX_IA64 OS390_32 OS400_PPC64 LINUX_S390X_64 LINUX_IA64 LINUX_PPC64 HPUX_PARISC SOLARIS_SPARC SOLARIS_X86_64 WINDOWS_I386 LINUX_X86_64 WINDOWS_X86_64 DEC WINDOWS_IA64:D51033746

Please advice.

Lokesh

[markus_doehr2]

Hi Lokesh,

not talking about sapinst but about the kernel. The R3load program is very old, in 2005 Oracle 10 was not available.

Markus

[Former Member]

Dear Markus

Thanks for the help. I downloaded the kernel available on the SAP Marketplace for R34.7 IDES which was Kernel 640 Ex2. I upgraded the kernel and restarted the installation (have not yet scratched off the system), however, it is still getting struck at the same error. Also, the R3load version is showing the same as previous one.

Please advice

Lokesh

[markus_doehr2]

> Thanks for the help. I downloaded the kernel available on the SAP Marketplace for R34.7 IDES which was Kernel 640 Ex2. I upgraded the kernel and restarted the installation (have not yet scratched off the system), however, it is still getting struck at the same error.

Yes, because there was an error during the initial load.

> Also, the R3load version is showing the same as previous one.

then you may not have unpacked the kernel correctly/completely. What did you donwload and where did you put it?

Markus

[Former Member]

Hi Markus

I have downloaded Installation Master 6.20/6.40 Windows Server on x64 64bit from

Installations and Upgrades -> Entry by Application Group" -> SAP Application Components" -> SAP R/3 ENTERPRISE" -> SAP R/3 ENTERPRISE 47X200 -> Windows Server -> Oracle

I uncarred and uploaded the files in the kernel directory

/usr/sap/R47/SYS/exe/run

I restarted the installation and chose start from old installation.

Lokesh

[markus_doehr2]

> Compiled Nov 30 2005 20:41:21

The error message means that the source table was not created properly.

I would delete the installation, start from scratch and use the latest version of R3load before you start the database load. Your software is VERY old.

Markus

[Former Member]

I am now not receiving the SAPUSER error. The only error i am receiving now is this as per SAPVIEW.log

F:\usr\sap\R47\SYS\exe\run/R3load.exe: START OF LOG: 20100302121409

F:\usr\sap\R47\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

F:\usr\sap\R47\SYS\exe\run/R3load.exe: version R6.40/V1.4

Compiled Nov 30 2005 20:41:21

F:\usr\sap\R47\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPVIEW.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPVIEW.log -stop_on_error

(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

(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 = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

F:\usr\sap\R47\SYS\exe\run/R3load.exe: job finished with 1 error(s)

F:\usr\sap\R47\SYS\exe\run/R3load.exe: END OF LOG: 20100302121410

Can i create teh T0001 table manually or suggest a solution guys

Lokesh

[Former Member]

I have done that and created OPS$hostname\R47ADM.SAPUSER table (R47 being the SID being used). I have also set dbs_ora_schema to be R47 as the ebnvironment varibale.

Still it is not working.

Lokesh

[Former Member]

Just create Schema.SAPUSER table and restart the installation.

for creating SAPUSER table just go through SAP note 50088(Windows) or SAP note 400241(*nix)

Regards,

Nick Loy