1 Reply Latest reply on Feb 27, 2014 10:57 PM by Ayush Ganeriwal-Oracle

    ODI to IBM DB2 UDB Connectivity

    Rashmik

      Hello All

       

      I am trying to create a connection between ODI to IBM DB2 UDB. After entering all DB2 server information in ODI, i try to test the connection using OracleDIAgent but its show me the below error.

       

      oracle.odi.runtime.agent.invocation.InvocationException: ODI-1424: Agent host or port cannot be reached using HTTP://test.com.au:7005/oraclediagent.

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.reThrowAgentErrorAsInvocation(RemoteRuntimeAgentInvoker.java:932)

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:291)

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:653)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:847)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteConnect(SnpsDialogTestConnet.java:820)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.jButtonTest_ActionPerformed(SnpsDialogTestConnet.java:758)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.connEtoC1(SnpsDialogTestConnet.java:137)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1(SnpsDialogTestConnet.java:133)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$IvjEventHandler.actionPerformed(SnpsDialogTestConnet.java:87)

      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)

      at java.awt.Component.processMouseEvent(Component.java:6290)

      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)

      at java.awt.Component.processEvent(Component.java:6055)

      at java.awt.Container.processEvent(Container.java:2039)

      at java.awt.Component.dispatchEventImpl(Component.java:4653)

      at java.awt.Container.dispatchEventImpl(Container.java:2097)

      at java.awt.Component.dispatchEvent(Component.java:4481)

      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)

      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)

      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)

      at java.awt.Container.dispatchEventImpl(Container.java:2083)

      at java.awt.Window.dispatchEventImpl(Window.java:2482)

      at java.awt.Component.dispatchEvent(Component.java:4481)

      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)

      at java.awt.EventQueue.access$000(EventQueue.java:84)

      at java.awt.EventQueue$1.run(EventQueue.java:607)

      at java.awt.EventQueue$1.run(EventQueue.java:605)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

      at java.awt.EventQueue$2.run(EventQueue.java:621)

      at java.awt.EventQueue$2.run(EventQueue.java:619)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

      at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

        • 1. Re: ODI to IBM DB2 UDB Connectivity
          Ayush Ganeriwal-Oracle

          As the error message says your client is not able to reach the given agent. Please check if your agent is up and running on the given URL. Or else you can select local agent for such connection test.

           

          When you select a particular agent to test a dataserver connection then ODI would send the connection details to the selected agent and then agent tests the connection to the dataserver. This would ensure that the connectivity is properly setup between agent and dataserver.