4 Replies Latest reply: Aug 20, 2013 11:04 AM by MeHyper RSS

    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