7 Replies Latest reply on Jul 6, 2019 6:10 PM by Adrian_Popescu-Oracle

    Reverse engineering Hyperion Essbase connection failed in ODI 12c

    3554631

      Hi All,

       

      I am facing an issue in ODI 12c(12.2.1.3) while connecting to Hyperion Essbase(11.1.2). It will be very much helpful to me, if anyone suggest a solution for this.

       

      Below is the error code:

       

      ODI-1226: Step HYPERION_ESSBASE fails after 1 attempt(s).

      ODI-1229: An error occurred while performing a Reverse operation on model code HYPERION_ESSBASE.

      ODI-1590: The execution of the script failed.

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

      Traceback (most recent call last):

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

      at com.hyperion.odi.essbase.wrapper.EssbaseConnection.connect(Unknown Source)

      at com.hyperion.odi.essbase.ODIEssbaseConnection.connect(Unknown Source)

      at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)

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

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

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

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

       

       

      java.lang.NoClassDefFoundError: java.lang.NoClassDefFoundError: com/essbase/api/session/IEssbase$Home

       

       

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

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

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

      at oracle.odi.runtime.agent.execution.interpreter.SessionTaskScriptingInterpretor.scripting(SessionTaskScriptingInterpretor.java:190)

      at oracle.odi.runtime.agent.execution.SessionTask.scripting(SessionTask.java:105)

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

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

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

      at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)

      at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)

      at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)

      at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)

      at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)

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

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)

      at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)

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

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

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

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

      Caused by: Traceback (most recent call last):

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

      at com.hyperion.odi.essbase.wrapper.EssbaseConnection.connect(Unknown Source)

      at com.hyperion.odi.essbase.ODIEssbaseConnection.connect(Unknown Source)

      at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)

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

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

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

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

       

       

      java.lang.NoClassDefFoundError: java.lang.NoClassDefFoundError: com/essbase/api/session/IEssbase$Home

       

       

      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.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:381)

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

      at org.python.pycode._pyx0.f$0(<string>:59)

      at org.python.pycode._pyx0.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)

      ... 21 more

      Caused by: java.lang.NoClassDefFoundError: com/essbase/api/session/IEssbase$Home

      at com.hyperion.odi.essbase.wrapper.EssbaseConnection.connect(Unknown Source)

      at com.hyperion.odi.essbase.ODIEssbaseConnection.connect(Unknown Source)

      at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)

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

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

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

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

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

      ... 35 more

      Caused by: java.lang.ClassNotFoundException: com.essbase.api.session.IEssbase$Home cannot be found by oracle.odi.navigator_12.2.1

      at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501)

      at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421)

      at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412)

      at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)

      at org.netbeans.modules.netbinox.NetbinoxLoader.loadClass(NetbinoxLoader.java:81)

      at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

      ... 43 more

       

      Note: Even I tried connecting Essbase (11.1.2) with OBIEE RPD, but its showing "Cannot connect to datasource   Essbase Error 46".

       

      Regards,

      Mahesh