1 Reply Latest reply on Nov 8, 2012 12:30 PM by 959628

    ODI 11.1.1 and OLAP (HYPERION) integration

    959628
      Hi,
      I am running version 11.1.1 of ODI and want to interface with OLAP.
      I have tried to follow the documentation http://docs.oracle.com/cd/E14571_01/integrate.1111/e12644/oracle_olap.htm

      This section is the my main interest:
      *"The RKM Oracle OLAP (Jython) uses in addition Oracle OLAP libraries. Copy the awxml.jar and olap_api.jar from the ORACLE_HOME/olap/api/lib folder into the additional drivers folder for ODI."*

      But both files and directory's don't exist where the documents say. I found the jar files from jDeveloper directory but cant even figure out where to put them.
      Scatter gun approach doesn't seem to have worked!

      Any one got this working ?

      Tagged in the generic error below to help others find this:

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (most recent call last):
      File "<string>", line 1, in <module>
      ImportError: No module named AWXML

           at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
           at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
           at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)
           at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)
           at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
           at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
           at java.lang.Thread.run(Thread.java:662)
      Caused by: Traceback (most recent call last):
      File "<string>", line 1, in <module>
      ImportError: No module named AWXML

           at org.python.core.PyException.fillInStackTrace(PyException.java:70)
           at java.lang.Throwable.<init>(Throwable.java:181)
           at java.lang.Exception.<init>(Exception.java:29)
           at java.lang.RuntimeException.<init>(RuntimeException.java:32)
           at org.python.core.PyException.<init>(PyException.java:46)
           at org.python.core.PyException.<init>(PyException.java:43)
           at org.python.core.PyException.<init>(PyException.java:61)
           at org.python.core.Py.ImportError(Py.java:264)
           at org.python.core.imp.import_logic(imp.java:707)
           at org.python.core.imp.import_name(imp.java:761)
           at org.python.core.imp.importName(imp.java:806)
           at org.python.core.ImportFunction.__call__(__builtin__.java:1232)
           at org.python.core.PyObject.__call__(PyObject.java:367)
           at org.python.core.__builtin__.__import__(__builtin__.java:1202)
           at org.python.core.__builtin__.__import__(__builtin__.java:1185)
           at org.python.core.imp.importAll(imp.java:904)
           at org.python.pycode._pyx1.f$0(<string>:32)
           at org.python.pycode._pyx1.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)
           ... 19 more
        • 1. Re: ODI 11.1.1 and OLAP (HYPERION) integration
          959628
          I altered the config file odi.conf in C:\oracle\product\11.1.1\Oracle_ODI_2\oracledi\client\odi\bin
          and added two lines
          AddJavaLibFile c:/awxml.jar
          AddJavaLibFIle c:/olap_api.jar

          They are now picked up but looks like my source for the files is out and i need to look for the ones in the OLAP install!

          Edited by: 956625 on Nov 8, 2012 4:29 AM