Hi Everyone,
Not sure whether this query needs to discussed here or not as I post this query in Data Integrator space but didn't got any response.
We are upgrading from ODI 10g to 11g where there are some scenarios which are using JMS queue technology.
All the scenarios that are using JMS queue are working fine on ODI 10g. But in case of 11g we first stuck with the connectivity where we were failing to test a connection with ODI 11g to JMS queue. But after doing much of research we figured out the two jars jboss-logging-spi.jar and jnp-client.jar and our test connection become successful. On proceeding further with the scenarios testing we are now facing issue for which we are getting no clue. Below are the connection parameters that we are using for JMS connectivity
JNDI Authentication : Undefined
JNDI User : User
Password : Pwd
JNDI Protocol : Undefined
JNDI Driver : org.jnp.interfaces.NamingContextFactory
JNDI Url : jnp://host-address:port
JNDI Resource : ConnectionFactory
Jboss version that we have 5.1.2GA also the jars that currently we are using as our drivers our
- jboss-logging-spi.jar
- jnp-client.jar
Below is the error log
ODI-1226: Step Publish MTM EPROC Events fails after 1 attempt(s).
ODI-1240: Flow Publish MTM EPROC Events fails while performing a Integration operation. This flow loads target table null.
ODI-1228: Task MTM_EPROC_JMSQ (Integration) fails on the target JMSQUEUE connection WSS_MM_ORD_TLC_JMSQ.
Caused By: java.sql.SQLException: ODI-40216: Error performing update
at com.sunopsis.jdbc.driver.SnpsDriverPreparedStatement.executeUpdate(SnpsDriverPreparedStatement.java:198)
at com.sunopsis.jdbc.driver.SnpsDriverPreparedStatement.execute(SnpsDriverPreparedStatement.java:117)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:54)
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.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:87)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:42)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:95)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:86)
at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:637)
at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:580)
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)
Caused by: javax.jms.JMSException: ODI-40203: Cannot find the Connection Factory (jms/QueueConnectionFactory) in JNDI
at com.sunopsis.jdbc.driver.JMSQueueConnection.getQueueConnectionFactoryFromJNDI(JMSQueueConnection.java:616)
at com.sunopsis.jdbc.driver.JMSQueueConnection.getInternalConnectionFactory(JMSQueueConnection.java:322)
at com.sunopsis.jdbc.driver.JMSQueueConnection.getInternalConnection(JMSQueueConnection.java:252)
at com.sunopsis.jdbc.driver.JMSQueueConnection.getInternalConnection(JMSQueueConnection.java:230)
at com.sunopsis.jdbc.driver.JMSQueueConnection.getInternalSession(JMSQueueConnection.java:371)
at com.sunopsis.jdbc.driver.JMSQueueConnection.treatInsertedRow(JMSQueueConnection.java:1092)
at com.sunopsis.jdbc.driver.FileSnpsTableDe.insertRow(FileSnpsTableDe.java:179)
at com.sunopsis.jdbc.driver.SnpsDriverPreparedStatement.executeUpdate(SnpsDriverPreparedStatement.java:160)
... 42 more
Caused by: java.lang.NullPointerException
at com.sunopsis.jdbc.driver.JMSQueueConnection.getQueueConnectionFactoryFromJNDI(JMSQueueConnection.java:610)
... 49 more
Any response will be highly appreciated.
Thanks,
Gaurav