3 Replies Latest reply on Apr 28, 2011 5:17 PM by RMarques

    ERPi x ODI x FDM

      Good morning!

      I'd like to ask you something about ERPi x ODI x FDM.

      I have set up every thing on my ODI server.
      Everything was working.
      I had to recreate HFM server (other machine), so at FDM machine, went to the client, pointed to the new HFM server, went to ODI Topology Manager, pointet Physical adapter to the reight place.
      At ERPi in Source System, put EBS configurations and did that Initialize task.
      Went to ODI Operator to check. Great. System responding.
      1st, and I check at Process Manager, the process seems to be still running.
      2nd, at Metadata menu option, when I click, got that 505 error. Found something about that at Oracle KB, but didnt work.

      Could you please gimme any light? =)


      Rafael Marques
        • 1. Re: ERPi x ODI x FDM
          As I still have the old database for ERPI, I tried to register using this old database.
          Now I can access all the menu options without error =)
          When I try to make the Initialize task, 1st, at process manager appear like if its running forever, 2nd, at ODI Operator the task fails with this:

          org.apache.bsf.BSFException: exception from Jython:
          Traceback (innermost last):

          File "<string>", line 1, in ?


          at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
          at com.sunopsis.dwg.codeinterpretor.j.a(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
          at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
          at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(Unknown Source)
          at com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
          at com.sunopsis.dwg.cmd.DwgCmd.k(Unknown Source)
          at com.sunopsis.dwg.cmd.g.z(Unknown Source)
          at com.sunopsis.dwg.cmd.DwgCmd.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
          • 2. Re: ERPi x ODI x FDM
            What step is it failing at within the Operator? The error is not helpful without knowing the context in which the error was received.
            • 3. Re: ERPi x ODI x FDM
              Noticed that =)

              This is waht I have now. I drop all object form ERPI database and configured again.

              Server a (old) -> HFM, Workspace / EPRi / Calc Manager / FR
              Server 1 -> HFM, Workspace / EPRi / Calc Manager / FR
              Server 2 -> FDM / ODI

              I had Server 2 working with Server a (old). Had to make Server a again with another name (Server 1).
              Changed everything on Server 2 to point to the Server 1.
              Configured Database for ERPi on Server 1. Green flag.
              Started EPR Integrator Service.
              Went to ERPI on Server 1, configured Source System pointing to EBS, Save and hit Initialize.
              At Server 2 I can see test runing at ODI Operator, green flag.
              At Server 1, went o Process Manager (Under ERPi menus) and the process seems to be still running. It seems ODI is not giving some information back.