Hi,
I'm getting below error msg during SAPVIEW creation step in SAP BIW IDES..I've Java 1.4.2 installed.
....
(DB) INFO: /EACC/DMM_V_BW created
(DB) INFO: /EACC/VACCOMP created
(DB) INFO: /EACC/VJOURNALS created
<b>(DB) ERROR: DDL statement failed</b> (CREATE VIEW "/EACC/V_MSG_CTXT" ( "GUID" , "TMPDOC" , "SEQNR" , "MARK" , "CREATION_DATE" , "MSGTY" , "MSGID" , "MSGNO" , "MSGV1" , "MSGV2" , "MSGV3" , "MSGV4" ) AS SELECT T0001."GUID", T0001."TMPDOC", T0001."SEQNR", T0001."MARK", T0001."CREATION_DATE", T0002."MSGTY", T0002."MSGID", T0002."MSGNO", T0002."MSGV1", T0002."MSGV2", T0002."MSGV3", T0002."MSGV4" FROM "/EACC/T_MSG_CTXT" T0001, "/EACC/T_MSG" T0002 WHERE T0001."MSG_SID" = T0002."MSG_SID")
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
<b>ORA-00942: table or view does not exist
DbSl Trace: Disconnecting from connection 0 ...</b>
DbSl Trace: Closing user session (con_hdl=0,svchp=01237E1C,usrhp=0124280C)
DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=01237E1C,srvhp=0123A054)
DbSl Trace: Now I'm disconnected from ORACLE
(DB) INFO: disconnected from DB
<b>D:\usr\sap\PAR\SYS\exe\run/R3load.exe: job finished with 1 error(s)</b>
D:\usr\sap\PAR\SYS\exe\run/R3load.exe: END OF LOG: 20060801081727
Any help would be greately appreciated.
Thanks,
partha