R3 data load error

[Former Member]

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

[Former Member]

it looks very much like the table /EACC/T_MSG_CTXT was not imported properly before. Check the other r3load log files.

If this does not help you, please open a message at service.sap.com.

regards

Peter