Forum Stats

  • 3,838,648 Users
  • 2,262,387 Discussions


ODI for planning problem

669812 Member Posts: 2
edited Nov 11, 2008 8:11AM in Planning and Budgeting
Dear all,

I'm a newbie with ODI.

I've been following the document "Oracle data integrator adapter for hyperion planning" guide and have set up the followings:

- Data server (with the 11333 port)
- Physical and logical schemas and linked with a context
- a classical application built in planning

Yet when I try to run the reverse with the RKM Hyperion Planning, I got the following errors instantly. Anyone has a clue on what's happening?

Thanks a million to the guru's here :)

org.apache.bsf.BSFException: exception from Jython: Traceback (innermost last):

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

ImportError: cannot import name ODIConstants

at org.apache.bsf.engines.jython.JythonEngine.exec(Unknown Source)

at com.sunopsis.dwg.codeinterpretor.k.a(

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(

at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(

at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(

at com.sunopsis.dwg.cmd.DwgCommandBase.execute(

at com.sunopsis.dwg.cmd.e.i(

at com.sunopsis.dwg.cmd.h.y(


at Source)


  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond

    It sounds like it is not picking up the planning jar files in the oracledi\drivers directory.
    Can you confirm they are in there.

    Also you may want to have a read of my blog as I have covered many areas of ODI and it may be some use to you.


This discussion has been closed.