Skip to Content
0
Apr 15, 2008 at 05:36 AM

ERROR ORA-00942 WHILE INSTALLING ENTERPRISE 4.7

11 Views

Hello Friends,

I need urgent help... I'm installing R/3 enterprise 4.7 ext. 2.00 on with Oracle 9.2.0.8 on windows server 2003. Installation of central Instance went fine but during database instance i have got error while phase R/3 load jobs stating error ORA-00942..see the SAPVIEW.log file below.

E:\usr\sap\PRD\SYS\exe\run/R3load.exe: START OF LOG: 20100414182309

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

E:\usr\sap\PRD\SYS\exe\run/R3load.exe: version R6.40/V1.4

E:\usr\sap\PRD\SYS\exe\run/R3load.exe -ctf I D:/exp7/DATA/SAPVIEW.STR C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/DDLORA.TPL C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPVIEW.TSK ORA -l C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPVIEW.log -o D

E:\usr\sap\PRD\SYS\exe\run/R3load.exe: job completed

E:\usr\sap\PRD\SYS\exe\run/R3load.exe: END OF LOG: 20100414182310

E:\usr\sap\PRD\SYS\exe\run/R3load.exe: START OF LOG: 20100414194324

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

E:\usr\sap\PRD\SYS\exe\run/R3load.exe: version R6.40/V1.4

E:\usr\sap\PRD\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

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) INFO: /SAPTRX/A_CONDF4 created #20100414194324

(DB) INFO: /SAPTRX/VDASFEV created #20100414194324

(DB) INFO: /SAPTRX/VDASFPAR created #20100414194324

(DB) INFO: /SAPTRX/VD_AOMIL created #20100414194324

(DB) INFO: /SAPTRX/VD_AOPAC created #20100414194325

(DB) INFO: /SAPTRX/VD_AOPAE created #20100414194325

(DB) INFO: /SAPTRX/VD_AOPAI created #20100414194325

(DB) INFO: /SAPTRX/VD_AOPAR created #20100414194325

(DB) INFO: /SAPTRX/VD_AOTD1 created #20100414194325

(DB) INFO: /SAPTRX/VD_AOTD2 created #20100414194325

(DB) INFO: /SAPTRX/VD_AOTDD created #20100414194325

(DB) INFO: /SAPTRX/VD_AOTYP created #20100414194325

(DB) INFO: /SAPTRX/VD_ASPAR created #20100414194325

(DB) INFO: /SAPTRX/VD_CONDL created #20100414194325

(DB) ERROR: DDL statement failed

(CREATE VIEW "/SAPTRX/V_AODD02" ( "TRK_OBJ_TYPE" , "TABLEDEF" , "DDICDEF" , "DBTAB" , "DDLANGUAGE" , "DDTEXT" , "AS4LOCAL" ) AS SELECT T0001."TRK_OBJ_TYPE", T0001."TABLEDEF", T0001."DDICDEF", T0001."DBTAB", T0003."DDLANGUAGE", T0003."DDTEXT", T0002."AS4LOCAL" FROM "/SAPTRX/AOALLTAB" T0001, "DD02L" T0002, "DD02T" T0003 WHERE T0002."TABNAME" = T0001."DDICDEF" AND T0002."TABNAME" = T0003."TABNAME" AND T0002."AS4LOCAL" = 'A')

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

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

E:\usr\sap\PRD\SYS\exe\run/R3load.exe: END OF LOG: 20100414194325

i have gone through few solution from sdn.sap ...like as stated in sapnote : 134592 and run sapdba_role.sql but it is also not working either. tried few other things also but not seems be working..

so can anybody solve my problems.????? Thanks in advancee.....