"java.lang.NoClassDefFoundError: com/essbase/api/session/IEssbase$Home" Encountered When Reverse Engineering an Essbase Model in ODI 12c

(Doc ID 2301382.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to reverse engineer a Hyperion Essbase model using Oracle Data Integrator (ODI) 12c, an ODI-1590 script error with a java.lang.NoClassDefFoundError is encountered.

Error as seen in the Standalone agent log:

ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
  File "", line 59, in
  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)
  ...

In the case of Standalone agent, the issue happens even after putting the AddJavaLibFile lines into odi.conf file:

AddJavaLibFile C:\Oracle\Middleware\Oracle_Home\odi\sdk\lib\ess_japi.jar
AddJavaLibFile C:\Oracle\Middleware\Oracle_Home\odi\sdk\lib\ess_es_server.jar

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms