Oracle Weblogic Server (MOSC)

MOSC Banner

ODI-1227: Task Load JMS to XML-LKM JMS XML to SQL- fails on the source connection PDS_ITEMS_2_J2EE.

Dear Team,


When I am running the ODI batches getting the below exception, any suggestions to resolve:


ODI-1227: Task Load JMS to XML-LKM JMS XML to SQL- fails on the source connection PDS_ITEMS_2_J2EE.

Caused By: java.sql.SQLException: javax.jms.JMSException: Exception while fetching message

at com.sunopsis.jdbc.driver.SnpsDriverStatement.executeQuery(SnpsDriverStatement.java:143)

at com.sunopsis.jdbc.driver.SnpsDriverPreparedStatement.executeQuery(SnpsDriverPreparedStatement.java:140)

at com.sunopsis.jdbc.driver.JMSXMLStatement.loadJMS(JMSXMLStatement.java:683)

at com.sunopsis.jdbc.driver.JMSXMLStatement.execute(JMSXMLStatement.java:147)

at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)

at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center