When Running A Data Load From ARM and the EXPORTTOARM Scenario In ODI Does Not Start "MessageDrivenBean threw an Exception in on Message()" (Doc ID 1670348.1)

Last updated on FEBRUARY 07, 2023

Applies to:

Symptoms

When running a data load from ARM, the EXPORTTOARM scenario in ODI does not start.

The  following errors can be seen in the ERPi/ODI/SOA logs (NOTE: These errors are misleading):

ERPi log:
####<Apr 1, 2014 1:47:05 PM EDT> <Warning> <EJB> <server_name> <ErpIntegrator2> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <OracleSystemUser> <> <> <1396374425246> <BEA-010065> <MessageDrivenBean threw an Exception in onMessage(). The exception was:
java.lang.RuntimeException: [MessageID: urn:9183D9C0B9C511E3BF4F5916C777D464] Request processor MDB failed..
java.lang.RuntimeException: [MessageID: urn:9183D9C0B9C511E3BF4F5916C777D464] Request processor MDB failed.
at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.onMessage(AsyncMessageProcessor.java:173)
at oracle.j2ee.ws.server.jaxws.AsyncResponseProcessorMDB.onMessage(AsyncResponseProcessorMDB.java:99)
at sun.reflect.GeneratedMethodAccessor609.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
......
at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: javax.xml.soap.SOAPException: oracle.j2ee.ws.saaj.ContentTypeException: Not a valid SOAP Content-Type: text/html; charset=UTF-8
at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection.call2(HttpSOAPConnection.java:231)
at oracle.j2ee.ws.common.transport.HttpTransport.transmit(HttpTransport.java:75)

ODI log:
]]
[2014-04-01T13:47:04.647-04:00] [ErpIntegrator2] [ERROR] [ODI-1134] [] [tid: 17] [userId: <anonymous>] [ecid: 00iL9K9ziqA5yW85zjh8iW00026800076w,0:1] [APP: oraclediagent] [URI: /oraclediagent/invoke.do] Agent OracleDIAgent encountered an error: ODI-1217: Session COMM_LOAD_EXCHANGE_RATES (23701) fails with return code 156. Caused by: ODI-1226: Step p_import_grp_ledger_name fails after 1 attempt(s).[[
ODI-1217: Session COMM_LOAD_EXCHANGE_RATES (23701) fails with return code 156.
ODI-1226: Step p_import_grp_ledger_name fails after 1 attempt(s).
ODI-1228: Task p_import_grp_ledger_name (Variable) fails on the target connection FDMEE_DATA_SERVER_MSSQL.
Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeQuery(Unknown Source)
at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:54)
SOA Log:

####<Apr 1, 2014 1:47:05 PM EDT> <Error> <HTTP> <server_name> <soa_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <00iL9K8AimF5yW85zjh8iW00026800076k> <1396374425240> <BEA-101017> <[ServletContext@16362455[app:soa-infra module:/soa-infra path:/soa-infra spec-version:2.5]] Root cause of ServletException.
java.lang.AbstractMethodError: isConvertCDATA
at oracle.j2ee.ws.server.provider.ProviderPort.getConvertCData(ProviderPort.java:983)
at oracle.j2ee.ws.server.WebServiceServlet.createSOAPMessageForPOST(WebServiceServlet.java:806)
at oracle.j2ee.ws.server.WebServiceServlet.createSOAPMessageForPOST(WebServiceServlet.java:735)
at oracle.j2ee.ws.server.WebServiceServlet.createSOAPMessage(WebServiceServlet.java:711)
at oracle.j2ee.ws.server.provider.ProviderServlet.createSOAPMessage(ProviderServlet.java:1312)
at oracle.j2ee.ws.server.WebServiceServlet.initProcessorContext(WebServiceServlet.java:670)
at oracle.j2ee.ws.server.provider.ProviderServlet.initProcessorContext(ProviderServlet.java:826)

####<Apr 1, 2014 1:47:34 PM EDT> <Error> <HTTP> <server_name> <soa_server1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <00iL98OQMPr5yW85zjh8iW0002680006OV> <1396374454220> <BEA-101017> <[ServletContext@16362455[app:soa-infra module:/soa-infra path:/soa-infra spec-version:2.5]] Root cause of ServletException.
java.lang.AbstractMethodError: isConvertCDATA
at oracle.j2ee.ws.server.provider.ProviderPort.getConvertCData(ProviderPort.java:983)
at oracle.j2ee.ws.server.WebServiceServlet.createSOAPMessageForPOST(WebServiceServlet.java:806)
at oracle.j2ee.ws.server.WebServiceServlet.createSOAPMessageForPOST(WebServiceServlet.java:735)
at oracle.j2ee.ws.server.WebServiceServlet.createSOAPMessage(WebServiceServlet.java:711)
at oracle.j2ee.ws.server.provider.ProviderServlet.createSOAPMessage(ProviderServlet.java:1312)
at oracle.j2ee.ws.server.WebServiceServlet.initProcessorContext(WebServiceServlet.java:670)
at oracle.j2ee.ws.server.provider.ProviderServlet.initProcessorContext(ProviderServlet.java:826)
at oracle.integration.platform.blocks.soap.FabricProviderServlet.initProcessorContext(FabricProviderServlet.java:212)
at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:486)

Changes

 Upgrade of Financial Close Management/Account Reconcillation Manager from version 11.1.2.2.x to 11.1.2.3.x.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.