1 Reply Latest reply: Feb 7, 2013 5:47 PM by Alex Kotopoulis RSS

    ODI JMS_QUEUE_XML Reading Issue

    988997
      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