4 Replies Latest reply on Aug 20, 2013 4:04 PM by MeHyper

    Issue while Reverse Engineering the HFM Application

    972284
      Hi,

      We are in the process of integrating HFM (11.1.2.2.0) with ODI (11.1.1.6) for metadata upload from ODI to HFM, and, I am getting the following error while reverse engineering to the HFM application.

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (most recent call last):
      File "<string>", line 38, in <module>
           at com.hyperion.odi.hfm.ODIHFMAppConnection.<init>(ODIHFMAppConnection.java:58)

           at com.hyperion.odi.hfm.ODIHFMAppReverser.connect(ODIHFMAppReverser.java:27)

           at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)

           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

           at java.lang.reflect.Method.invoke(Method.java:597)


      com.hyperion.odi.common.ODIHAppException: com.hyperion.odi.common.ODIHAppException: Error occurred while loading driver.

           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 38, in <module>
           at com.hyperion.odi.hfm.ODIHFMAppConnection.<init>(ODIHFMAppConnection.java:58)

           at com.hyperion.odi.hfm.ODIHFMAppReverser.connect(ODIHFMAppReverser.java:27)

           at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)

           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

           at java.lang.reflect.Method.invoke(Method.java:597)


      com.hyperion.odi.common.ODIHAppException: com.hyperion.odi.common.ODIHAppException: Error occurred while loading driver.

           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.Py.JavaError(Py.java:455)
           at org.python.core.Py.JavaError(Py.java:448)
           at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:177)
           at org.python.core.PyObject.__call__(PyObject.java:355)
           at org.python.core.PyMethod.__call__(PyMethod.java:215)
           at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)
           at org.python.core.PyMethod.__call__(PyMethod.java:206)
           at org.python.core.PyObject.__call__(PyObject.java:381)
           at org.python.core.PyObject.__call__(PyObject.java:385)
           at org.python.pycode._pyx0.f$0(<string>:38)
           at org.python.pycode._pyx0.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
      Caused by: com.hyperion.odi.common.ODIHAppException: Error occurred while loading driver.
           at com.hyperion.odi.hfm.ODIHFMAppConnection.<init>(ODIHFMAppConnection.java:58)
           at com.hyperion.odi.hfm.ODIHFMAppReverser.connect(ODIHFMAppReverser.java:27)
           at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)
           ... 33 more
      Caused by: com.hyperion.odi.hfm.wrapper.HFMException: Error occurred while loading driver.
           at com.hyperion.odi.hfm.wrapper.HFMServer.<init>(HFMServer.java:29)
           at com.hyperion.odi.hfm.ODIHFMAppConnection.<init>(ODIHFMAppConnection.java:51)
           ... 40 more
      Caused by: com.hyperion.odi.hfm.wrapper.HFMException: C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\drivers\HFMDriver.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform
           at com.hyperion.odi.hfm.wrapper.HFMDriverJNI.getDriver(HFMDriverJNI.java:23)
           at com.hyperion.odi.hfm.wrapper.HFMServer.<init>(HFMServer.java:26)
           ... 41 more

      Can anyone please suggest a suitable solution for this?

      Thanks
      Abhi
        • 1. Re: Issue while Reverse Engineering the HFM Application
          olivier Rochon
          Hi,

          Under the readme eRPI : http://docs.oracle.com/cd/E17236_01/epm.1112/readme/erpi_1112200_readme.html

          I find this :
          -----------------------------------------------------------------------------------------------
          ODI Setup Steps to Integrate with Financial Management

          To setup the ODI to integrate with Financial Management:
          Rename odiparams.bat located at <ODI_HOME>\oracledi\agent\bin to odiparams.bat.backup.

          The default installation location is C:\app\Oracle\product\11.1.1\Oracle_ODI_1.
          Download Oracle Data Integrator Companion CD 11.1.1.6.2.
          Unzip the contents of the Companion CD to the temp directory.
          Unzip oracledi-agent-standalone.zip.
          Copy the contents to: <ODI_HOME>.
          Make a backup of the HFMDriver.DLL.
          For the 32 bit operating system, copy HFMDriver32_11.1.2.2.dll as HFMDriver.DLL.
          For the 64bit operating system, copy HFMDriver64_11.1.2.2.dll as HFMDriver.DLL.
          Rename odiparams.bat.backup from Step 1 to odiparams.
          Edit the PATH to include: <ODI_HOME>\oracledi.sdk\lib

          Restart the ODI Agent.
          -----------------------------------------------------------------------------------------------------------
          I try this procedure, but now, I have a new error :
          - Unable to connect on "myhfmserver" with "admin" user

          I think that, there is another step to do, because now HFM 11.1.2.2 use directly the "EPM Registry" (into Shared Services Schema) to retreive the HFM servers ou Clusters.
          But I don't find any information, how to setup this part into ODI.

          Or may be, we need to setup "Regedit Keys" into Windows registry like previous HFM release ?

          If you have any news, please inform me
          • 2. Re: Issue while Reverse Engineering the HFM Application
            olivier Rochon
            Hi,

            To complete me post,

            the exact error is
            "com.hyperion.odi.common.ODIHAppException: com.hyperion.odi.common.ODIHAppException: Error occurred in driver while *connecting* to Financial Management application [COMMA] on [SRV-W2K8-64R2] using user-name [admin]."

            I find a log under "c:\hfm.odl.log" :

            [2012-12-05T10:01:53+01:00] [EPMFM] [ERROR:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: SRV-W2K8-64R2] [pid: 4180] [tid: HFM Message] [userId: ] [file: CHsxClient.cpp] [line: 895] [version: 11.1.2.2.301.3787] [appName: odi.exe] [devString: CHsxClient::InternalCreateObjectOnCluster: cluster = SRV-W2K8-64R2, Num Servers = 0, ] [paramString: ] Server/Cluster is incorrectly configured. Please reconfigure your Cluster or Server connection.


            But I can confirm that the server "SRV-W2K8-64R2" is well the HFM DCOM Server, and the application "COMMA" is well opened through the Web
            • 3. Re: Issue while Reverse Engineering the HFM Application
              923820
              Did you ever figure this out?
              • 4. Re: Issue while Reverse Engineering the HFM Application
                MeHyper

                Hi Abhi

                Were you able to resolve this issue I am getting same error while tryign to reverse engineer suing ODI 11.1.1.7 against HFM 11.1.1.2.4.

                 

                Please advice.

                 

                Regards

                Venkat