This discussion is archived
1 Reply Latest reply: Feb 7, 2013 3:47 PM by 662012 RSS

ODI JMS_QUEUE_XML Reading Issue

988997 Newbie
Currently Being Moderated
Hi

I am new to ODI. I have an issue with one of the package. The package ran fine until yesterday.

Today when i ran it is giving below error. I suspect that when ODI is validating the XML file with XSD it is failing with below error.

Error Message

ODI-1227: Task SrcSet0 (Loading) fails on the source JMS_QUEUE_XML connection DEV_MQ_xxx_XML.
Caused By: java.sql.SQLException: class java.sql.SQLException
java.lang.NumberFormatException: For input string: ""
     at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:459)
     at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.readStream(SnpsXmlConnection.java:1500)
     at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.loadJMS(JMSXMLPreparedStatement.java:768)
     at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.execute(JMSXMLPreparedStatement.java:154)
     at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
     at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
     at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
     at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

Can we preview the data which is IBM MQ Series.

Please suggest.

Thanks
Muthu.

Edited by: 985994 on 05-Feb-2013 01:35

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points