Forum Stats

  • 3,838,648 Users
  • 2,262,387 Discussions
  • 7,900,715 Comments

Discussions

ODI for planning problem

669812
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(k.java)

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

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

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

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

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

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

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

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

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

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

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

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

at com.sunopsis.dwg.cmd.e.run(e.java)

at java.lang.Thread.run(Unknown Source)

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    Hi,

    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.

    Cheers

    John
    http://john-goodwin.blogspot.com/
This discussion has been closed.