Analytics Software

Hi John,

I am using ODI to build dimensions in Planning, I have created respective Package and Scenarios for loading. The problem comes when I try to start the scenario using Startscen command from Command Prompt on the ODI server, I get the below message :-

ODI_CONTEXT jar:file:/D:/OraHome_1/oracledi/lib/sunopsis.zip!/com/sunopsis/graphical/gif/state/error.gif 2009-05-09 13:27:22.0 2009-05-09 13:27:58.0 35 7000 org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):

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

com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host [localhost], 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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java)
at org.python.core.PyObject.__call__(PyObject.java)
at org.python.core.PyObject.invoke(PyObject.java)
at org.python.pycode._pyx12.f$0(<string>:30)
at org.python.pycode._pyx12.call_function(<string>)
at org.python.core.PyTableCode.call(PyTableCode.java)
at org.python.core.PyCode.call(PyCode.java)
at org.python.core.Py.runCode(Py.java)
at org.python.core.Py.exec(Py.java)
at org.python.util.PythonInterpreter.exec(PythonInterpreter.java)
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)
at com.sunopsis.dwg.codeinterpretor.k.a(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
at com.sunopsis.dwg.cmd.e.i(Unknown Source)
at com.sunopsis.dwg.cmd.h.y(Unknown Source)
at com.sunopsis.dwg.cmd.e.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Caused by: java.rmi.UnmarshalException: error unmarshalling return; nested exception is:
java.io.EOFException
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at com.hyperion.planning.HyperionPlanningBeanFactoryImpl_Stub.createHspHALBean(Unknown Source)
... 36 more

Caused by: java.io.EOFException
at java.io.ObjectInputStream$BlockDataInputStream.peekByte(Unknown Source)
at java.io.ObjectInputStream.readObject0(Unknown Source)
at java.io.ObjectInputStream.readObject(Unknown Source)
at sun.rmi.server.UnicastRef.unmarshalValue(Unknown Source)
... 38 more

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

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.k.a(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
at com.sunopsis.dwg.cmd.e.i(Unknown Source)
at com.sunopsis.dwg.cmd.h.y(Unknown Source)
at com.sunopsis.dwg.cmd.e.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)


Also this kind of error comes when I try to run the scenario,package or interface manually from the tool. I just want to confirm whether we need to start agent also if we run the dimensional load from Command Prompt. Although I am able to perform the build after some retries but I cannot automate the process with this error coming up again and again. Can you please help me in this regard.


---XAT