4 Replies Latest reply on Oct 23, 2012 12:28 PM by 954315

    integrating HFM with ODI

    954315
      hi all,

      I am working on ODI(11.1.1) and HFM(11.1.2.2) .

      ODi Client (server1)is installed in machine -A and HFm client (server2)is installed in Machine-B .

      to work with hfm through odi, firsltly, i created data server and schemas (physical and logical ) associated through context .

      Imported knowledge module i.e) RKM HFM and created model for hfm , selected custom tab for hfm but reverse engineering is not working .


      please help?

      thanks in adavnce
        • 1. Re: integrating HFM with ODI
          954315
          iam getting error

          org.apache.bsf.BSFException: exception from Jython:
          Traceback (most recent call last):
          File "<string>", line 19, in <module>
          File "<string>", line 68, in __init__
          AttributeError: *'NoneType' object has no attribute 'getMetaData'*

               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 19, in <module>
          File "<string>", line 68, in __init__
          AttributeError: 'NoneType' object has no attribute 'getMetaData'

               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.AttributeError(Py.java:145)
               at org.python.core.PyObject.noAttributeError(PyObject.java:936)
               at org.python.core.PyObject.__getattr__(PyObject.java:931)
               at org.python.pycode._pyx1.__init__$5(<string>:70)
               at org.python.pycode._pyx1.call_function(<string>)
               at org.python.core.PyTableCode.call(PyTableCode.java:165)
               at org.python.core.PyBaseCode.call(PyBaseCode.java:297)
               at org.python.core.PyBaseCode.call(PyBaseCode.java:191)
               at org.python.core.PyFunction.__call__(PyFunction.java:385)
               at org.python.core.PyFunction.__call__(PyFunction.java:380)
               at org.python.core.PyInstance.__init__(PyInstance.java:120)
               at org.python.core.PyClass.__call__(PyClass.java:194)
               at org.python.core.PyObject.__call__(PyObject.java:367)
               at org.python.core.PyObject.__call__(PyObject.java:371)
               at org.python.pycode._pyx2.f$0(<string>:21)
               at org.python.pycode._pyx2.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


          Thanks in advance
          • 2. Re: integrating HFM with ODI
            SH_INT
            You wil need to do one of the following:

            1) Install and configure the HFM client on the ODI server
            or
            2) Install an ODI agent on a server which has the HFM client installed and configured and reference that agent when performing executing your HFM Knowledge modules
            • 3. Re: integrating HFM with ODI
              954315
              Hi SH,


              If i go for second option, Could you tell me what is the procedure to installing odi agent which has hfm client installed .


              Can u guide me to follow the procedure ?
              or can u share any link.

              Please Help

              Thanks in advance
              • 4. Re: integrating HFM with ODI
                954315
                hi all,

                any body have solution to this scenario ?