0 Replies Latest reply on Nov 18, 2015 7:02 PM by 3041086

    FDMEE Export Log error/

    3041086

      I think a similar question has been posted before but even after following the troubleshoot advice I am still getting the error.

       

      I am currently unable to export data to the HFM app in TEST env (the same file exports in the DEV environment to the HFM app)

       

      This is the error log I am getting:
      2015-11-18 12:44:56,185 INFO  [AIF]: -------START EXPORT STEP-------
      2015-11-18 12:44:56,263 DEBUG [AIF]: CommData.exportData - START
      2015-11-18 12:44:56,263 DEBUG [AIF]: Comm.doScriptInit - START
      2015-11-18 12:44:56,466 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=E:\Oracle\Middleware\user_projects\epmsystem_tsthfmapp01\FinancialDataQuality, INBOXDIR=\\tsthfmapp01\E$\FDMEE\inbox, LOCNAME=APR_TST_Load, SOURCENAME=APR13_Tst_Load, APPID=14, SOURCEID=2, APPROOTDIR=\\tsthfmapp01\E$\FDMEE, IMPORTFORMAT=APR13_Tst_LOAD, SCRIPTSDIR=\\tsthfmapp01\E$\FDMEE\data\scripts, EPMORACLEHOME=E:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=5, CATNAME=Actuals, EPMORACLEINSTANCEHOME=E:\Oracle\Middleware\user_projects\epmsystem_tsthfmapp01, LOADID=91, PERIODNAME=Apr, IMPORTMODE=null, SOURCETYPE=FILE, PERIODKEY=2013-04-01, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=HRBCONSFY, FILENAME=null, LOCKEY=2, RULENAME=Data_Load_TSTrule, OUTBOXDIR=\\tsthfmapp01\E$\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Replace, CATKEY=2, USERNAME=X147235, FILEDIR=null, IMPORTFLAG=N, USERLOCALE=null}
      2015-11-18 12:44:56,466 DEBUG [AIF]: The executeEventScript is set to: YES
      2015-11-18 12:44:56,466 DEBUG [AIF]: The AppRootFolder is set to: \\tsthfmapp01\E$\FDMEE
      2015-11-18 12:44:56,466 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
      2015-11-18 12:44:56,466 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE
      2015-11-18 12:44:56,466 DEBUG [AIF]: Comm.doScriptInit - END
      2015-11-18 12:44:56,466 DEBUG [AIF]: Comm.executeScript - START
      2015-11-18 12:44:56,466 DEBUG [AIF]: The following script does not exist: \\tsthfmapp01\E$\FDMEE/data/scripts/event/BefExportToDat.py
      2015-11-18 12:44:56,466 DEBUG [AIF]: Comm.executeVBScript - START
      2015-11-18 12:44:56,466 DEBUG [AIF]: The WindowsTempFolder is set to: c:\users\svc_hy~1\appdata\local\temp
      2015-11-18 12:44:56,466 DEBUG [AIF]: The following script does not exist: \\tsthfmapp01\E$\FDMEE\data\scripts\event\BefExportToDat.vbs
      2015-11-18 12:44:56,466 DEBUG [AIF]: Comm.executeVBScript - END
      2015-11-18 12:44:56,466 DEBUG [AIF]: Comm.executeScript - END
      2015-11-18 12:44:56,481 DEBUG [AIF]: CommData.getRuleInfo - START
      2015-11-18 12:44:56,481 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 = 'FILE' THEN 'N'
                 WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' 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 WHEN 'PLAN6' THEN 6 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 ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'
                 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, imp.IMPSOURCELEDGERID
              ,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID
              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 = 91
             
      2015-11-18 12:44:56,481 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 DISTINCT 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 = 11
            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 = 2
            AND adim.BALANCE_COLUMN_NAME IS NOT NULL
            AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
           
            ORDER BY adim.BALANCE_COLUMN_NAME
           
      2015-11-18 12:44:56,481 DEBUG [AIF]: {'APPLICATION_ID': 11L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'Data_Load_TSTrule', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'E:\\Oracle\\Middleware\\user_projects\\epmsystem_tsthfmapp01', 'CATKEY': 2L, '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'AMTESTAPP', 'RECALCULATE_FLAG': u'N', 'SOURCE_SYSTEM_ID': 2L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'APR13_Tst_LOAD', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'X147235', 'DIMNAME_MAP': {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': 29L}, 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': 36L}, 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': 40L}, 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': 39L}, 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': 34L}, 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': 37L}, 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': 38L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 2L, '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', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 5L, '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://TSTHFMAPP01.hrbinc.hrblock.net:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 14L, 'IMPTARGETSOURCESYSTEMID': 0L}
      2015-11-18 12:44:56,481 DEBUG [AIF]: CommData.getRuleInfo - END
      2015-11-18 12:44:56,497 DEBUG [AIF]: CommData.insertFilePeriods - START
      2015-11-18 12:44:56,497 DEBUG [AIF]: doAppPeriodMappingsExist - AMTESTAPP: N
      2015-11-18 12:44:56,497 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 TPOVPERIOD_FLAT_V pp
                  ON pp.PERIODFREQ = pc.CATFREQ
                 
                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 = 91   
                  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 TPOVPERIOD_FLAT_V pp
                  ON pp.PERIODFREQ = pc.CATFREQ
                 
                  AND pp.PERIODKEY >= brl.START_PERIODKEY
                  AND pp.PERIODKEY <= brl.END_PERIODKEY        
                WHERE brl.LOADID = 91   
                  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 TPOVPERIOD_FLAT_V pp2
                  ON pp2.PERIODFREQ = pc2.CATFREQ
                  
                            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 TPOVPERIOD_FLAT_V pp
                  ON pp.PERIODFREQ = pc.CATFREQ
                 
                  AND pp.PERIODKEY >= brl.START_PERIODKEY
                  AND pp.PERIODKEY <= brl.END_PERIODKEY
                WHERE brl.LOADID = 91             
                  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
               
      2015-11-18 12:44:56,497 INFO  [AIF]: File Name: dummy.txt
      2015-11-18 12:44:56,497 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 (91,'2013-04-01','N',0,'0' ,'0',0,1,'2013','Apr', 'PROCESS_BAL_IMP_FILE','dummy.txt','PROCESS_BAL_TRANS','Apr','N' )
             
      2015-11-18 12:44:56,513 DEBUG [AIF]: CommData.insertFilePeriods - END
      2015-11-18 12:44:56,513 DEBUG [AIF]: CommData.moveData - START
      2015-11-18 12:44:56,513 DEBUG [AIF]: CommData.getPovList - START
      2015-11-18 12:44:56,513 DEBUG [AIF]:
              SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
              ,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC
              ,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG
              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 TPOVPERIOD pp
                  ON pp.PERIODKEY = pprd.PERIODKEY
              LEFT OUTER JOIN TLOGPROCESS tlp
                ON tlp.PARTITIONKEY = brl.PARTITIONKEY
                AND tlp.CATKEY = brl.CATKEY
                AND tlp.PERIODKEY = pprd.PERIODKEY
                AND tlp.RULE_ID = brl.RULE_ID
              WHERE brl.LOADID = 91
              ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
           
      2015-11-18 12:44:56,513 DEBUG [AIF]: CommData.getPovList - END
      2015-11-18 12:44:56,513 INFO  [AIF]:
      Move Data for Period 'Apr'
      2015-11-18 12:44:56,513 DEBUG [AIF]:
                UPDATE TDATASEG
                SET LOADID = 91
                WHERE PARTITIONKEY = 2
                AND CATKEY = 2
                AND RULE_ID = 5
                AND LOADID < 91
               
                  AND PERIODKEY = '2013-04-01'
      2015-11-18 12:44:56,528 DEBUG [AIF]: Number of Rows updated on TDATASEG: 28
      2015-11-18 12:44:56,528 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
                91, 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 = 2 AND CATKEY = 2 AND RULE_ID = 5 AND LOADID < 91
             
                  AND PERIODKEY = '2013-04-01'
      2015-11-18 12:44:56,528 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_AUDIT: 1
      2015-11-18 12:44:56,528 DEBUG [AIF]: CommData.moveData - END
      2015-11-18 12:44:56,544 DEBUG [AIF]: CommData.updateWorkflow - START
      2015-11-18 12:44:56,544 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 = 2
          AND tlp.CATKEY = 2
          AND tlp.PERIODKEY = '2013-04-01'
          AND tlp.RULE_ID = 5
          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
         
      2015-11-18 12:44:56,544 DEBUG [AIF]:
              UPDATE TLOGPROCESS
              SET PROCESSENDTIME = CURRENT_TIMESTAMP
              ,PROCESSSTATUS = 20
                ,PROCESSEXP = 0
                ,PROCESSENTLOAD = 0
                ,PROCESSENTVAL = 0
                ,PROCESSEXPNOTE = NULL
                ,PROCESSENTLOADNOTE = NULL
                ,PROCESSENTVALNOTE = NULL
              WHERE PARTITIONKEY = 2 AND CATKEY = 2 AND PERIODKEY = '2013-04-01' AND RULE_ID = 5
             
      2015-11-18 12:44:56,544 DEBUG [AIF]: CommData.updateWorkflow - END
      2015-11-18 12:44:56,544 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START
      2015-11-18 12:44:56,559 DEBUG [AIF]:
              DELETE FROM TDATASEG
              WHERE LOADID = 91
             
                AND (
                 
              PARTITIONKEY = 2
              AND CATKEY = 2
              AND PERIODKEY = '2013-04-01'
              AND RULE_ID = 5
              AND VALID_FLAG = 'N'
             
                )
      2015-11-18 12:44:56,559 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0
      2015-11-18 12:44:56,559 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END
      2015-11-18 12:44:56,559 DEBUG [AIF]: CommData.updateAppLoadAudit - START
      2015-11-18 12:44:56,559 DEBUG [AIF]:
              UPDATE AIF_APPL_LOAD_AUDIT
              SET EXPORT_TO_TARGET_FLAG = 'Y'
              WHERE LOADID = 91
              AND PARTITIONKEY = 2
              AND CATKEY = 2
              AND PERIODKEY= '2013-04-01'
              AND RULE_ID = 5
             
      2015-11-18 12:44:56,575 DEBUG [AIF]: Number of Rows updated on AIF_APPL_LOAD_AUDIT: 1
      2015-11-18 12:44:56,575 DEBUG [AIF]: CommData.updateAppLoadAudit - END
      2015-11-18 12:44:56,575 DEBUG [AIF]: CommData.updateWorkflow - START
      2015-11-18 12:44:56,575 DEBUG [AIF]:
              UPDATE TLOGPROCESS
              SET PROCESSENDTIME = CURRENT_TIMESTAMP
              ,PROCESSSTATUS = 21
                ,PROCESSEXP = 1
                ,PROCESSEXPNOTE = 'Export Successful'
              WHERE PARTITIONKEY = 2 AND CATKEY = 2 AND PERIODKEY = '2013-04-01' AND RULE_ID = 5
             
      2015-11-18 12:44:56,591 DEBUG [AIF]: CommData.updateWorkflow - END
      2015-11-18 12:44:56,591 DEBUG [AIF]: Comm.executeVBScript - START
      2015-11-18 12:44:56,591 DEBUG [AIF]: Comm.getGlobalUserForAppAccess - START
      2015-11-18 12:44:56,591 DEBUG [AIF]:
          SELECT property_value
          FROM   aif_target_appl_properties
          WHERE  application_id = '11' and property_type = 'GLOBAL_USER_FOR_APP_ACCESS'
         
      2015-11-18 12:44:56,591 DEBUG [AIF]: GlobalUserForAppAccess from Profile:
      2015-11-18 12:44:56,606 DEBUG [AIF]: Resolved user name for application access: X147235
      2015-11-18 12:44:56,606 DEBUG [AIF]: Comm.getGlobalUserForAppAccess - END
      2015-11-18 12:44:56,606 INFO  [AIF]: Executing the following script: E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_EXPORT.vbs
      2015-11-18 12:44:56,606 DEBUG [AIF]: The command to be executed is:
      cscript E:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\bin\HFM_EXPORT.vbs "91" "****" "E%3A%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem_tsthfmapp01" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"
      Microsoft (R) Windows Script Host Version 5.8
      Copyright (C) Microsoft Corporation. All rights reserved.

      2015-11-18 12:44:56,669 ERROR [AIF]: The script has failed to execute:
      2015-11-18 12:44:56,669 FATAL [AIF]: Error in CommData.exportData
      Traceback (most recent call last):
        File "<string>", line 5110, in exportData
        File "<string>", line 601, in executeVBScript
      RuntimeError: -1

      2015-11-18 12:44:56,669 DEBUG [AIF]: CommData.updateWorkflow - START
      2015-11-18 12:44:56,669 DEBUG [AIF]:
              UPDATE TLOGPROCESS
              SET PROCESSENDTIME = CURRENT_TIMESTAMP
              ,PROCESSSTATUS = 22
                ,PROCESSEXP = 0
                ,PROCESSEXPNOTE = 'Export Error'
              WHERE PARTITIONKEY = 2 AND CATKEY = 2 AND PERIODKEY = '2013-04-01' AND RULE_ID = 5
             
      2015-11-18 12:44:56,669 DEBUG [AIF]: CommData.updateWorkflow - END
      2015-11-18 12:44:56,669 DEBUG [AIF]: Comm.executeScript - START
      2015-11-18 12:44:56,669 DEBUG [AIF]: The following script does not exist: \\tsthfmapp01\E$\FDMEE/data/scripts/event/AftExportToDat.py
      2015-11-18 12:44:56,669 DEBUG [AIF]: Comm.executeVBScript - START
      2015-11-18 12:44:56,669 DEBUG [AIF]: The following script does not exist: \\tsthfmapp01\E$\FDMEE\data\scripts\event\AftExportToDat.vbs
      2015-11-18 12:44:56,669 DEBUG [AIF]: Comm.executeVBScript - END
      2015-11-18 12:44:56,669 DEBUG [AIF]: Comm.executeScript - END
      2015-11-18 12:44:56,762 DEBUG [AIF]: Comm.finalizeProcess - START
      2015-11-18 12:44:56,762 DEBUG [AIF]: CommData.updateRuleStatus - START
      2015-11-18 12:44:56,762 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 = 91
                AND pd.STATUS IN ('FAILED','WARNING')
              )
              WHEN 0 THEN 'SUCCESS'
              ELSE (
                SELECT MIN(pd.STATUS)
                FROM AIF_PROCESS_DETAILS pd
                WHERE pd.PROCESS_ID = 91
                AND pd.STATUS IN ('FAILED','WARNING')
              )
              END
            ELSE 'FAILED'
          END
          WHERE RULE_ID = 5
         
      2015-11-18 12:44:56,778 DEBUG [AIF]: CommData.updateRuleStatus - END
      2015-11-18 12:44:56,778 FATAL [AIF]: Error in COMM Export Data
      2015-11-18 12:44:56,778 DEBUG [AIF]: Comm.updateProcess - START
      2015-11-18 12:44:56,778 DEBUG [AIF]: Comm.updateProcess - END
      2015-11-18 12:44:56,793 DEBUG [AIF]: The fdmAPI connection has been closed.
      2015-11-18 12:44:56,793 INFO  [AIF]: FDMEE Process End, Process ID: 91