4.7 IDES installation error

[Former Member]

I am doing 4.7 IDES installation and got stucked at Database Load(post processing). The error in SAPVIEW log is like this...

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20070822012704

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#5 $ SAP

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.20/V1.2

D:\usr\sap\DEV\SYS\exe\run/R3load.exe -ctf I D:\SAP3\db3\EXPORT3/DATA/SAPVIEW.STR C:\SAPinst ORACLE KERNEL/DDLORA.TPL C:\SAPinst ORACLE KERNEL/SAPVIEW.TSK ORA -l C:\SAPinst ORACLE KERNEL/SAPVIEW.log -o D

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: job completed

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20070822012705

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20070822063614

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#5 $ SAP

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.20/V1.2

D:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\SAPinst ORACLE KERNEL/SAPVIEW.cmd -l C:\SAPinst ORACLE KERNEL/SAPVIEW.log -stop_on_error

DbSl Trace: Got ORACLE_HOME=D:\oracle\ora81 from environment

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Logon as OPS$-user to get SAPDEV's password

DbSl Trace: Connecting as /@DEV on connection 0 ...

DbSl Trace: Attaching to DB Server DEV (con_hdl=0,svchp=0123E1D8,svrhp=0123DFE4)

DbSl Trace: Starting user session (con_hdl=0,svchp=0123E1D8,srvhp=0123DFE4,usrhp=0124FDCC)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: ORA-1403 when accessing table SAPUSER

DbSl Trace: Disconnecting from connection 0 ...

DbSl Trace: Closing user session (con_hdl=0,svchp=0123E1D8,usrhp=0124FDCC)

DbSl Trace: Now I'm disconnected from ORACLE

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPDEV/<pwd>@DEV on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=0123E1D8,srvhp=0123DFE4,usrhp=0124FDCC)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Database instance dev is running on KALYANI with ORACLE version 8.1.7.0.0 since 20070822

(DB) INFO: connected to DB

(DB) INFO: /SAPTRX/A_CONDF4 created

(DB) INFO: /SAPTRX/VDASFEV created

(DB) INFO: /SAPTRX/VDASFPAR created

(DB) INFO: /SAPTRX/VD_AOMIL created

(DB) INFO: /SAPTRX/VD_AOPAC created

(DB) INFO: /SAPTRX/VD_AOPAE created

(DB) INFO: /SAPTRX/VD_AOPAI created

(DB) INFO: /SAPTRX/VD_AOPAR created

(DB) INFO: /SAPTRX/VD_AOTD1 created

(DB) INFO: /SAPTRX/VD_AOTD2 created

(DB) INFO: /SAPTRX/VD_AOTDD created

(DB) INFO: /SAPTRX/VD_AOTYP created

(DB) INFO: /SAPTRX/VD_ASPAR created

(DB) INFO: /SAPTRX/VD_CONDL created

(DB) INFO: /SAPTRX/V_AODD02 created

(DB) INFO: /SAPTRX/V_DD03 created

(DB) INFO: /SAPTRX/V_DD03X created

(DB) INFO: /SDF/SMODICOMP created

(DB) INFO: /SDF/SMODIDEVC created

(DB) INFO: /SDF/UMOD_COMP created

(DB) INFO: ACEPSOIT_UPD created

(DB) INFO: ADJV_TRANS_DIF created

(DB) INFO: AFFWV0 created

(DB) INFO: AFKO_LAUFN created

(DB) INFO: AFSPLIT created

(DB) INFO: AFVCP created

(DB) INFO: ALM_ME_T003O_IS created

(DB) INFO: ALM_ME_T350I created

(DB) INFO: ALM_ME_TQ80_T created

(DB) INFO: ANEKPV created

(DB) INFO: APOUPD created

(DB) INFO: APPL_DEVC created

(DB) INFO: APPL_DIAL created

(DB) INFO: APPL_DOMA created

(DB) INFO: APPL_DTEL created

(DB) INFO: APPL_ENQU created

(DB) INFO: APPL_FUGR created

(DB) INFO: APPL_FUGRG created

(DB) INFO: APPL_FUNC created

(DB) INFO: APPL_INDX created

(DB) INFO: APPL_MCOB created

(DB) INFO: APPL_MENU created

(DB) INFO: APPL_MODS created

(DB) INFO: APPL_MSAG created

(DB) INFO: APPL_PARA created

(DB) ERROR: DDL statement failed

(CREATE VIEW "APPL_PROG" ( "PROG" , "R3STATE" , "DEVCLASS" , "OBJ_NAME" ) AS SELECT T0001."PROGNAME", T0001."R3STATE", T0002."DEVCLASS", T0002."OBJ_NAME" FROM "REPOSRC" T0001, "TADIR" T0002 WHERE T0001."PROGNAME" = T0002."OBJ_NAME" AND T0001."R3STATE" = 'A' AND T0002."PGMID" = 'R3TR' AND T0002."OBJECT" = 'PROG' AND ( T0001."SUBC" = '1' OR T0001."SUBC" = 'M' OR T0001."SUBC" = 'S' ))

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

DbSl Trace: Disconnecting from connection 0 ...

DbSl Trace: Closing user session (con_hdl=0,svchp=0123E1D8,usrhp=0124FDCC)

DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=0123E1D8,srvhp=0123DFE4)

DbSl Trace: Now I'm disconnected from ORACLE

(DB) INFO: disconnected from DB

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

D:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20070822063621

I am using windows2000 server(tried with windows 2003 also but got the same error) with Oracle 8.1.7 version & JDK.142. What could be the possible reason for this error..Please experts help me out. Its very urgent.

Thanks in advance,

Keerthi.

[Former Member]

the error indicates that one of the two tables TADIR or REPOSRC did not exists.

this happens if one of the previous installation steps which create and load the tables did not finish successfully. Have a look into the *.log files in the installation directory to find out which one did not finish successfully.

peter

[andreas_herzog]

oracle 8.1.7 is no longer supported (and never was in the case of windows 2003!)...switch to at least 9.2.0.8 or 10.2

kernel 6.20 is no longer supported as well...switch to 6.40 using the latest installation kit...

-> which java version do you exactly use? 1.4.2_??

GreetZ, AH

[Former Member]

Yes I am using 1.4.2 Java version...I searched in the forums before posting here & saw that Oracle 8.1.7 doesn't support windows 2003, so I tried windows 2000 & got stuck at the same point. Anyway I think better switch to 9.2.0 & see.

Thanks a lot,

Keerthi.

[former_member204746]

just try to continue the installation, maybe one other process was stuck and table was not yet created.