Skip to Content
avatar image
Former Member

view or table not found: ME trying to access WIP & ODS w/o adressing scheme

Dear All,

I've come across an issue regarding data integration via SAPMEINT and I was wondering if anyone could help me out. What I am looking for is information as to whether it is a matter of configuration (if so - what do I need to do?) or whether this is an actual bug.

Importing ZLOIPRO01s from SAP ERP, I transformed them into standard LOIPRO01s which works fine. Then however I get an error message in MII Queue Monitor saying

(Failed in component: sap.com/meear) Exception raised from invocation of public com.sap.me.frame.Data com.sap.me.production.ProductionOrderSOBean.create(com.sap.me.frame.Data,java.util.Map) throws com.sap.me.frame.BasicBOBeanException method on bean instance com.sap.me.production.ProductionOrderSOBean@7dd3c767 for bean sap.com/meearxml|me.production.ejb-5.2.5.3-Base.jarxml|ProductionOrderSO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLException: ORA-00942: Tabelle oder View nicht vorhanden

To make things easier, this is the actual SQL statement:

SELECT

REVISION

FROM

BOM

WHERE

BOM='2215919-000000101987620000-3-1' AND

SITE='1300' AND

BOM_TYPE='H' AND

(REVISION LIKE 'A-%' OR

REVISION='A' )

UNION

SELECT

REVISION

FROM

AR_BOM

WHERE

BOM='2215919-000000101987620000-3-1' AND

SITE='1300' AND

BOM_TYPE='H' AND

(REVISION LIKE 'A-%' OR

REVISION='A' )

Apparently, ME is trying to access different DB schemes without addressing them. Hence my question: Do I need to modify config or is it a bug?

Thanking You

Stefan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 01, 2011 at 09:54 AM

    HI,

    It looks like synonyms to ODS/ARC database have not been created. That's why AR_ table cannot be found. Please makes sure synonyms creation script is run.

    Regards,

    Konstantin

    Add comment
    10|10000 characters needed characters exceeded