Forum Stats

  • 3,770,689 Users
  • 2,253,154 Discussions
  • 7,875,542 Comments

Discussions

Could not connect the Planning instance on host [19.14.1x9.2x6], port [11333], check if connect info

UR N
UR N Member Posts: 17 Red Ribbon
edited Feb 12, 2020 8:43AM in Data Integrator

Currently, we are migrating an Planning application one data center to other.

As a part of that While executing any ODI package we are getting the below error message. 

Tried the following references based on the suggestions from Oracle: But still, the error persists:

Doc ID 2014325.

Doc ID 1379286.1

Please help us if anyone have came across similar issue: Your help is much appreciated.

Traceback (most recent call last):

  File "<string>", line 30, in <module>

at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)

at com.hyperion.odi.planning.ODIPlanningConnection.<init>(Unknown Source)

at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)

at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(Unknown Source)

at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [19.14.109.216], port [11333], check if connect information is correct.

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

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$2.run(DefaultAgentTaskExecutor.java:84)

at java.lang.Thread.run(Thread.java:662)

Caused by: Traceback (most recent call last):

  File "<string>", line 30, in <module>

at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)

at com.hyperion.odi.planning.ODIPlanningConnection.<init>(Unknown Source)

at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)

at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(Unknown Source)

at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [19.14.1x9.2x6], port [11333], check if connect information is correct.

at org.python.core.PyException.fillInStackTrace(PyException.java:70)

at java.lang.Throwable.<init>(Throwable.java:181)

at java.lang.Exception.<init>(Exception.java:29)

at java.lang.RuntimeException.<init>(RuntimeException.java:32)

at org.python.core.PyException.<init>(PyException.java:46)

at org.python.core.PyException.<init>(PyException.java:43)

at org.python.core.Py.JavaError(Py.java:455)

at org.python.core.Py.JavaError(Py.java:448)

at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:177)

at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:190)

at org.python.core.PyObject.__call__(PyObject.java:414)

at org.python.core.PyObject.__call__(PyObject.java:418)

at org.python.pycode._pyx4.f$0(<string>:64)

at org.python.pycode._pyx4.call_function(<string>)

at org.python.core.PyTableCode.call(PyTableCode.java:165)

at org.python.core.PyCode.call(PyCode.java:18)

at org.python.core.Py.runCode(Py.java:1204)

at org.python.core.Py.exec(Py.java:1248)

at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

Caused by: com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [19.14.109.216], port [11333], check if connect information is correct.

at com.hyperion.odi.planning.wrapper.PlanningWrapper.init(Unknown Source)

at com.hyperion.odi.planning.ODIPlanningConnection.<init>(Unknown Source)

at com.hyperion.odi.planning.PlanningConnectionFactory.getAppWriter(Unknown Source)

at com.hyperion.odi.connection.HypAppConnectionFactory.getWriter(Unknown Source)

at com.hyperion.odi.connection.HypAppConnectionFactory.getAppWriter(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

Caused by: java.rmi.NotBoundException: HspBeanFactory

at sun.rmi.registry.RegistryImpl.lookup(RegistryImpl.java:114)

at sun.rmi.registry.RegistryImpl_Skel.dispatch(Unknown Source)

at sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:390)

at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:248)

at sun.rmi.transport.Transport$1.run(Transport.java:159)

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

at sun.rmi.transport.Transport.serviceCall(Transport.java:155)

at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)

at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)

at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

at java.lang.Thread.run(Thread.java:662)

at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:255)

at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:233)

at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:359)

at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)

at java.rmi.Naming.lookup(Naming.java:84)

We had also tried the solution provided by you(updating RMPpath.properties file) but still we are getting the same issue.

Tagged:

Answers

  • UR N
    UR N Member Posts: 17 Red Ribbon
    edited Feb 6, 2020 11:29AM

    @JohnGoodwin

    Can you please look if you come across a similar issue

  • UR N
    UR N Member Posts: 17 Red Ribbon
    edited Feb 6, 2020 11:56AM
  • UR N
    UR N Member Posts: 17 Red Ribbon
    edited Feb 10, 2020 8:40AM

    We solved this issue by reconfiguring the RMI to planning.

    But post this got struck with the following issue:

    org.apache.bsf.BSFException: exception from Jython:

    Traceback (most recent call last):

      File "<string>", line 50, in <module>

    TypeError: loadData(): expected 1 args; got 2

    at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

    at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

    at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

    at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

    at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

    at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

    at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

    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 oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:380)

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

    at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:312)

    at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:304)

    at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:874)

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

    at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)

    at java.lang.Thread.run(Thread.java:662)

    Caused by: Traceback (most recent call last):

      File "<string>", line 50, in <module>

    TypeError: loadData(): expected 1 args; got 2

    at org.python.core.PyException.fillInStackTrace(PyException.java:70)

    at java.lang.Throwable.<init>(Throwable.java:181)

    at java.lang.Exception.<init>(Exception.java:29)

    at java.lang.RuntimeException.<init>(RuntimeException.java:32)

    at org.python.core.PyException.<init>(PyException.java:46)

    at org.python.core.PyException.<init>(PyException.java:43)

    at org.python.core.PyException.<init>(PyException.java:61)

    at org.python.core.Py.TypeError(Py.java:195)

    at org.python.core.PyReflectedFunction.throwError(PyReflectedFunction.java:195)

    at org.python.core.PyReflectedFunction.throwArgCountError(PyReflectedFunction.java:248)

    at org.python.core.PyReflectedFunction.throwError(PyReflectedFunction.java:305)

    at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:156)

    at org.python.core.PyObject.__call__(PyObject.java:355)

    at org.python.core.PyMethod.__call__(PyMethod.java:215)

    at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

    at org.python.core.PyMethod.__call__(PyMethod.java:206)

    at org.python.core.PyObject.__call__(PyObject.java:414)

    at org.python.core.PyObject.__call__(PyObject.java:418)

    at org.python.pycode._pyx16.f$0(<string>:54)

    at org.python.pycode._pyx16.call_function(<string>)

    at org.python.core.PyTableCode.call(PyTableCode.java:165)

    at org.python.core.PyCode.call(PyCode.java:18)

    at org.python.core.Py.runCode(Py.java:1204)

    at org.python.core.Py.exec(Py.java:1248)

    at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

    at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

    ... 19 more