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 JUNE 20, 2017

Applies to:

Hyperion Financial Close Management - Version 11.1.2.3.000 to 11.1.2.3.500 [Release 11.1]
Information in this document applies to any platform.
12.1.15

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)'> <<WLS Kernel>> <> <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)'> <<WLS Kernel>> <> <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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms