1 Reply Latest reply on Oct 20, 2014 9:35 AM by SH_INT

    FDMEE to HFM EXPORT Error

    2756559


      Hello Team,

       

      I am doing doing FDMEE setup for Oracle EBS -> FDMEE-> HFM, I am able to import and validate the data, but while Exporting the data I am getting below Error.

      Please let me know possible reason of the issue.

       

      ODI Session Log:

      ODI-1217: Session COMM_LOAD_BALANCES (65501) fails with return code 7000. ODI-1226: Step FAILED - Load Data fails after 1 attempt(s). ODI-1232: Procedure COMM Finalize Process execution fails. Caused By: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last): File "<string>", line 13, in <module> File "<string>", line 159, in finalizeProcess RuntimeError: ODI-1226: Step HFM Load Data fails after 1 attempt(s). ODI-1232: Procedure HFM Load Data execution fails. Caused By: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last): File "<string>", line 8, in <module> File "<string>", line 86, in loadData RuntimeError: HFM Load call failed with return code: -1

       

      ErpIntegrator0 Log:

       

        status:Session Failed :65501 : ODI-1217: Session COMM_LOAD_BALANCES (65501) fails with return code 7000.[[

       

      ODI-1226: Step FAILED - Load Data fails after 1 attempt(s).

       

      ODI-1232: Procedure COMM Finalize Process execution fails.

       

      Caused By: org.apache.bsf.BSFException: exception from Jython:

       

      Traceback (most recent call last):

       

      File "<string>", line 13, in <module>

       

      File "<string>", line 159, in finalizeProcess

       

      RuntimeError: ODI-1226: Step HFM Load Data fails after 1 attempt(s).

       

      ODI-1232: Procedure HFM Load Data execution fails.

       

      Caused By: org.apache.bsf.BSFException: exception from Jython:

       

      Traceback (most recent call last):

       

      File "<string>", line 8, in <module>

       

      File "<string>", line 86, in loadData

       

      RuntimeError: HFM Load call failed with return code: -1

       

      FDMEE Outbox\Log Log:

       

        Adapter created.

       

      You must supply 5 runtime variables.

       

      Usage: HFM_LOAD.vbs LoadID CSS_Token OracleInstancePath JavaHomePath OLE_DB_PROVIDER@

       

      2014-10-19 12:20:40,569 FATAL [AIF]: Error in HfmData.loadData

       

      Traceback (most recent call last):

       

      File "<string>", line 86, in loadData

       

      RuntimeError: HFM Load call failed with return code: -1

       

      Thanks in advance.

      Shiv