2 Replies Latest reply: Mar 1, 2014 1:53 PM by Krishan-Oracle RSS

    Jms XML message error

    974238

      HI,

      we are getting following error when we tried to load xml message through jms message queue and we are using  lkm jms to SQL and ikm SQL control append km.any ideas:

      ODI-1227: Task SrcSet0 (Loading) fails on the source JMS_QUEUE_XML connection C2_BT_QL.ODS.NTFYCNSLDTORDRSTS.RCV.

      Caused By: java.sql.SQLException: class java.sql.SQLException

      java.lang.NullPointerException

                      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)

                      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                      at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)

                      at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)

                      at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

                      at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)

                      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                      at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)

                      at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                      at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                      at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                      at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)

                      at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)

                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)

                      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)

                      at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

                      at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

                      at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

                      at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)

                      at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

                      at org.mortbay.jetty.Server.handle(Server.java:326)

                      at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)

                      at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)

                      at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)

                      at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)

                      at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

                      at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)

                      at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)