IDES BW 7.00 Installation Error

[former_member256254]

Hi,

We are facing problem with IDES-BW Installation.

During ABAP Import, all objects imported successfully but failed in

SAPVIEW (SAPVIEW.log attached).

SAPVIEW trying to create view from Table T0001 and T0002 which does not

exist. Several note suggesting to check for error during table

creation,but that is not the case here. Every tables created successfully.

Logs: sapview.log, sapinst.log, sapinst_dev.log, import_monitor.java.logare provided

Please Help.

Steps for Reconstruction

1. Install IDES BW using this Material:

D51032257 -> Java Component

D51032416_1 -> Export Disc 1

D51032416_2 -> Export Disc 2

D51032419 -> Installation Master

JDK 1.4.2_21

2. Choose:

SAP Netweaver 2004s SR2

SAP Systems

Oracle

Central System

3. During ABAP Import, Object SAPVIEW will error with message:

(DB) ERROR: DDL statement failed

(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:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

[Former Member · Accepted solution]

The tables are not T0001/T0002, you are missing tables /EACC/T_MSG_CTXT and /EACC/T_MSG

Check if they exist, and if they don't (what i suspect), then check the logs to find out why. Please also have a look at sap note [709389 - Problems during load of SAPVIEW|https://service.sap.com/sap/support/notes/709389]

Regards, Michael

[former_member256254]

We have solved this problem.

SOrry for just posting.