ODI 11g JMS Connectivity

apexStarter

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