Error during Export process to Hyperion Planning:

838610

    Hello All,

     

    I am trying to load data to Hyperion Planning from EBS GL. I have completed the setup including setting up source, target, mappings, rules, etc. The import and validate process from EBS is working fine but export to Hyperion Planning fails right away. In my limited experience with FDMEE, I have not seen this error before and your help is greatly appreciated.

     

    Here is an excerpt of error from FDMEE process details which is the same error shown in ODI. Everything before this process seems to be working. It seems like it is complaining about a host name but not sure which host name should I be looking at.

     

    Environment: EBS12, FDMEE 11.1.2.3.520, Everything is on 64bit Linux

     

    Error:

    2015-01-14 08:53:25,578 DEBUG [AIF]: AIFUtil.callOdiServlet - START

    2015-01-14 08:53:25,690 FATAL [AIF]: Error in CommData.loadData

    Traceback (most recent call last):

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

      File "<string>", line 1122, in callOdiServlet

      File "__pyclasspath__/urllib2.py", line 124, in urlopen

      File "__pyclasspath__/urllib2.py", line 387, in open

      File "__pyclasspath__/urllib2.py", line 497, in http_response

      File "__pyclasspath__/urllib2.py", line 425, in error

      File "__pyclasspath__/urllib2.py", line 360, in _call_chain

      File "__pyclasspath__/urllib2.py", line 506, in http_error_default

    HTTPError: HTTP Error 504: Unknown Host

     

     

    2015-01-14 08:53:25,691 DEBUG [AIF]: CommData.updateWorkflow - START

    2015-01-14 08:53:25,691 DEBUG [AIF]:

            UPDATE TLOGPROCESS

            SET PROCESSENDTIME = CURRENT_TIMESTAMP

            ,PROCESSSTATUS = 32

              ,PROCESSENTLOAD = 0

              ,PROCESSENTLOADNOTE = 'Load Error'

            WHERE PARTITIONKEY = 3 AND CATKEY = 1 AND PERIODKEY = '2011-04-30' AND RULE_ID = 24

           

    2015-01-14 08:53:25,692 DEBUG [AIF]: CommData.updateWorkflow - END

    2015-01-14 08:53:25,692 DEBUG [AIF]: Comm.executeScript - START

    2015-01-14 08:53:25,692 DEBUG [AIF]: The following script does not exist: /u01/fdmee_app/ALPLAN/data/scripts/event/AftLoad.py

    2015-01-14 08:53:25,692 DEBUG [AIF]: Comm.executeVBScript - START

    2015-01-14 08:53:25,693 DEBUG [AIF]: The following script does not exist: \u01\fdmee_app\ALPLAN\data\scripts\event\AftLoad.vbs

    2015-01-14 08:53:25,693 DEBUG [AIF]: Comm.executeVBScript - END

    2015-01-14 08:53:25,693 DEBUG [AIF]: Comm.executeScript - END

    2015-01-14 08:53:25,746 DEBUG [AIF]: Comm.finalizeProcess - START

    2015-01-14 08:53:25,747 DEBUG [AIF]: CommData.updateRuleStatus - START

    2015-01-14 08:53:25,747 DEBUG [AIF]:

        UPDATE AIF_BALANCE_RULES

        SET STATUS = CASE 'FAILED'

          WHEN 'SUCCESS' THEN

            CASE (

              SELECT COUNT(*)

              FROM AIF_PROCESS_DETAILS pd

              WHERE pd.PROCESS_ID = 173

              AND pd.STATUS IN ('FAILED','WARNING')

            )

            WHEN 0 THEN 'SUCCESS'

            ELSE (

              SELECT MIN(pd.STATUS)

              FROM AIF_PROCESS_DETAILS pd

              WHERE pd.PROCESS_ID = 173

              AND pd.STATUS IN ('FAILED','WARNING')

            )

            END

          ELSE 'FAILED'

        END

        WHERE RULE_ID = 24

       

    2015-01-14 08:53:25,748 DEBUG [AIF]: CommData.updateRuleStatus - END

    2015-01-14 08:53:25,749 FATAL [AIF]: Error in COMM Load Data

    2015-01-14 08:53:25,749 DEBUG [AIF]: Comm.updateProcess - START

    2015-01-14 08:53:25,751 DEBUG [AIF]: Comm.updateProcess - END

    2015-01-14 08:53:25,752 DEBUG [AIF]: The fdmAPI connection has been closed.

    2015-01-14 08:53:25,753 INFO  [AIF]: FDMEE Process End, Process ID: 173