"ImportError: No module named Hyperion" when reversing RKM Hyperion Planning [ID 754779.1]

---

 

 

Applies to:

Hyperion Planning - Version: 9.2.1.0.00 to 11.1.2.1.000 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Planning 9.3.1.2
ODI 10.1.3.4.0

Symptoms

When you try to reverse engineer RKM Hyperion Planning, you get:
org.apache.bsf.BSFException: exception from Jython: Traceback (innermost last):
File "", line 3, in ?

ImportError: No module named hyperion
at org.apache.bsf.engines.jython.JythonEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.k.a(k.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java)
...

Cause

When Local (No agent) is used as the agent, execution is local to the client, not the ODI server. In this case, driver files must be installed to the client machine.

Solution

Install the driver files on the machine where the Agent runs -- in this case, the client. 

To install the Hyperion adapters you: 
1. Unzip 
2. Copy all files in the Drivers folder to the Drivers folder under ODI install, e.g. c:\OraHome_1\oracledi\drivers