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)