on 03-01-2011 8:13 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Torsten
there is a log for CTC execution, but also a separate one for the SQL execution during CTC. It can be found here:
http://server:port/webdynpro/resources/sap.com/xapps~me~ctc~wdcontent/MigrationUIApp
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.