7 Replies Latest reply on Sep 25, 2014 7:56 AM by Francisco Amores Branched from an earlier discussion.

    Re: FDMEE - HFM Communication issue

    2651585

      Hi all,

       

      I have pretty the same error logs when exporting data to HFM :

      2014-09-04 16:16:50,991 ERROR [AIF]: The script has failed to execute:

      2014-09-04 16:16:51,010 FATAL [AIF]: Error in CommData.exportData

      Traceback (most recent call last):

        File "<string>", line 4423, in exportData

        File "<string>", line 558, in executeVBScript

      RuntimeError: -1

       

      I think it's a communication issue with HFM but I have been able to browse for target values while mapping ...

      I applied psu510 as told in an other subject but it changes nothing.

      Please can you advise me what could be my problem ?

       

      PS: Could you tell me where to find those server logs ?

      PPS: Can't access to the document you posted the link in your message, perhaps Id changed ?

       

      Best regards,

      Marc

        • 1. Re: FDMEE - HFM Communication issue
          Francisco Amores

          If there are connection issues between FDMEE and HFM both Validate (if you enable Check Intersection) and Export will fail.

           

          - Windows Event Log can be found the FDMEE Server (Programs > Event Viewer)

          - The Server logs (Doc ID 1640612.1)

          - Try to open the DOC in support by searching the ID

           

          Please can you paste your full FDMEE process log when doing export?

           

          Thanks

          • 2. Re: FDMEE - HFM Communication issue
            2651585

            Hello Francisco,

            First thank you for your interest.

            About the doc I couldn't acces, it appears I hadn't a specific acces, which I requested.

            As you told error appears both with Validate (if you enable Check Intersection) and Export.

            Here is the complete lvl5 log from export (imort and validate showing a green flag because no intersect) :

             

            2014-09-05 14:39:51,344 INFO  [AIF]: FDMEE Process Start, Process ID: 121

            2014-09-05 14:39:51,344 INFO  [AIF]: FDMEE Logging Level: 5

            2014-09-05 14:39:51,344 INFO  [AIF]: FDMEE Log File: D:\EPM\FDMEE\outbox\logs\CommaNoRul_121.log

            2014-09-05 14:39:51,344 INFO  [AIF]: User:admin

            2014-09-05 14:39:51,344 INFO  [AIF]: Location:LocNORUL (Partitionkey:10)

            2014-09-05 14:39:51,345 INFO  [AIF]: Period Name:Dec 2008 (Period Key:01/12/08 00:00)

            2014-09-05 14:39:51,345 INFO  [AIF]: Category Name:Budget1 (Category key:5)

            2014-09-05 14:39:51,345 INFO  [AIF]: Rule Name:LoadNORUL (Rule ID:11)

            2014-09-05 14:39:53,391 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

            [Oracle JRockit(R) (Oracle Corporation)]

            2014-09-05 14:39:53,391 INFO  [AIF]: Java Platform: java1.6.0_37

            2014-09-05 14:39:53,391 INFO  [AIF]: Log File Encoding: UTF-8

            2014-09-05 14:40:01,150 INFO  [AIF]: -------START IMPORT STEP-------

            2014-09-05 14:40:01,273 INFO  [AIF]: -------END IMPORT STEP-------

            2014-09-05 14:40:01,393 INFO  [AIF]: -------START EXPORT STEP-------

            2014-09-05 14:40:01,451 DEBUG [AIF]: CommData.exportData - START

            2014-09-05 14:40:01,460 DEBUG [AIF]: Comm.doScriptInit - START

            2014-09-05 14:40:01,771 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\EPM\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=D:\EPM\FDMEE\inbox, LOCNAME=LocNORUL, SOURCENAME=TextFile, APPID=8, IMPORTFORMAT=NORULform, SCRIPTSDIR=D:\EPM\FDMEE\data\scripts, EPMORACLEHOME=D:\EPM\Middleware\EPMSystem11R1, RULEID=11, CATNAME=Budget1, EPMORACLEINSTANCEHOME=D:\EPM\Middleware\user_projects\epmsystem1, LOADID=121, PERIODNAME=Dec 2008, IMPORTMODE=null, SOURCETYPE=FILE, PERIODKEY=2008-12-01, TARGETAPPDB=NA, EXPORTFLAG=Y, TARGETAPPNAME=CommaNoRul, FILENAME=null, LOCKEY=10, RULENAME=LoadNORUL, OUTBOXDIR=D:\EPM\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=5, FILEDIR=inbox, IMPORTFLAG=N}

            2014-09-05 14:40:01,771 DEBUG [AIF]: The EpmOracleHome is set to: D:\EPM\Middleware\EPMSystem11R1

            2014-09-05 14:40:01,771 DEBUG [AIF]: The EpmOracleInstance is set to: D:\EPM\Middleware\user_projects\epmsystem1

            2014-09-05 14:40:01,771 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

            2014-09-05 14:40:01,771 DEBUG [AIF]: The executeEventScript is set to: YES

            2014-09-05 14:40:01,771 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

            2014-09-05 14:40:01,771 DEBUG [AIF]: The AppRootFolder is set to: D:\EPM\FDMEE

            2014-09-05 14:40:01,771 DEBUG [AIF]: Comm.doScriptInit - END

            2014-09-05 14:40:01,771 DEBUG [AIF]: Comm.executeScript - START

            2014-09-05 14:40:01,777 DEBUG [AIF]: The following script does not exist: D:\EPM\FDMEE/data/scripts/event/BefExportToDat.py

            2014-09-05 14:40:01,780 DEBUG [AIF]: Comm.executeVBScript - START

            2014-09-05 14:40:01,780 DEBUG [AIF]: The WindowsTempFolder is set to: c:\temp

            2014-09-05 14:40:01,782 DEBUG [AIF]: The following script does not exist: D:\EPM\FDMEE\data\scripts\event\BefExportToDat.vbs

            2014-09-05 14:40:01,782 DEBUG [AIF]: Comm.executeVBScript - END

            2014-09-05 14:40:01,782 DEBUG [AIF]: Comm.executeScript - END

            2014-09-05 14:40:01,789 DEBUG [AIF]: CommData.getRuleInfo - START

            2014-09-05 14:40:01,791 DEBUG [AIF]:

                    SELECT brl.RULE_ID

                    ,br.RULE_NAME

                    ,brl.PARTITIONKEY

                    ,brl.CATKEY

                    ,part.PARTVALGROUP

                    ,br.SOURCE_SYSTEM_ID

                    ,ss.SOURCE_SYSTEM_TYPE

                    ,CASE

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'

                      WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FILE%' THEN 'N'

                      ELSE 'Y'

                    END SOURCE_ADAPTER_FLAG

                    ,app.APPLICATION_ID

                    ,app.TARGET_APPLICATION_NAME

                    ,app.TARGET_APPLICATION_TYPE

                    ,app.DATA_LOAD_METHOD

                    ,brl.PLAN_TYPE

                    ,CASE brl.PLAN_TYPE

                      WHEN 'PLAN1' THEN 1

                      WHEN 'PLAN2' THEN 2

                      WHEN 'PLAN3' THEN 3

                      WHEN 'PLAN4' THEN 4

                      WHEN 'PLAN5' THEN 5

                      ELSE 0

                    END PLAN_NUMBER

                    ,br.INCL_ZERO_BALANCE_FLAG

                    ,br.PERIOD_MAPPING_TYPE

                    ,br.INCLUDE_ADJ_PERIODS_FLAG

                    ,br.BALANCE_TYPE ACTUAL_FLAG

                    ,br.AMOUNT_TYPE

                    ,br.BALANCE_SELECTION

                    ,br.BALANCE_METHOD_CODE

                    ,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD

                    ,br.CURRENCY_CODE

                    ,br.BAL_SEG_VALUE_OPTION_CODE

                    ,brl.EXECUTION_MODE

                    ,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG

                    ,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG

                    ,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG

                    ,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG

                    ,CASE

                      WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'

                      WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'

                      ELSE 'NONE'

                    END LEDGER_GROUP_CODE

                    ,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS

                    ,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS

                    ,br.LEDGER_GROUP

                    ,(SELECT brd.DETAIL_CODE

                      FROM AIF_BAL_RULE_DETAILS brd

                      WHERE brd.RULE_ID = br.RULE_ID

                      AND brd.DETAIL_TYPE = 'LEDGER'       

                    ) PS_LEDGER

                    ,CASE lg.LEDGER_TEMPLATE

                      WHEN 'COMMITMENT' THEN 'Y'

                      ELSE 'N'

                    END KK_FLAG

                    ,p.LAST_UPDATED_BY

                    ,p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL

                    ,p.EPM_ORACLE_INSTANCE

                    ,brl.JOURNAL_FLAG

                    ,br.MULTI_PERIOD_FILE_FLAG

                    ,br.IMPGROUPKEY

                    FROM AIF_PROCESSES p

                    INNER JOIN AIF_BAL_RULE_LOADS brl

                      ON brl.LOADID = p.PROCESS_ID

                    INNER JOIN AIF_BALANCE_RULES br

                      ON br.RULE_ID = brl.RULE_ID

                    INNER JOIN AIF_SOURCE_SYSTEMS ss

                      ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID

                    INNER JOIN AIF_TARGET_APPLICATIONS app

                      ON app.APPLICATION_ID = brl.APPLICATION_ID

                    INNER JOIN TPOVPARTITION part

                      ON part.PARTITIONKEY = br.PARTITIONKEY

                    INNER JOIN TBHVIMPGROUP imp

                      ON imp.IMPGROUPKEY = part.PARTIMPGROUP

                    LEFT OUTER JOIN AIF_COA_LEDGERS l

                      ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID

                      AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)

                    LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr

                      ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID

                      AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME

                      AND scr.RECNAME = 'LED_GRP_TBL'

                    LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg

                      ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID

                      AND lg.SETID = scr.SETID

                      AND lg.LEDGER_GROUP = br.LEDGER_GROUP

                    WHERE p.PROCESS_ID = 121

                   

            2014-09-05 14:40:01,799 DEBUG [AIF]:

                  SELECT adim.BALANCE_COLUMN_NAME DIMNAME

                  ,adim.DIMENSION_ID

                  ,dim.TARGET_DIMENSION_CLASS_NAME

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4

                  ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5

                  ,(SELECT CASE mdd.ORPHAN_OPTION_CODE

                      WHEN 'CHILD' THEN 'N'

                      WHEN 'ROOT' THEN 'N'

                      ELSE 'Y'

                    END DIMENSION_FILTER_FLAG

                    FROM AIF_MAP_DIM_DETAILS_V mdd

                    ,AIF_MAPPING_RULES mr

                    WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY

                    AND mdd.RULE_ID = mr.RULE_ID

                    AND mdd.DIMENSION_ID = adim.DIMENSION_ID

                  ) DIMENSION_FILTER_FLAG

                  ,tiie.IMPCONCATCHAR

                  FROM TPOVPARTITION tpp

                  INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                    ON adim.APPLICATION_ID = 8

                  INNER JOIN AIF_DIMENSIONS dim

                    ON dim.DIMENSION_ID = adim.DIMENSION_ID

                  LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                    ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP

                    AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME

                    AND tiie.IMPMAPTYPE = 'ERP'

                  WHERE tpp.PARTITIONKEY = 10

                  AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                 

                  ORDER BY adim.BALANCE_COLUMN_NAME

                 

            2014-09-05 14:40:01,803 DEBUG [AIF]: {'APPLICATION_ID': 8L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'LoadNORUL', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\EPM\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 5L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'CommaNoRul', 'RECALCULATE_FLAG': u'N', 'SOURCE_SYSTEM_ID': 3L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'NORULform', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6', u'UD7'], 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 61L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 63L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 67L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 68L}, u'UD7': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD7', 'DIMENSION_ID': 66L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 56L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 62L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 60L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 59L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 58L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 10L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 11L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://EPM-11-123:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

            2014-09-05 14:40:01,803 DEBUG [AIF]: CommData.getRuleInfo - END

            2014-09-05 14:40:01,816 DEBUG [AIF]: CommData.insertFilePeriods - START

            2014-09-05 14:40:01,821 DEBUG [AIF]: commAppPeriodMappingExists: Y

            2014-09-05 14:40:01,822 DEBUG [AIF]:

              select PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM

              from (

                    SELECT pp.PERIODKEY

                      ,pp.PERIODDESC

                      ,pp.YEARTARGET YEARTARGET

                      ,pp.PERIODTARGET PERIODTARGET         

                      ,brl.FILE_NAME_STATIC

                      ,brl.FILE_NAME_SUFFIX_TYPE

                      ,brl.FILE_NAME_DATE_FORMAT

                      ,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM

                      FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                      INNER JOIN TPOVCATEGORY pc

                        ON pc.CATKEY = brl.CATKEY

                     

                      INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                        ON pp.PERIODFREQ = pc.CATFREQ           

                        AND pp.INTSYSTEMKEY = 'CommaNoRul'

                      INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp

                        ON brp.loadid = brl.loadid

                        AND to_date(brp.parameter_value,'yyyy/MM/dd') = pp.periodkey

                      WHERE brl.LOADID = 121   

                        AND br.rule_id = brl.rule_id

                        AND br.MULTI_PERIOD_FILE_FLAG = 'Y'

                       

                        UNION

                       

                      SELECT pp.PERIODKEY

                      ,pp.PERIODDESC

                      ,pp.YEARTARGET YEARTARGET

                      ,pp.PERIODTARGET PERIODTARGET         

                      ,brl.FILE_NAME_STATIC

                      ,brl.FILE_NAME_SUFFIX_TYPE

                      ,brl.FILE_NAME_DATE_FORMAT

                      ,0 GL_EFFECTIVE_PERIOD_NUM

                      FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                      INNER JOIN TPOVCATEGORY pc

                        ON pc.CATKEY = brl.CATKEY

                     

                      INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                        ON pp.PERIODFREQ = pc.CATFREQ           

                        AND pp.INTSYSTEMKEY = 'CommaNoRul'

                        AND pp.PERIODKEY >= brl.START_PERIODKEY

                        AND pp.PERIODKEY <= brl.END_PERIODKEY        

                      WHERE brl.LOADID = 121   

                        AND br.rule_id = brl.rule_id

                        AND br.MULTI_PERIOD_FILE_FLAG = 'Y'

                        AND 0 = (SELECT count(*)

                                  FROM AIF_BALANCE_RULES br2, AIF_BAL_RULE_LOADS brl2

                                  INNER JOIN TPOVCATEGORY pc2

                                    ON pc2.CATKEY = brl2.CATKEY

                                

                      INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp2

                        ON pp2.PERIODFREQ = pc2.CATFREQ           

                        AND pp2.INTSYSTEMKEY = 'CommaNoRul'

                                  INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp2

                                    ON brp2.loadid = brl2.loadid

                                    AND to_date(brp2.parameter_value,'yyyy/MM/dd') = pp2.periodkey

                                  WHERE brl2.LOADID = brl.LOADID   

                                    AND br2.rule_id = brl2.rule_id

                                    AND br2.MULTI_PERIOD_FILE_FLAG = 'Y'

                                  )

                                 

                       ) qrslt

                      

                      UNION

             

                       SELECT pp.PERIODKEY

                       ,pp.PERIODDESC

                      ,pp.YEARTARGET YEARTARGET

                      ,pp.PERIODTARGET PERIODTARGET

                      ,brl.FILE_NAME_STATIC

                      ,brl.FILE_NAME_SUFFIX_TYPE

                      ,brl.FILE_NAME_DATE_FORMAT

                      , 0 GL_EFFECTIVE_PERIOD_NUM

                      FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                      INNER JOIN TPOVCATEGORY pc

                        ON pc.CATKEY = brl.CATKEY

                     

                      INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp

                        ON pp.PERIODFREQ = pc.CATFREQ           

                        AND pp.INTSYSTEMKEY = 'CommaNoRul'

                        AND pp.PERIODKEY >= brl.START_PERIODKEY

                        AND pp.PERIODKEY <= brl.END_PERIODKEY

                      WHERE brl.LOADID = 121             

                        AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG <> 'Y' )

                        AND br.rule_id = brl.rule_id

                       

                      ORDER BY PERIODKEY

                     

            2014-09-05 14:40:01,827 INFO  [AIF]: File Name: dummy.txt

            2014-09-05 14:40:01,828 DEBUG [AIF]:

                    INSERT INTO AIF_PROCESS_PERIODS (

                      PROCESS_ID

                      ,PERIODKEY

                      ,ADJUSTMENT_PERIOD_FLAG

                      ,GL_PERIOD_YEAR

                      ,GL_PERIOD_CODE

                     

                      ,GL_PERIOD_NAME

                      ,GL_PERIOD_NUM

                      ,GL_EFFECTIVE_PERIOD_NUM

                      ,YEARTARGET

                      ,PERIODTARGET

                     

                      ,IMP_ENTITY_TYPE

                      ,IMP_ENTITY_NAME

                      ,TRANS_ENTITY_TYPE

                      ,TRANS_ENTITY_NAME

                      ,PRIOR_PERIOD_FLAG

                    ) VALUES (121,'2008-12-01','N',0,'0' ,'0',0,1,'2008','December', 'PROCESS_BAL_IMP_FILE','dummy.txt','PROCESS_BAL_TRANS','Dec 2008','N' )

                   

            2014-09-05 14:40:01,834 DEBUG [AIF]: CommData.insertFilePeriods - END

            2014-09-05 14:40:01,844 DEBUG [AIF]: CommData.moveData - START

            2014-09-05 14:40:01,851 DEBUG [AIF]: CommData.getPovList - START

            2014-09-05 14:40:01,851 DEBUG [AIF]:

                    SELECT PARTITIONKEY

                    ,PARTNAME

                    ,CATKEY

                    ,CATNAME

                    ,PERIODKEY

                    ,COALESCE(PERIODDESC, TO_CHAR(PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

                    ,RULE_ID

                    ,RULE_NAME

                    FROM (

                      SELECT DISTINCT brl.PARTITIONKEY

                      ,part.PARTNAME

                      ,brl.CATKEY

                      ,cat.CATNAME

                      ,pprd.PERIODKEY

                      ,pp.PERIODDESC

                      ,brl.RULE_ID

                      ,br.RULE_NAME

                      FROM AIF_BAL_RULE_LOADS brl

                      INNER JOIN AIF_BALANCE_RULES br

                        ON br.RULE_ID = brl.RULE_ID

                      INNER JOIN TPOVPARTITION part

                        ON part.PARTITIONKEY = brl.PARTITIONKEY

                      INNER JOIN TPOVCATEGORY cat

                        ON cat.CATKEY = brl.CATKEY

                      INNER JOIN AIF_PROCESS_PERIODS pprd

                        ON pprd.PROCESS_ID = brl.LOADID

                     

                      LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                        ON pp.PERIODKEY = pprd.PERIODKEY

                        AND pp.INTSYSTEMKEY = 'CommaNoRul'             

                      WHERE brl.LOADID = 121

                    ) q

                    ORDER BY PARTITIONKEY

                    ,CATKEY

                    ,PERIODKEY

                    ,RULE_ID

                   

            2014-09-05 14:40:01,855 DEBUG [AIF]: CommData.getPovList - END

            2014-09-05 14:40:01,856 INFO  [AIF]:

            Move Data for Period 'Dec 2008'

            2014-09-05 14:40:01,857 DEBUG [AIF]:

                      UPDATE TDATASEG

                      SET LOADID = 121

                      WHERE PARTITIONKEY = 10

                      AND CATKEY = 5

                      AND RULE_ID = 11

                      AND LOADID < 121

                     

                        AND PERIODKEY = '2008-12-01'

            2014-09-05 14:40:01,873 DEBUG [AIF]: Number of Rows updated on TDATASEG: 17

            2014-09-05 14:40:01,874 DEBUG [AIF]:

                    INSERT INTO AIF_APPL_LOAD_AUDIT (

                      LOADID

                      ,TARGET_APPLICATION_TYPE

                      ,TARGET_APPLICATION_NAME

                      ,PLAN_TYPE

                      ,SOURCE_LEDGER_ID

                      ,EPM_YEAR

                      ,EPM_PERIOD

                      ,SNAPSHOT_FLAG

                      ,SEGMENT_FILTER_FLAG

                      ,PARTITIONKEY

                      ,CATKEY

                      ,RULE_ID

                      ,PERIODKEY

                      ,EXPORT_TO_TARGET_FLAG

                    )

                    SELECT DISTINCT 121

                    ,TARGET_APPLICATION_TYPE

                    ,TARGET_APPLICATION_NAME

                    ,PLAN_TYPE

                    ,SOURCE_LEDGER_ID

                    ,EPM_YEAR

                    ,EPM_PERIOD

                    ,SNAPSHOT_FLAG

                    ,SEGMENT_FILTER_FLAG

                    ,PARTITIONKEY

                    ,CATKEY

                    ,RULE_ID

                    ,PERIODKEY

                    ,'Y'

                    FROM AIF_APPL_LOAD_AUDIT

                    WHERE PARTITIONKEY = 10

                    AND CATKEY = 5

                    AND RULE_ID = 11

                    AND LOADID < 121

                   

                        AND PERIODKEY = '2008-12-01'

            2014-09-05 14:40:01,896 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_AUDIT: 1

            2014-09-05 14:40:01,897 DEBUG [AIF]:

                    INSERT INTO AIF_APPL_LOAD_PRD_AUDIT (

                      LOADID

                      ,SOURCE_LEDGER_ID

                      ,GL_PERIOD_ID

                      ,GL_PERIOD_YEAR

                      ,DELTA_RUN_ID

                      ,PARTITIONKEY

                      ,CATKEY

                      ,RULE_ID

                      ,PERIODKEY

                    )

                    SELECT DISTINCT 121

                    ,SOURCE_LEDGER_ID

                    ,GL_PERIOD_ID

                    ,GL_PERIOD_YEAR

                    ,DELTA_RUN_ID

                    ,PARTITIONKEY

                    ,CATKEY

                    ,RULE_ID

                    ,PERIODKEY

                    FROM AIF_APPL_LOAD_PRD_AUDIT

                    WHERE PARTITIONKEY = 10

                    AND CATKEY = 5

                    AND RULE_ID = 11

                    AND LOADID < 121

                   

                        AND PERIODKEY = '2008-12-01'

            2014-09-05 14:40:01,919 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_PRD_AUDIT: 0

            2014-09-05 14:40:02,055 DEBUG [AIF]: CommData.moveData - END

            2014-09-05 14:40:02,067 DEBUG [AIF]: CommData.updateWorkflow - START

            2014-09-05 14:40:02,067 DEBUG [AIF]:

                SELECT tlp.PROCESSSTATUS

                ,tlps.PROCESSSTATUSDESC

                ,CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

                FROM TLOGPROCESS tlp

                ,TLOGPROCESSSTATES tlps

                WHERE tlp.PARTITIONKEY = 10

                AND tlp.CATKEY = 5

                AND tlp.PERIODKEY = '2008-12-01'

                AND tlp.RULE_ID = 11

                AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

               

            2014-09-05 14:40:02,070 DEBUG [AIF]:

                    UPDATE TLOGPROCESS

                    SET PROCESSENDTIME = CURRENT_TIMESTAMP

                   

                    ,PROCESSSTATUS = 20

                      ,PROCESSEXP = 0

                      ,PROCESSENTLOAD = 0

                      ,PROCESSENTVAL = 0

                      ,PROCESSEXPNOTE = NULL

                      ,PROCESSENTLOADNOTE = NULL

                      ,PROCESSENTVALNOTE = NULL

                    WHERE PARTITIONKEY = 10

                    AND CATKEY = 5

                    AND PERIODKEY = '2008-12-01'

                    AND RULE_ID = 11

                   

            2014-09-05 14:40:02,080 DEBUG [AIF]: CommData.updateWorkflow - END

            2014-09-05 14:40:02,083 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START

            2014-09-05 14:40:02,084 DEBUG [AIF]:

                    DELETE FROM TDATASEG

                    WHERE LOADID = 121

                   

                      AND (

                       

                    PARTITIONKEY = 10

                    AND CATKEY = 5

                    AND PERIODKEY = '2008-12-01'

                    AND RULE_ID = 11

                    AND VALID_FLAG = 'N'

                   

                      )

            2014-09-05 14:40:02,092 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0

            2014-09-05 14:40:02,093 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END

            2014-09-05 14:40:02,095 DEBUG [AIF]: CommData.updateAppLoadAudit - START

            2014-09-05 14:40:02,095 DEBUG [AIF]:

                    UPDATE AIF_APPL_LOAD_AUDIT

                    SET EXPORT_TO_TARGET_FLAG = 'Y'

                    WHERE LOADID = 121

                    AND PARTITIONKEY = 10

                    AND CATKEY = 5

                    AND PERIODKEY= '2008-12-01'

                    AND RULE_ID = 11

                   

            2014-09-05 14:40:02,105 DEBUG [AIF]: Number of Rows updated on AIF_APPL_LOAD_AUDIT: 1

            2014-09-05 14:40:02,105 DEBUG [AIF]: CommData.updateAppLoadAudit - END

            2014-09-05 14:40:02,105 DEBUG [AIF]: CommData.updateWorkflow - START

            2014-09-05 14:40:02,106 DEBUG [AIF]:

                    UPDATE TLOGPROCESS

                    SET PROCESSENDTIME = CURRENT_TIMESTAMP

                   

                    ,PROCESSSTATUS = 21

                      ,PROCESSEXP = 1

                      ,PROCESSEXPNOTE = 'Export Successful'

                    WHERE PARTITIONKEY = 10

                    AND CATKEY = 5

                    AND PERIODKEY = '2008-12-01'

                    AND RULE_ID = 11

                   

            2014-09-05 14:40:02,111 DEBUG [AIF]: CommData.updateWorkflow - END

            2014-09-05 14:40:02,111 DEBUG [AIF]: Comm.executeVBScript - START

            2014-09-05 14:40:02,133 INFO  [AIF]: Executing the following script: D:\EPM\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_EXPORT.vbs

            2014-09-05 14:40:02,142 DEBUG [AIF]: The command to be executed is:

            cscript D:\EPM\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_EXPORT.vbs "121" "****" "D%3A%5CEPM%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

            2014-09-05 14:40:08,585 ERROR [AIF]: The script has failed to execute:

            2014-09-05 14:40:08,602 FATAL [AIF]: Error in CommData.exportData

            Traceback (most recent call last):

              File "<string>", line 4423, in exportData

              File "<string>", line 558, in executeVBScript

            RuntimeError: -1

             

            2014-09-05 14:40:08,602 DEBUG [AIF]: CommData.updateWorkflow - START

            2014-09-05 14:40:08,602 DEBUG [AIF]:

                    UPDATE TLOGPROCESS

                    SET PROCESSENDTIME = CURRENT_TIMESTAMP

                   

                    ,PROCESSSTATUS = 22

                      ,PROCESSEXP = 0

                      ,PROCESSEXPNOTE = 'Export Error'

                    WHERE PARTITIONKEY = 10

                    AND CATKEY = 5

                    AND PERIODKEY = '2008-12-01'

                    AND RULE_ID = 11

                   

            2014-09-05 14:40:08,607 DEBUG [AIF]: CommData.updateWorkflow - END

            2014-09-05 14:40:08,607 DEBUG [AIF]: Comm.executeScript - START

            2014-09-05 14:40:08,607 DEBUG [AIF]: The following script does not exist: D:\EPM\FDMEE/data/scripts/event/AftExportToDat.py

            2014-09-05 14:40:08,607 DEBUG [AIF]: Comm.executeVBScript - START

            2014-09-05 14:40:08,608 DEBUG [AIF]: The following script does not exist: D:\EPM\FDMEE\data\scripts\event\AftExportToDat.vbs

            2014-09-05 14:40:08,608 DEBUG [AIF]: Comm.executeVBScript - END

            2014-09-05 14:40:08,608 DEBUG [AIF]: Comm.executeScript - END

            2014-09-05 14:40:09,110 DEBUG [AIF]: Comm.finalizeProcess - START

            2014-09-05 14:40:09,112 DEBUG [AIF]: CommData.updateRuleStatus - START

            2014-09-05 14:40:09,112 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 = 121

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

                    )

                    WHEN 0 THEN 'SUCCESS'

                    ELSE (

                      SELECT MIN(pd.STATUS)

                      FROM AIF_PROCESS_DETAILS pd

                      WHERE pd.PROCESS_ID = 121

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

                    )

                    END

                  ELSE 'FAILED'

                END

                WHERE RULE_ID = 11

               

            2014-09-05 14:40:09,116 DEBUG [AIF]: CommData.updateRuleStatus - END

            2014-09-05 14:40:09,117 FATAL [AIF]: Error in COMM Export Data

            2014-09-05 14:40:09,118 DEBUG [AIF]: Comm.updateProcess - START

            2014-09-05 14:40:09,125 DEBUG [AIF]: Comm.updateProcess - END

             

            I hope you can find something helpful in it.

            From server log, only one i see is a warning. Don't know if relevant but still copying for you.

             

            <?xml version="1.0"?>

            <EStr><Ref>{888E9F91-E926-4D76-B09E-7166F681A7FD}</Ref><AppName/><User/><DBUpdate>1</DBUpdate><ESec><Num>21196</Num><Type>1</Type><DTime>09/05/14</DTime><Svr>ORA-11G-R2</Svr><File>ODLLogger.cpp</File><Line>18</Line><Ver>11.1.2.500.4435</Ver><PSec><Param>ODLLogger : Failed to to find logging.xml file.  Using default settings.</Param></PSec></ESec></EStr>

             

            Thank you for your help,

             

            Marc

            • 3. Re: FDMEE - HFM Communication issue
              Francisco Amores

              Hi,

               

              It seems to be related to script execution.

               

              Have you tried executing this command from command line in FDMEE app server(s)?

               

              cscript //H:cscript

               

              Then try it again.

               

              Cheers

              • 4. Re: FDMEE - HFM Communication issue
                2651585

                Hi Francisco,

                 

                Sorry for my late answer but I have been unable to connect to the internet during the last week.

                Then,I tried your command line, wich results in : "The default script host is now set to "cscript.exe"."

                I then tried process again and same result than before ....

                I had my acces to support documents and then I red the note you posted, checked the regedit and all was already as specified in the doc.

                Have you any other idea from where the problem can come from ?

                 

                Thank you again,

                 

                Marc

                • 5. Re: FDMEE - HFM Communication issue
                  Francisco Amores

                  I would suggest unregistering and registering ther adapter again from command line:

                   

                  unregister.png

                  register.png

                   

                  I hope that helps

                  • 6. Re: FDMEE - HFM Communication issue
                    2651585

                    Hi Francisco,

                    I've been looking for the UnregisterHFM script, but it isn't in the default repository but in something like :

                    ..\Middleware\EPMSystemR11\OPatch\18044402\files\products\FinancialDataQuality\lib\Windows

                    Here is erpiHFMAdapter.dll and fdmapi.dll too.

                     

                    Then do i need to register again  to ..\Middleware\user_projects\epmsystem1 as you told or anywhere else ?

                    Thank you for your time,

                     

                    Marc

                    • 7. Re: FDMEE - HFM Communication issue
                      Francisco Amores

                      It would be the same procedure I show but from a different location.

                      Same syntax: Unregister and then register it again.

                      Thanks