6 Replies Latest reply on Jun 10, 2019 6:58 PM by ShaneBordeaux

    ODI 12c to Essbase 11.1.2.4 Reverse Engineer Fail

    ShaneBordeaux

      Hi All,

       

      So there seems to be a simple fix for this issue, however, I have tried the fix and it has not solved it for me. I have copied the ess_japi.jar and ess_es_server.jar files into a directory that ODI has access to and I made the odi.conf entry but no dice. FYI I'm on Windows.

       

      Here's my error:

      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 50, in <module>
      at com.hyperion.odi.essbase.ODIEssbaseConnection.<init>(Unknown Source)

      at com.hyperion.odi.essbase.EssbaseConnectionFactory.getAppConnection(Unknown Source)

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

      at com.hyperion.odi.connection.HypAppConnectionFactory.getAppConnection(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:498)

      java.lang.NoClassDefFoundError: java.lang.NoClassDefFoundError: com/essbase/api/base/EssException

      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.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
      at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at java.lang.Thread.run(Thread.java:748)
      Caused by: Traceback (most recent call last):
        File "<string>", line 50, in <module>
      at com.hyperion.odi.essbase.ODIEssbaseConnection.<init>(Unknown Source)

      at com.hyperion.odi.essbase.EssbaseConnectionFactory.getAppConnection(Unknown Source)

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

      at com.hyperion.odi.connection.HypAppConnectionFactory.getAppConnection(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:498)

      java.lang.NoClassDefFoundError: java.lang.NoClassDefFoundError: com/essbase/api/base/EssException

      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._pyx8.f$0(<string>:59)
      at org.python.pycode._pyx8.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)
      ... 27 more
      Caused by: java.lang.NoClassDefFoundError: com/essbase/api/base/EssException
      at com.hyperion.odi.essbase.ODIEssbaseConnection.<init>(Unknown Source)
      at com.hyperion.odi.essbase.EssbaseConnectionFactory.getAppConnection(Unknown Source)
      at com.hyperion.odi.connection.HypAppConnectionFactory.getConnection(Unknown Source)
      at com.hyperion.odi.connection.HypAppConnectionFactory.getAppConnection(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:498)
      at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)
      ... 38 more
      Caused by: java.lang.ClassNotFoundException: com.essbase.api.base.EssException
      at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:1029)
      at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:990)
      at weblogic.utils.classloaders.GenericClassLoader.doFindClass(GenericClassLoader.java:611)
      at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:543)
      at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:496)
      at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:473)
      ... 47 more