2 Replies Latest reply on Jan 15, 2015 2:17 AM by 838610

    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