8 Replies Latest reply on Feb 1, 2017 4:43 PM by 3355552

    Validation error for multiperiod file

    3355552

      Hi everyone,

      I am using MULTIPERIOD flat file(.csv) to import data. The FDMEE environment is 11.1.2.4.210

       

      Anyone has seen some error like this before.

      During validation there is an error that says:

       

      2017-02-01 11:07:08,477 DEBUG [AIF]: Member:[Jan-2017, Feb-2017]

      2017-02-01 11:07:08,477 DEBUG [AIF]: Column:[9, 10]

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT9:ImpFieldText=Column=9,10;:StartPos=9:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT10:ImpFieldText=Column=9,10;:StartPos=10:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=4:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=3:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=5:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=6:SourceClName=null

      2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=7:SourceClName=null

      2017-02-01 11:07:11,291 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=8:SourceClName=null

      2017-02-01 11:07:11,291 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

      2017-02-01 11:07:11,291 INFO  [AIF]: EPMFDM-140274:Message - File Name ImportFormatTemplate12.csv

       

      although my source column is not null:

       

      Data load mapping is quite simple , everything is LIKE mapping with * to *

       

      Thanks.

        • 1. Re: Validation error for multiperiod file
          3355552

          This is the full log file, basically, when I enable the intersection check report to NO, the import pass through, but when I switch the intersection check report to YES, the import always have validation error:

           

          2017-02-01 15:23:20,976 INFO  [AIF]: FDMEE Process: 31, Log Level: 5, Log File: C:\FDMEE\outbox\logs\VCONSOL_31.log

          2017-02-01 15:23:20,976 INFO  [AIF]: Location     : ALL_VLR (Partitionkey:66)

          2017-02-01 15:23:20,977 INFO  [AIF]: Period Name  : Jan-2017 (Period Key:31.01.17 00:00)

          2017-02-01 15:23:20,977 INFO  [AIF]: Category Name: ACT (Category key:3)

          2017-02-01 15:23:20,977 INFO  [AIF]: Rule Name    : DLR_ALLVALORA (Rule ID:5)

          2017-02-01 15:23:22,514 INFO  [AIF]: FDM Version: 11.1.2.4.210

          2017-02-01 15:23:22,514 INFO  [AIF]: Log File Encoding: UTF-8

          2017-02-01 15:23:24,817 INFO  [AIF]: -------START IMPORT STEP-------

          2017-02-01 15:23:24,930 DEBUG [AIF]: CommData.preImportData - START

          2017-02-01 15:23:24,940 DEBUG [AIF]: CommData.getRuleInfo - START

          2017-02-01 15:23:24,947 DEBUG [AIF]:

                SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, adim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

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

                FROM TPOVPARTITION tpp

                INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                  ON adim.APPLICATION_ID = 3

                LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                  ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

                WHERE tpp.PARTITIONKEY = 66

                AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                ORDER BY adim.BALANCE_COLUMN_NAME

               

          2017-02-01 15:23:24,951 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVALORA', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'EXPORT_TO_TARGET_FLAG': u'N', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'IMPGROUPFILETYPE': u'MULTIPER', 'RULE_ID': 5L, 'SOURCE_ADAPTER_FLAG': u'N', 'CALENDAR_ID': None, 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}

          2017-02-01 15:23:24,955 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}

          2017-02-01 15:23:24,956 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

          2017-02-01 15:23:24,956 DEBUG [AIF]: CommData.getRuleInfo - END

          2017-02-01 15:23:24,962 DEBUG [AIF]: CommData.insertFilePeriods - START

          2017-02-01 15:23:24,965 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N

          2017-02-01 15:23:24,965 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 31 AND PARAMETER_TYPE = 'SOURCE_PERIODS'

          2017-02-01 15:23:24,967 DEBUG [AIF]: Period mapping section: MULTI-COLUMN

          2017-02-01 15:23:24,967 DEBUG [AIF]:

                      SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT

                            ,COALESCE(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM, 0 GL_PERIOD_NUM, '0' GL_PERIOD_NAME, 0 GL_PERIOD_YEAR

                      FROM 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 convert(varchar,brp.parameter_value,111) = pp.periodkey

                      WHERE brl.LOADID = 31

                        AND brp.parameter_type = 'SOURCE_PERIODS'

                      ORDER BY PERIODKEY

                   

          2017-02-01 15:23:24,976 INFO  [AIF]: File Name: ImportFormatTemplate14.csv

          2017-02-01 15:23:24,976 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, GL_PERIOD_YEAR_CHAR)

                  VALUES (31,'2017-01-31','N',0,'0' ,'0',0,9,'2017','January', 'PROCESS_BAL_IMP_FILE','ImportFormatTemplate14.csv','PROCESS_BAL_TRANS','Jan-2017','N', 0)

                 

          2017-02-01 15:23:24,982 DEBUG [AIF]: CommData.insertFilePeriods - END

          2017-02-01 15:23:24,986 DEBUG [AIF]: CommData.getPovList - START

          2017-02-01 15:23:24,986 DEBUG [AIF]:

                  SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

                        ,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) 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 = 31

                  ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

                 

          2017-02-01 15:23:24,992 DEBUG [AIF]: CommData.getPovList - END

          2017-02-01 15:23:24,994 DEBUG [AIF]: CommData.insertImportProcessDetails - START

          2017-02-01 15:23:24,995 DEBUG [AIF]:

                    INSERT INTO AIF_PROCESS_DETAILS (

                      PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, TARGET_TABLE_NAME, EXECUTION_START_TIME

                      ,EXECUTION_END_TIME, RECORDS_PROCESSED, STATUS, LAST_UPDATED_BY, LAST_UPDATE_DATE

                    )

                    SELECT PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, 'TDATASEG' TARGET_TABLE_NAME, CURRENT_TIMESTAMP EXECUTION_START_TIME

                          ,NULL EXECUTION_END_TIME, 0 RECORDS_PROCESSED, 'PENDING' STATUS, 'admin' LAST_UPDATED_BY, CURRENT_TIMESTAMP LAST_UPDATE_DATE

                    FROM (

                      SELECT DISTINCT PROCESS_ID, IMP_ENTITY_TYPE ENTITY_TYPE, IMP_ENTITY_ID ENTITY_ID, IMP_ENTITY_NAME ENTITY_NAME

                            ,(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

                      FROM AIF_PROCESS_PERIODS

                      WHERE PROCESS_ID = 31

                    ) q

                    ORDER BY ENTITY_NAME_ORDER

                   

          2017-02-01 15:23:24,997 DEBUG [AIF]: CommData.insertImportProcessDetails - END

          2017-02-01 15:23:25,002 DEBUG [AIF]: Comm.doScriptInit - START

          2017-02-01 15:23:25,076 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\FDMEE\inbox, LOCNAME=ALL_VALORA, SOURCENAME=File, APPID=3, SOURCEID=1, APPROOTDIR=C:\FDMEE, IMPORTFORMAT=IF_MULTILOAD, SCRIPTSDIR=C:\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=5, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=31, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate14.csv, LOCKEY=66, RULENAME=DLR_ALLVALORA, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=admin, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

          2017-02-01 15:23:25,088 DEBUG [AIF]: The executeEventScript is set to: YES

          2017-02-01 15:23:25,088 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE

          2017-02-01 15:23:25,088 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

          2017-02-01 15:23:25,088 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

          2017-02-01 15:23:25,088 DEBUG [AIF]: Comm.doScriptInit - END

          2017-02-01 15:23:25,088 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:25,089 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefImport.py

          2017-02-01 15:23:25,093 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:25,093 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

          2017-02-01 15:23:25,093 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefImport.vbs

          2017-02-01 15:23:25,093 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:25,093 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:25,093 DEBUG [AIF]: CommData.preImportData - END

          2017-02-01 15:23:29,517 DEBUG [AIF]: FileData.importData - START

          2017-02-01 15:23:29,517 DEBUG [AIF]: Importing data for load id: 31

          2017-02-01 15:23:29,526 DEBUG [AIF]: CommData.getRuleInfo - START

          2017-02-01 15:23:29,533 DEBUG [AIF]:

                SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, adim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

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

                FROM TPOVPARTITION tpp

                INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                  ON adim.APPLICATION_ID = 3

                LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                  ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

                WHERE tpp.PARTITIONKEY = 66

                AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                ORDER BY adim.BALANCE_COLUMN_NAME

               

          2017-02-01 15:23:29,537 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVALORA', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'EXPORT_TO_TARGET_FLAG': u'N', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'IMPGROUPFILETYPE': u'MULTIPER', 'RULE_ID': 5L, 'SOURCE_ADAPTER_FLAG': u'N', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}

          2017-02-01 15:23:29,540 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}

          2017-02-01 15:23:29,541 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

          2017-02-01 15:23:29,541 DEBUG [AIF]: CommData.getRuleInfo - END

          2017-02-01 15:23:29,543 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N

          2017-02-01 15:23:29,543 DEBUG [AIF]:  SELECT a.partitionkey,

                                            a.catkey,

                                            a.start_periodkey,

                                            b.perioddesc,

                                            coalesce(a.journal_flag,'N') JOURNAL_FLAG,

                                            c.last_updated_by,

                                            coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC,

                                            a.FILE_PATH,

                                            a.RULE_ID,

                                            a.application_id,

                                            coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG

                                          FROM aif_bal_rule_loads a,

                                          aif_balance_rules br,

                                            tpovperiod b,

                                            aif_processes c

                                          WHERE a.loadid       = 31

                                          AND a.start_periodkey=b.periodkey

                                          AND a.loadid         =c.process_id

                                          AND br.rule_id = a.rule_id

                                         

          2017-02-01 15:23:29,546 DEBUG [AIF]: FileData.py: Importing Text data for load id: 31

          2017-02-01 15:23:29,564 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::31;66:3:5:[NONE]:C:\FDMEE/:MULTIPER

          2017-02-01 15:23:29,569 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

          2017-02-01 15:23:29,569 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

          2017-02-01 15:23:29,570 DEBUG [AIF]: EPMFDM-140274:Message -  SELECT pp.PERIODKEY,

            pp.PERIODTARGET,

            pp.GL_PERIOD_NAME,

            en.FILE_ENTITY_NAME,

            en.ENTITY_NAME_ORDER,

            br.MULTI_PERIOD_FILE_FLAG,

            pp.TRANS_ENTITY_NAME,

            pp.GL_PERIOD_YEAR_CHAR,

            pp.GL_PERIOD_NUM ,

            pp.YEARTARGET

          FROM AIF_PROCESS_PERIODS pp,

            AIF_BALANCE_RULES br,

            AIF_PROCESSES p,

            (SELECT DISTINCT entity_name FILE_ENTITY_NAME,

              pd.process_id,

              pd.entity_name_order

            FROM aif_process_details pd

            WHERE pd.entity_type     = 'PROCESS_BAL_IMP_FILE'

            AND pd.target_table_name = 'TDATASEG'

            AND pd.status            = 'PENDING'

            ) en

          WHERE pp.PROCESS_ID             = ?

          AND p.process_id                = pp.process_id

          AND en.process_id               = pp.process_id

          AND pp.IMP_ENTITY_NAME          = en.file_entity_name

          AND br.rule_id                  = p.rule_id

          AND en.entity_name_order        = pp.GL_EFFECTIVE_PERIOD_NUM

          ORDER BY en.entity_name_order

          2017-02-01 15:23:29,602 DEBUG [AIF]: Script- getRuleInfo

          2017-02-01 15:23:29,602 DEBUG [AIF]: select  t.TARGET_APPLICATION_TYPE,t.TARGET_APPLICATION_SUB_TYPE

          from aif_target_applications t,

               aif_processes p,

               tpovpartition pt

          where p.partitionkey = pt.partitionkey

          AND p.process_id = ?

          AND pt.PARTSOURCEAPPLICATIONID = t.application_id

          2017-02-01 15:23:29,608 DEBUG [AIF]:                  SELECT COALESCE(p.partitionkey,0) PARTITIONKEY,  

                                                         dir.FILE_PATH,  

                                                         p.APPLICATION_ID,  

                                                         ig.IMPGROUPFILETYPE,  

                                                         COALESCE(p.LOG_FILE,  ) LOG_FILE,  

                                                         brl.FILE_NAME_STATIC,  

                                                         tap.APPLICATION_NAME ,  

                                                         COALESCE(br.IMPGROUPKEY, part.PARTIMPGROUP ) IMPGROUPKEY,  

                                                         tdprd.TARGET_DIMENSION_NAME PERIOD_DIMENSION,  

                                                         br.PERIOD_MAPPING_TYPE,  

                                                         br.CALENDAR_ID,  

                                                         tdact.TARGET_DIMENSION_NAME ACCOUNT_DIMENSION, 

                                                         tdcur.TARGET_DIMENSION_NAME CURRENCY_DIMENSION

                                                       FROM aif_processes p,  

                                                         aif_bal_rule_loads brl,  

                                                         aif_balance_rules br,  

                                                         tpovpartition part,  

                                                         tbhvimpgroup ig,  

                                                         aif_target_applications tap,  

                                                         (SELECT COALESCE(  

                                                           (SELECT PROFILE_OPTION_VALUE  

                                                             + /  

                                                           FROM AIF_PROFILE_OPTION_VALUES  

                                                           WHERE PROFILE_OPTION_NAME = PROFILE_APP_ROOT_DIRECTORY  

                                                           AND LEVEL_ID              = 1005  

                                                           AND LEVEL_VALUE           = brl.APPLICATION_ID  

                                                           ) ,COALESCE(  

                                                           (SELECT PROFILE_OPTION_VALUE  

                                                             + /  

                                                           FROM AIF_PROFILE_OPTION_VALUES  

                                                           WHERE PROFILE_OPTION_NAME = PROFILE_APP_ROOT_DIRECTORY  

                                                           AND LEVEL_ID              = 1000  

                                                           ) ,' ) ,' )  

                                                           + COALESCE(brl.FILE_PATH, ') FILE_PATH,  

                                                           brl.LOADID  

                                                         FROM AIF_BAL_RULE_LOADS brl  

                                                         ) dir,

                                                       aif_target_applications td  

                                                       LEFT OUTER JOIN aif_target_appl_dimensions tdprd 

                                                           ON td.application_id = tdprd.application_id 

                                                           AND tdprd.target_dimension_class_name = Period 

                                                       LEFT OUTER JOIN aif_target_appl_dimensions tdact  

                                                         ON td.application_id                             = tdact.application_id  

                                                         AND tdact.target_dimension_class_name            = Account  

                                                       LEFT OUTER JOIN aif_target_appl_dimensions tdcur  

                                                         ON td.application_id                             = tdcur.application_id  

                                                         AND tdcur.target_dimension_class_name            = Currency    

                                                       WHERE p.process_id                               = ?    

                                                       AND p.process_id                                 = dir.loadid  

                                                       AND brl.loadid                                   = p.process_id  

                                                       AND part.partitionkey                            = p.partitionkey  

                                                       AND COALESCE(br.IMPGROUPKEY, part.PARTIMPGROUP ) = ig.IMPGROUPKEY  

                                                       AND tap.application_id                           = p.application_id  

                                                       AND br.rule_id                                   = p.rule_id  

                                                       AND brl.application_id                           = p.application_id                     AND ig.imptargetapplicationid = td.application_id

          2017-02-01 15:23:29,611 DEBUG [AIF]: Peirod Dim Name:Period

          2017-02-01 15:23:29,612 DEBUG [AIF]: FILE_CHARSET_ENCODING: UTF-8

          2017-02-01 15:23:29,613 DEBUG [AIF]: SELECT fl.impgroupkey,

                                  fl.impfldfieldname,

                                  fl.impfldfixedtext,

                                  fl.impfldstartpos,

                                  fl.impfldlength,

                                  fl.impfldsourcecolname,

                                  ig.impgroupfiletype,

                                  ig.impgroupdelimiter,

                                  fl.impfldfieldname

                                FROM tbhvimpgroup ig,

                                  tbhvimpitemfile fl,

                                  tpovpartition part,

                                  aif_processes pr,

                                  aif_balance_rules b

                                WHERE pr.process_id = ?                        

                                AND part.partitionkey = pr.partitionkey

                                AND coalesce(b.IMPGROUPKEY,part.PARTIMPGROUP) = ig.impgroupkey

                                AND ig.impgroupkey = fl.impgroupkey

                                AND b.rule_id = pr.rule_id

                                AND (fl.impfldfieldname =DATA OR fl.impfldfieldname =AMOUNT)                      AND  fl.impfldfixedtext is not null  

          2017-02-01 15:23:29,613 DEBUG [AIF]: SELECT fl.impgroupkey,

                                  fl.impfldfieldname,

                                  fl.impfldfixedtext,

                                  fl.impfldstartpos,

                                  fl.impfldlength,

                                  fl.impfldsourcecolname,

                                  ig.impgroupfiletype,

                                  ig.impgroupdelimiter,

                                  fl.impfldfieldname

                                FROM tbhvimpgroup ig,

                                  tbhvimpitemfile fl,

                                  tpovpartition part,

                                  aif_processes pr,

                                  aif_balance_rules b

                                WHERE pr.process_id = ?                        

                                AND part.partitionkey = pr.partitionkey

                                AND coalesce(b.IMPGROUPKEY,part.PARTIMPGROUP) = ig.impgroupkey

                                AND ig.impgroupkey = fl.impgroupkey

                                AND b.rule_id = pr.rule_id

                                AND (fl.impfldfieldname =DATA OR fl.impfldfieldname =AMOUNT)                      AND  fl.impfldfixedtext is not null  

          2017-02-01 15:23:29,616 DEBUG [AIF]: SELECT CASE WHEN EXISTS (select 1 from aif_bal_rule_load_params where  parameter_type = SOURCE_DRIVER_MEMBER and loadid = ?  and PARAMETER_VALUE is not null )

                                             THEN Y

                                             ELSE N

                                           END AS rec_exists

                                    FROM AIF_VERSIONS

          2017-02-01 15:23:29,617 DEBUG [AIF]:               SELECT CASE WHEN EXISTS (SELECT 1 FROM TPOVPERIODADAPTOR WHERE INTSYSTEMKEY = ?)

                                 THEN Y

                                 ELSE N

                               END AS rec_exists

                        FROM AIF_VERSIONS

          2017-02-01 15:23:29,618 DEBUG [AIF]: SELECT pp.PERIODKEY, pp.PERIODDESC

                          ,0 GL_EFFECTIVE_PERIOD_NUM

                    FROM 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 = ?

                    ORDER BY PERIODKEY

          2017-02-01 15:23:29,621 DEBUG [AIF]: SELECT

            periodkey

          FROM

            TPOVPERIOD

          WHERE

            perioddesc = ?

          2017-02-01 15:23:29,621 DEBUG [AIF]: SELECT

            periodkey

          FROM

            TPOVPERIOD

          WHERE

            perioddesc = ?

          2017-02-01 15:23:29,622 DEBUG [AIF]: Jan-2017:2017-01-31

          2017-02-01 15:23:29,622 DEBUG [AIF]: ColumnList: [9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20]

          2017-02-01 15:23:29,622 DEBUG [AIF]: MemberList: [Jan-2017]

          2017-02-01 15:23:29,622 DEBUG [AIF]: Driver:Period

          2017-02-01 15:23:29,622 DEBUG [AIF]: SELECT CASE WHEN EXISTS (select 1 from aif_bal_rule_load_params where  parameter_type = SOURCE_PERIODS and loadid = ?)

                                             THEN Y

                                             ELSE N

                                           END AS rec_exists

                                    FROM AIF_VERSIONS

          2017-02-01 15:23:29,624 DEBUG [AIF]: Source periods already exist in AIF_BAL_RULE_LOAD_PARAMS:

          2017-02-01 15:23:29,624 DEBUG [AIF]: Fewer members provided as members than what was expected as per column expression.

          2017-02-01 15:23:29,624 DEBUG [AIF]: Unequal list size.

          2017-02-01 15:23:29,624 DEBUG [AIF]: ColumnList: [9]

          2017-02-01 15:23:29,624 DEBUG [AIF]: MemberList: [Jan-2017]

          2017-02-01 15:23:29,624 DEBUG [AIF]: Driver:Period

          2017-02-01 15:23:29,625 DEBUG [AIF]: Driver:Period

          2017-02-01 15:23:29,625 DEBUG [AIF]: Member:[Jan-2017]

          2017-02-01 15:23:29,626 DEBUG [AIF]: Column:[9]

          2017-02-01 15:23:29,649 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT9:ImpFieldText=Column=9,20;NZP:StartPos=9:SourceClName=null

          2017-02-01 15:23:29,649 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=null

          2017-02-01 15:23:29,649 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=4:SourceClName=null

          2017-02-01 15:23:29,650 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=null

          2017-02-01 15:23:29,650 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=3:SourceClName=null

          2017-02-01 15:23:29,650 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=5:SourceClName=null

          2017-02-01 15:23:29,650 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=6:SourceClName=null

          2017-02-01 15:23:29,650 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=7:SourceClName=null

          2017-02-01 15:23:29,650 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=8:SourceClName=null

          2017-02-01 15:23:29,650 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

          2017-02-01 15:23:29,650 INFO  [AIF]: EPMFDM-140274:Message - File Name ImportFormatTemplate14.csv

          periodKey2017-01-31

          2017-02-01 15:23:29,652 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 31

          PARTITIONKEY: 66

          IMPORT GROUP: IF_MULTILOAD

          FILE TYPE: MULTIPERIOD

          DELIMITER: ;

          SOURCE FILE: ImportFormatTemplate14.csv

          PROCESSING CODES:

          -----------------------------------------------------------------------------------

          BLANK............. Line is blank or empty.

          NN................ Non-Numeric, Amount field contains non numeric characters.

          TC................ Type Conversion, Amount field could not be converted to a number.

          ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

          SKIP FIELD.............. SKIP field value was found

          NULL ACCOUNT VALUE.............. Account Field is null

          SKIP FROM SCRIPT.............. Skipped through Script

          HEADER ROW.............. Header Row

          ERROR_INVALID_PERIOD.............. Invalid period specified in the file.

           

           

           

           

          [TC] - [Amount=NN] Entity;Account;ICP;Custom1;Custom2;Custom3;Custom4;Custom5;Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec

          Rows Loaded: 2

          Rows Rejected: 1

           

           

          2017-02-01 15:23:29,654 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy

          2017-02-01 15:23:29,654 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

          2017-02-01 15:23:29,655 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 3120170131

          2017-02-01 15:23:29,655 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: ImportFormatTemplate14

          Extension: csv

          2017-02-01 15:23:29,656 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 3120170131.csv

          2017-02-01 15:23:29,656 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: ImportFormatTemplate14.csv

          2017-02-01 15:23:29,656 INFO  [AIF]: EPMFDM-140274:Message - File not deleted: C:\FDMEE\ImportFormatTemplate14.csv

          2017-02-01 15:23:29,664 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

          2017-02-01 15:23:29,664 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 95

          2017-02-01 15:23:29,665 DEBUG [AIF]: FileData.importData - END

          2017-02-01 15:23:29,733 DEBUG [AIF]: CommData.postImportData - START

          2017-02-01 15:23:29,733 DEBUG [AIF]: CommData.getRuleInfo - START

          2017-02-01 15:23:29,736 DEBUG [AIF]:

                SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, adim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

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

                FROM TPOVPARTITION tpp

                INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                  ON adim.APPLICATION_ID = 3

                LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                  ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

                WHERE tpp.PARTITIONKEY = 66

                AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                ORDER BY adim.BALANCE_COLUMN_NAME

               

          2017-02-01 15:23:29,740 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVALORA', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'EXPORT_TO_TARGET_FLAG': u'N', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'IMPGROUPFILETYPE': u'MULTIPER', 'RULE_ID': 5L, 'SOURCE_ADAPTER_FLAG': u'N', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}

          2017-02-01 15:23:29,743 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}

          2017-02-01 15:23:29,744 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

          2017-02-01 15:23:29,744 DEBUG [AIF]: CommData.getRuleInfo - END

          2017-02-01 15:23:29,752 DEBUG [AIF]: CommData.updateTDATASEG_T - START

          2017-02-01 15:23:29,754 DEBUG [AIF]: CommData.getLedgerListAndMap - START

          2017-02-01 15:23:29,755 DEBUG [AIF]: CommData.getLedgerSQL - START

          2017-02-01 15:23:29,755 DEBUG [AIF]: CommData.getLedgerSQL - END

          2017-02-01 15:23:29,755 DEBUG [AIF]:

                    SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID, NULL SOURCE_LEDGER_NAME, NULL SOURCE_COA_ID

                          ,br.CALENDAR_ID, NULL SETID, NULL PERIOD_TYPE, NULL LEDGER_TABLE_NAME

                    FROM AIF_BALANCE_RULES br

                    WHERE br.RULE_ID = 5

                   

          2017-02-01 15:23:29,756 DEBUG [AIF]: CommData.getLedgerListAndMap - END

          2017-02-01 15:23:29,759 DEBUG [AIF]: CommData.getPovList - START

          2017-02-01 15:23:29,760 DEBUG [AIF]:

                  SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

                        ,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) 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 = 31

                  ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

                 

          2017-02-01 15:23:29,766 DEBUG [AIF]: CommData.getPovList - END

          2017-02-01 15:23:29,766 DEBUG [AIF]:

                    SELECT pp.PERIODKEY

                    FROM AIF_PROCESS_PERIODS pp

                       ,( SELECT entity_name FILE_ENTITY_NAME, pd.process_id, pd.entity_name_order 

                          FROM aif_process_details pd

                          WHERE pd.entity_type     = 'PROCESS_BAL_IMP_FILE'

                          AND pd.target_table_name = 'TDATASEG'

                          AND pd.status            = 'FAILED'

                        ) en

                    WHERE pp.PROCESS_ID    = 31

                    AND en.process_id      = pp.process_id

                    AND pp.IMP_ENTITY_NAME = en.file_entity_name

                    order by en.entity_name_order

                   

          2017-02-01 15:23:29,769 INFO  [AIF]:

          Import Data from Source for Period 'Jan-2017'

          2017-02-01 15:23:29,775 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-01 15:23:29,775 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 = 66 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2017-01-31' AND tlp.RULE_ID = 5 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

             

          2017-02-01 15:23:29,777 DEBUG [AIF]:

                  UPDATE TLOGPROCESS

                  SET PROCESSENDTIME=CURRENT_TIMESTAMP

                     ,PROCESSSTATUS=0,PROCESSIMP=0,PROCESSVAL=0,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0

                     ,PROCESSIMPNOTE=NULL,PROCESSVALNOTE=NULL,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

                  WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                 

          2017-02-01 15:23:29,778 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-01 15:23:29,778 DEBUG [AIF]:

                      SELECT adim.BALANCE_COLUMN_NAME DIMNAME, dim.TARGET_DIMENSION_CLASS_NAME

                      FROM TPOVPARTITION tpp

                      INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                        ON adim.APPLICATION_ID = tpp.PARTTARGETAPPLICATIONID AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                      INNER JOIN AIF_DIMENSIONS dim

                        ON dim.DIMENSION_ID = adim.DIMENSION_ID

                      WHERE tpp.PARTITIONKEY = 66

                      AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                      ORDER BY adim.BALANCE_COLUMN_NAME

                     

          2017-02-01 15:23:29,782 DEBUG [AIF]: 

                      UPDATE TDATASEG_T

                      SET AMOUNTX = AMOUNT, DATAX = DATA

                         ,ACCOUNTX = NULL

                         ,ENTITYX = NULL

                         ,ICPX = NULL

                         ,UD1X = NULL

                         ,UD2X = NULL

                         ,UD3X = NULL

                         ,UD4X = NULL

                         ,UD5X = NULL

                      WHERE TDATASEG_T.LOADID = 31 AND TDATASEG_T.PARTITIONKEY = 66 AND TDATASEG_T.CATKEY = 3 AND TDATASEG_T.PERIODKEY = '2017-01-31'

                     

          2017-02-01 15:23:29,783 INFO  [AIF]: Generic Data Rows Imported from Source: 2

          2017-02-01 15:23:29,783 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

                          ,PARTITIONKEY

                          ,CATKEY

                          ,RULE_ID

                          ,PERIODKEY

                          ,EXPORT_TO_TARGET_FLAG

                        )

                        SELECT DISTINCT PROCESS_ID LOADID

                        ,'HFM' TARGET_APPLICATION_TYPE

                        ,'VCONSOL' TARGET_APPLICATION_NAME

                        ,NULL PLAN_TYPE

                        ,0 SOURCE_LEDGER_ID

                        ,YEARTARGET EPM_YEAR

                        ,PERIODTARGET EPM_PERIOD

                        ,'Y' SNAPSHOT_FLAG

                        ,66 PARTITIONKEY

                        ,3 CATKEY

                        ,5 RULE_ID

                        ,PERIODKEY

                        ,'N' EXPORT_TO_TARGET_FLAG

                        FROM AIF_PROCESS_PERIODS

                        WHERE PROCESS_ID = 31

                        AND PERIODKEY = '2017-01-31'

                       

          2017-02-01 15:23:29,785 INFO  [AIF]: Total Data Rows Imported from Source: 2

          2017-02-01 15:23:29,786 DEBUG [AIF]: CommData.updateTDATASEG_T - END

          2017-02-01 15:23:29,791 DEBUG [AIF]: Comm.doScriptInit - START

          2017-02-01 15:23:29,864 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\FDMEE\inbox, LOCNAME=ALL_VALORA, SOURCENAME=File, APPID=3, SOURCEID=1, APPROOTDIR=C:\FDMEE, IMPORTFORMAT=IF_MULTILOAD, SCRIPTSDIR=C:\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=5, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=31, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate14.csv, LOCKEY=66, RULENAME=DLR_ALLVALORA, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=admin, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

          2017-02-01 15:23:29,871 DEBUG [AIF]: The executeEventScript is set to: YES

          2017-02-01 15:23:29,871 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE

          2017-02-01 15:23:29,871 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

          2017-02-01 15:23:29,871 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

          2017-02-01 15:23:29,871 DEBUG [AIF]: Comm.doScriptInit - END

          2017-02-01 15:23:29,871 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:29,871 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftImport.py

          2017-02-01 15:23:29,875 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:29,875 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

          2017-02-01 15:23:29,875 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftImport.vbs

          2017-02-01 15:23:29,875 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:29,875 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:29,875 DEBUG [AIF]: CommData.postImportData - END

          2017-02-01 15:23:30,041 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

          2017-02-01 15:23:30,041 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:30,042 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcLogicGrp.py

          2017-02-01 15:23:30,042 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:30,042 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcLogicGrp.vbs

          2017-02-01 15:23:30,042 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:30,042 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:30,044 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

          2017-02-01 15:23:30,044 DEBUG [AIF]:

                  select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

                  from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

                  where prs.PROCESS_ID=31 and prs.PARTITIONKEY=part.PARTITIONKEY

                  and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

                 

          2017-02-01 15:23:30,047 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

          2017-02-01 15:23:30,047 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:30,047 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcLogicGrp.py

          2017-02-01 15:23:30,048 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:30,048 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcLogicGrp.vbs

          2017-02-01 15:23:30,048 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:30,048 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:30,048 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

          2017-02-01 15:23:30,078 DEBUG [AIF]: CommData.mapData - START

          2017-02-01 15:23:30,080 DEBUG [AIF]: CommData.insertTransProcessDetails - START

          2017-02-01 15:23:30,081 DEBUG [AIF]:

                    INSERT INTO AIF_PROCESS_DETAILS (

                      PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, TARGET_TABLE_NAME, EXECUTION_START_TIME

                      ,EXECUTION_END_TIME, RECORDS_PROCESSED, STATUS, LAST_UPDATED_BY, LAST_UPDATE_DATE

                    )

                    SELECT PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, 'TDATASEG' TARGET_TABLE_NAME, CURRENT_TIMESTAMP EXECUTION_START_TIME

                          ,NULL EXECUTION_END_TIME, 0 RECORDS_PROCESSED, 'PENDING' STATUS, 'admin' LAST_UPDATED_BY, CURRENT_TIMESTAMP LAST_UPDATE_DATE

                    FROM (

                      SELECT PROCESS_ID, TRANS_ENTITY_TYPE ENTITY_TYPE, MIN(TRANS_ENTITY_ID) ENTITY_ID, TRANS_ENTITY_NAME ENTITY_NAME

                            ,MIN(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

                      FROM AIF_PROCESS_PERIODS

                      WHERE PROCESS_ID = 31

                      AND PRIOR_PERIOD_FLAG = 'N'

                      GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

                    ) q

                    ORDER BY ENTITY_NAME_ORDER

                   

          2017-02-01 15:23:30,083 DEBUG [AIF]: CommData.insertTransProcessDetails - END

          2017-02-01 15:23:30,092 DEBUG [AIF]:

                  DELETE FROM TDATAMAP_T

                  WHERE LOADID < 31

                  AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 5 AND p.PROCESS_ID = TDATAMAP_T.LOADID )

                 

          2017-02-01 15:23:30,094 DEBUG [AIF]:

                  DELETE FROM TDATASEG_T

                  WHERE LOADID < 31

                  AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 5 AND p.PROCESS_ID = TDATASEG_T.LOADID )

                 

          2017-02-01 15:23:30,095 DEBUG [AIF]:

                  DELETE FROM AIF_PROCESS_PERIODS

                  WHERE PROCESS_ID < 31

                  AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 5 AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID )

                 

          2017-02-01 15:23:30,101 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

          2017-02-01 15:23:30,103 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

          2017-02-01 15:23:30,103 DEBUG [AIF]:

                  SELECT COALESCE(part_parent.PARTITIONKEY, part.PARTITIONKEY) PARTITIONKEY, COALESCE(part_parent.PARTNAME, part.PARTNAME) PARTNAME

                  FROM TPOVPARTITION part

                  LEFT OUTER JOIN TPOVPARTITION part_parent

                    ON part_parent.PARTITIONKEY = part.PARTPARENTKEY

                  WHERE part.PARTITIONKEY = 66

                 

          2017-02-01 15:23:30,105 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

          2017-02-01 15:23:30,107 INFO  [AIF]: Processing Mappings from Parent Location: VALORAGROUP

          2017-02-01 15:23:30,107 DEBUG [AIF]:

                  INSERT INTO TDATAMAP_T (

                    LOADID, DATAKEY, PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY

                   ,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID

                  )

                  SELECT 31, DATAKEY, 66 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '<BLANK>' THEN ' ' ELSE TARGKEY END

                        ,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID

                  FROM TDATAMAP

                  WHERE PARTITIONKEY = 82

                  AND ( RULE_ID IS NULL OR RULE_ID = 5 )

                 

          2017-02-01 15:23:30,108 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 8

          2017-02-01 15:23:30,158 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

          2017-02-01 15:23:30,158 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:30,159 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcMap.py

          2017-02-01 15:23:30,159 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:30,159 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcMap.vbs

          2017-02-01 15:23:30,159 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:30,159 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:30,160 DEBUG [AIF]:

                SELECT DIMNAME, SRCKEY, TARGKEY, WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, DATAKEY, MAPPING_TYPE

                      ,CASE WHEN (RULE_ID IS NOT NULL) THEN 'Y' ELSE 'N' END IS_RULE_MAP

                FROM (

                  SELECT DISTINCT tdm.DIMNAME, tdm.RULE_ID, NULL SRCKEY, NULL TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, NULL CHANGESIGN

                        ,1 SEQUENCE, COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG, NULL DATAKEY

                        ,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING_TYPE, COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

                  FROM TDATAMAP_T tdm

                    INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

                  WHERE tdm.LOADID = 31

                  AND atad.APPLICATION_ID = 3

                  AND tdm.PARTITIONKEY = 66

                  AND tdm.TDATAMAPTYPE = 'ERP'

                  AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 5)

                  AND tdm.WHERECLAUSETYPE IS NULL

                  UNION ALL

                  SELECT tdm.DIMNAME, tdm.RULE_ID, tdm.SRCKEY, tdm.TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, tdm.CHANGESIGN

                        ,CASE tpp.PARTSEQMAP

                           WHEN 0 THEN CASE WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2

                                            WHEN (tdm.WHERECLAUSETYPE = 'IN') THEN 3

                                            WHEN (tdm.WHERECLAUSETYPE = 'MULTIDIM') THEN 4

                                            WHEN (tdm.WHERECLAUSETYPE = 'LIKE') THEN 5

                                            ELSE 0 END     

                           ELSE tdm.SEQUENCE

                           END SEQUENCE

                        ,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG, tdm.DATAKEY

                        ,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING_TYPE, COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

                  FROM TDATAMAP_T tdm

                    INNER JOIN TPOVPARTITION tpp ON tpp.PARTITIONKEY = tdm.PARTITIONKEY

                    INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

                  WHERE tdm.LOADID = 31

                  AND atad.APPLICATION_ID = 3

                  AND tdm.PARTITIONKEY = 66

                  AND tdm.TDATAMAPTYPE = 'ERP'

                  AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 5)

                  AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')

                ) q

                ORDER BY CALC_SEQ, DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY

               

          2017-02-01 15:23:30,166 INFO  [AIF]:

          Map Data for Period 'Jan-2017'

          2017-02-01 15:23:30,166 DEBUG [AIF]: Comm.updateProcessDetail - START

          2017-02-01 15:23:30,168 DEBUG [AIF]:

              UPDATE AIF_PROCESS_DETAILS

              SET STATUS = 'RUNNING'

                 ,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + NULL

                 ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

                 ,LAST_UPDATED_BY = CASE WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY ELSE 'admin' END

                 ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

              WHERE PROCESS_ID = 31 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jan-2017'

             

          2017-02-01 15:23:30,170 DEBUG [AIF]: Comm.updateProcessDetail - END

          2017-02-01 15:23:30,172 DEBUG [AIF]:

                SELECT COUNT(*) ROW_COUNT

                FROM TDATASEG_T

                WHERE LOADID = 31

                AND (PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31' AND RULE_ID = 5 AND VALID_FLAG = 'Y')

               

          2017-02-01 15:23:30,173 INFO  [AIF]:

          Processing Mappings for Column 'ACCOUNT'

          2017-02-01 15:23:30,173 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET ACCOUNTX = ACCOUNT

                           ,ACCOUNTR = 1

                           ,ACCOUNTF = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,174 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ACCOUNT' (LIKE): 2

          2017-02-01 15:23:30,175 INFO  [AIF]:

          Processing Mappings for Column 'ENTITY'

          2017-02-01 15:23:30,175 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET ENTITYX = ENTITY

                           ,ENTITYR = 4

                           ,ENTITYF = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (ENTITYX IS NULL OR ENTITYX = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,176 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ENTITY' (LIKE): 2

          2017-02-01 15:23:30,176 INFO  [AIF]:

          Processing Mappings for Column 'ICP'

          2017-02-01 15:23:30,176 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET ICPX = ICP

                           ,ICPR = 5

                           ,ICPF = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (ICPX IS NULL OR ICPX = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,177 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ICP' (LIKE): 2

          2017-02-01 15:23:30,178 INFO  [AIF]:

          Processing Mappings for Column 'UD1'

          2017-02-01 15:23:30,178 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET UD1X = UD1

                           ,UD1R = 2

                           ,UD1F = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (UD1X IS NULL OR UD1X = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,179 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ACCDET' (LIKE): 2

          2017-02-01 15:23:30,180 INFO  [AIF]:

          Processing Mappings for Column 'UD2'

          2017-02-01 15:23:30,180 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET UD2X = UD2

                           ,UD2R = 6

                           ,UD2F = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (UD2X IS NULL OR UD2X = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,181 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_NATURE' (LIKE): 2

          2017-02-01 15:23:30,182 INFO  [AIF]:

          Processing Mappings for Column 'UD3'

          2017-02-01 15:23:30,182 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET UD3X = UD3

                           ,UD3R = 7

                           ,UD3F = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (UD3X IS NULL OR UD3X = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,182 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_REGIONS' (LIKE): 2

          2017-02-01 15:23:30,183 INFO  [AIF]:

          Processing Mappings for Column 'UD4'

          2017-02-01 15:23:30,183 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET UD4X = UD4

                           ,UD4R = 3

                           ,UD4F = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (UD4X IS NULL OR UD4X = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,184 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_APPENDIX' (LIKE): 2

          2017-02-01 15:23:30,185 INFO  [AIF]:

          Processing Mappings for Column 'UD5'

          2017-02-01 15:23:30,185 DEBUG [AIF]:

                        UPDATE TDATASEG_T

                        SET UD5X = UD5

                           ,UD5R = 8

                           ,UD5F = 3

                        WHERE LOADID = 31

                        AND PARTITIONKEY = 66

                        AND CATKEY = 3

                        AND (UD5X IS NULL OR UD5X = '')

                        AND (1=1)

                        AND PERIODKEY = '2017-01-31'

          2017-02-01 15:23:30,186 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_SSTORE' (LIKE): 2

          2017-02-01 15:23:30,187 DEBUG [AIF]: Comm.updateProcessDetail - START

          2017-02-01 15:23:30,187 DEBUG [AIF]:

              UPDATE AIF_PROCESS_DETAILS

              SET STATUS = 'SUCCESS'

                 ,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + 2

                 ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

                 ,LAST_UPDATED_BY = CASE WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY ELSE 'admin' END

                 ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

              WHERE PROCESS_ID = 31 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jan-2017'

             

          2017-02-01 15:23:30,189 DEBUG [AIF]: Comm.updateProcessDetail - END

          2017-02-01 15:23:30,189 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

          2017-02-01 15:23:30,199 DEBUG [AIF]: CommData.updateYtdAmounts - START

          2017-02-01 15:23:30,202 DEBUG [AIF]: CommData.getLedgerListAndMap - START

          2017-02-01 15:23:30,203 DEBUG [AIF]: CommData.getLedgerSQL - START

          2017-02-01 15:23:30,203 DEBUG [AIF]: CommData.getLedgerSQL - END

          2017-02-01 15:23:30,203 DEBUG [AIF]:

                    SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID, NULL SOURCE_LEDGER_NAME, NULL SOURCE_COA_ID

                          ,br.CALENDAR_ID, NULL SETID, NULL PERIOD_TYPE, NULL LEDGER_TABLE_NAME

                    FROM AIF_BALANCE_RULES br

                    WHERE br.RULE_ID = 5

                   

          2017-02-01 15:23:30,204 DEBUG [AIF]: CommData.getLedgerListAndMap - END

          2017-02-01 15:23:30,204 DEBUG [AIF]: CommData.updateYtdAmounts - END

          2017-02-01 15:23:30,215 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

          2017-02-01 15:23:30,215 INFO  [AIF]:

          Stage Data for Period 'Jan-2017'

          2017-02-01 15:23:30,216 DEBUG [AIF]:

                  DELETE FROM TDATAMAPSEG

                  WHERE PARTITIONKEY = 66

                  AND CATKEY = 3

                  AND PERIODKEY = '2017-01-31'

                 

          2017-02-01 15:23:30,217 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 8

          2017-02-01 15:23:30,217 DEBUG [AIF]:

                  INSERT INTO TDATAMAPSEG (

                         DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                         WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

                  )

                  SELECT DATAKEY, PARTITIONKEY, 3, '2017-01-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                         WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

                  FROM TDATAMAP_T

                  WHERE LOADID = 31

                 

          2017-02-01 15:23:30,218 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 8

          2017-02-01 15:23:30,218 DEBUG [AIF]:

                  DELETE FROM TDATAMAP_T

                  WHERE LOADID = 31

                 

          2017-02-01 15:23:30,219 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 8

          2017-02-01 15:23:30,219 DEBUG [AIF]:

                      DELETE FROM TDATASEG

                      WHERE LOADID < 31 AND PARTITIONKEY = 66 AND CATKEY = 3 AND RULE_ID = 5 AND PERIODKEY = '2017-01-31'

                     

          2017-02-01 15:23:30,220 INFO  [AIF]: Number of Rows deleted from TDATASEG: 2

          2017-02-01 15:23:30,220 DEBUG [AIF]:

                      DELETE FROM TDATAMEMOITEMS

                      WHERE PARTITIONKEY = 66 AND PERIODKEY = '2017-01-31' AND CATKEY = 3 AND RULE_ID = 5

                      AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)

                     

          2017-02-01 15:23:30,221 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

          2017-02-01 15:23:30,221 DEBUG [AIF]:

                      DELETE FROM TDATAARCHIVE

                      WHERE PARTITIONKEY = 66 AND PERIODKEY = '2017-01-31' AND CATKEY = 3 AND RULE_ID = 5

                      AND ARCHIVEPROCTYPEID = 1

                      AND NOT EXISTS ( SELECT 1

                                       FROM TDATAMEMOITEMS

                                       WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID

                                       OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )

                     

          2017-02-01 15:23:30,222 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

          2017-02-01 15:23:30,222 DEBUG [AIF]:

                    INSERT INTO TDATASEG (

                      DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID

                      ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2

                      ,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF

                      ,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F

                      ,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F

                      ,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F

                      ,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F

                      ,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F

                      ,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14

                      ,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG )

                    SELECT

                      DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID

                      ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2

                      ,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF

                      ,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F

                      ,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F

                      ,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F

                      ,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F

                      ,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F

                      ,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14

                      ,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG

                    FROM TDATASEG_T

                    WHERE LOADID = 31 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31'

                   

          2017-02-01 15:23:30,224 INFO  [AIF]: Number of Rows inserted into TDATASEG: 2

          2017-02-01 15:23:30,224 DEBUG [AIF]:

                  DELETE FROM TDATASEG_T

                  WHERE LOADID = 31 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31'

                 

          2017-02-01 15:23:30,225 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 2

          2017-02-01 15:23:30,232 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-01 15:23:30,232 DEBUG [AIF]:

                  UPDATE TLOGPROCESS

                  SET PROCESSENDTIME=CURRENT_TIMESTAMP

                     ,PROCESSSTATUS=1,PROCESSIMP=1,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0

                     ,PROCESSIMPNOTE='AIF_WF_IMP_IMPORT_OK_TXT'

                  WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                 

          2017-02-01 15:23:30,234 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-01 15:23:30,235 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

          2017-02-01 15:23:30,235 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:30,235 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcMap.py

          2017-02-01 15:23:30,235 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:30,235 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcMap.vbs

          2017-02-01 15:23:30,235 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:30,235 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:30,235 DEBUG [AIF]: CommData.mapData - END

          2017-02-01 15:23:30,256 INFO  [AIF]: -------END IMPORT STEP-------

          2017-02-01 15:23:30,285 INFO  [AIF]: -------START VALIDATE STEP-------

          2017-02-01 15:23:30,317 DEBUG [AIF]: CommData.validateData - START

          2017-02-01 15:23:30,317 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:30,318 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefValidate.py

          2017-02-01 15:23:30,318 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:30,318 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefValidate.vbs

          2017-02-01 15:23:30,318 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:30,318 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:30,323 DEBUG [AIF]: CommMap.validateData - START

          2017-02-01 15:23:30,326 INFO  [AIF]:

          Validate Data Mappings for Period 'Jan-2017'

          2017-02-01 15:23:30,326 DEBUG [AIF]:

                SELECT COUNT(*) ROW_COUNT

                FROM TDATASEG

                WHERE LOADID = 31

                AND (PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31' AND RULE_ID = 5 AND VALID_FLAG = 'Y')

               

          2017-02-01 15:23:30,327 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-01 15:23:30,327 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 = 66 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2017-01-31' AND tlp.RULE_ID = 5 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

             

          2017-02-01 15:23:30,328 DEBUG [AIF]:

                  UPDATE TLOGPROCESS

                  SET PROCESSENDTIME=CURRENT_TIMESTAMP

                     ,PROCESSSTATUS=10,PROCESSVAL=0,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0,BLNVALDIRTY=0

                     ,PROCESSVALNOTE=NULL,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

                  WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                 

          2017-02-01 15:23:30,330 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-01 15:23:30,330 DEBUG [AIF]:

                          UPDATE TDATASEG

                          SET VALID_FLAG = 'N'

                          WHERE 1=1

                          AND ( (1=0)

                                OR (TDATASEG.ACCOUNTX IS NULL OR TDATASEG.ACCOUNTX = '')

                                OR (TDATASEG.ENTITYX IS NULL OR TDATASEG.ENTITYX = '')

                                OR (TDATASEG.ICPX IS NULL OR TDATASEG.ICPX = '')

                                OR (TDATASEG.UD1X IS NULL OR TDATASEG.UD1X = '')

                                OR (TDATASEG.UD2X IS NULL OR TDATASEG.UD2X = '')

                                OR (TDATASEG.UD3X IS NULL OR TDATASEG.UD3X = '')

                                OR (TDATASEG.UD4X IS NULL OR TDATASEG.UD4X = '')

                                OR (TDATASEG.UD5X IS NULL OR TDATASEG.UD5X = '')

                              )

                          AND LOADID = 31 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31'

                          AND VALID_FLAG = 'Y'

                          AND CALCACCTTYPE > 0

                         

          2017-02-01 15:23:30,331 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-01 15:23:30,332 DEBUG [AIF]:

                  UPDATE TLOGPROCESS

                  SET PROCESSENDTIME=CURRENT_TIMESTAMP

                     ,PROCESSSTATUS=11,PROCESSVAL=1,BLNVALDIRTY=0

                     ,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_OK_TXT'

                  WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                 

          2017-02-01 15:23:30,333 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-01 15:23:30,333 INFO  [AIF]: Total Data Rows available for Export to Target: 2

          2017-02-01 15:23:30,333 DEBUG [AIF]: CommMap.validateData - END

          2017-02-01 15:23:30,334 INFO  [AIF]:

          Validate Data Members for Period 'Jan-2017'

          2017-02-01 15:23:30,334 DEBUG [AIF]:

                SELECT COUNT(*) ROW_COUNT

                FROM TDATASEG

                WHERE LOADID = 31

                AND (PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31' AND RULE_ID = 5 AND VALID_FLAG = 'Y')

               

          2017-02-01 15:23:30,335 INFO  [AIF]: Total Data Rows available for Export to Target: 2

          2017-02-01 15:23:30,336 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 31 and parameter_name = 'CHECK_INTERSECTION'

          2017-02-01 15:23:30,338 DEBUG [AIF]: Comm.executeJythonScript - START

          2017-02-01 15:23:30,360 INFO  [AIF]: Executing the following script: D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py

          2017-02-01 15:23:30,489 DEBUG [AIF]: User Locale is not set. Defaulting to: en_US

          2017-02-01 15:23:30,489 DEBUG [AIF]: HFM_VALIDATE.py Started for LoadID: 31

          2017-02-01 15:23:31,197 INFO  [AIF]: Cluster name:  HFMcluster

          2017-02-01 15:23:31,200 DEBUG [AIF]: getGlobalUserID(): GET_GLOBAL_USER_ID returned no rows for LoadID = 31

          2017-02-01 15:23:31,200 DEBUG [AIF]: Global User ID:

          2017-02-01 15:23:31,363 ERROR [AIF]: HFMException: Angemeldeter Benutzer besitzt keine Zugriffsberechtigung für diese Anwendung: HFM:VCONSOL

          2017-02-01 15:23:31,363 DEBUG [AIF]: connect(admin, en_US, HFMcluster, VCONSOL)

          2017-02-01 15:23:31,367 DEBUG [AIF]: oracle.epm.fm.common.exception.HFMException: EPMHFM-65550: EPMHFM-65550: Angemeldeter Benutzer besitzt keine Zugriffsberechtigung für diese Anwendung: HFM:VCONSOL

            at oracle.epm.fm.hssservice.SecurityWrapper.authenticateUserAndGetInfoInternal(SecurityWrapper.java:426)

            at oracle.epm.fm.hssservice.SecurityWrapper.authenticateUserAndGetInfoForApp(SecurityWrapper.java:583)

            at oracle.epm.fm.hssservice.CASecurityManager.authenticateUserAndGetInfoForApp(CASecurityManager.java:160)

            at oracle.epm.fm.hsxserver.service.HsxServerImpl.createSession(HsxServerImpl.java:636)

            at oracle.epm.fm.hsxserver.service.HsxServerServiceHandler.createSession(HsxServerServiceHandler.java:205)

            at oracle.epm.fm.common.service.hsxserver.HsxServerService$Processor$createSession.getResult(HsxServerService.java:4500)

            at oracle.epm.fm.common.service.hsxserver.HsxServerService$Processor$createSession.getResult(HsxServerService.java:4484)

            at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)

            at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)

            at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)

            at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

            at java.lang.Thread.run(Thread.java:662)

            at oracle.epm.fm.common.exception.ExceptionHelper.convertToHFMException(ExceptionHelper.java:95)

            at oracle.epm.fm.domainobject.application.JHsxClient.createSessionInternal(JHsxClient.java:470)

            at oracle.epm.fm.domainobject.application.JHsxClient.createSession(JHsxClient.java:349)

            at oracle.epm.fm.domainobject.application.SessionOM.createSession(SessionOM.java:385)

            at com.hyperion.aif.hfm.HfmAdapter.connect(HfmAdapter.java:2843)

            at com.hyperion.aif.hfm.HfmAdapter.connect(HfmAdapter.java:2746)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:597)

            at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)

            at org.python.core.PyObject.__call__(PyObject.java:355)

            at org.python.core.PyMethod.__call__(PyMethod.java:215)

            at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

            at org.python.core.PyMethod.__call__(PyMethod.java:206)

            at org.python.core.PyObject.__call__(PyObject.java:451)

            at org.python.core.PyObject.__call__(PyObject.java:457)

            at org.python.pycode._pyx328.f$0(D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py:139)

            at org.python.pycode._pyx328.call_function(D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py)

            at org.python.core.PyTableCode.call(PyTableCode.java:165)

            at org.python.core.PyCode.call(PyCode.java:18)

            at org.python.core.Py.runCode(Py.java:1204)

            at org.python.core.__builtin__.execfile_flags(__builtin__.java:541)

            at org.python.core.__builtin__.execfile(__builtin__.java:519)

            at org.python.core.BuiltinFunctions.__call__(__builtin__.java:205)

            at org.python.core.PyObject.__call__(PyObject.java:436)

            at org.python.pycode._pyx300.executeJythonScript$19(<string>:565)

            at org.python.pycode._pyx300.call_function(<string>)

            at org.python.core.PyTableCode.call(PyTableCode.java:165)

            at org.python.core.PyBaseCode.call(PyBaseCode.java:297)

            at org.python.core.PyBaseCode.call(PyBaseCode.java:191)

            at org.python.core.PyFunction.__call__(PyFunction.java:385)

            at org.python.core.PyMethod.__call__(PyMethod.java:215)

            at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

            at org.python.core.PyMethod.__call__(PyMethod.java:206)

            at org.python.core.PyObject.__call__(PyObject.java:451)

            at org.python.core.PyObject.__call__(PyObject.java:457)

            at org.python.pycode._pyx300.executeVBScript$20(<string>:638)

            at org.python.pycode._pyx300.call_function(<string>)

            at org.python.core.PyTableCode.call(PyTableCode.java:165)

            at org.python.core.PyBaseCode.call(PyBaseCode.java:297)

            at org.python.core.PyBaseCode.call(PyBaseCode.java:191)

            at org.python.core.PyFunction.__call__(PyFunction.java:385)

            at org.python.core.PyMethod.__call__(PyMethod.java:215)

            at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

            at org.python.core.PyMethod.__call__(PyMethod.java:206)

            at org.python.core.PyObject.__call__(PyObject.java:367)

            at org.python.core.PyObject.__call__(PyObject.java:371)

            at org.python.pycode._pyx302.validateData$34(<string>:4519)

            at org.python.pycode._pyx302.call_function(<string>)

            at org.python.core.PyTableCode.call(PyTableCode.java:165)

            at org.python.core.PyBaseCode.call(PyBaseCode.java:297)

            at org.python.core.PyBaseCode.call(PyBaseCode.java:191)

            at org.python.core.PyFunction.__call__(PyFunction.java:385)

            at org.python.core.PyMethod.__call__(PyMethod.java:215)

            at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

            at org.python.core.PyMethod.__call__(PyMethod.java:206)

            at org.python.core.PyObject.__call__(PyObject.java:432)

            at org.python.core.PyObject.__call__(PyObject.java:436)

            at org.python.pycode._pyx327.f$0(<string>:9)

            at org.python.pycode._pyx327.call_function(<string>)

            at org.python.core.PyTableCode.call(PyTableCode.java:165)

            at org.python.core.PyCode.call(PyCode.java:18)

            at org.python.core.Py.runCode(Py.java:1204)

            at org.python.core.Py.exec(Py.java:1248)

            at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

            at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

            at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

            at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

            at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

            at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

            at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

            at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

            at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

            at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

            at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

            at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

            at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

            at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

            at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

            at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

            at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

            at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

            at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

            at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

            at java.lang.Thread.run(Thread.java:662)

           

           

          2017-02-01 15:23:31,391 ERROR [AIF]: The script has failed to execute:

          2017-02-01 15:23:31,412 FATAL [AIF]: Error in Comm.executeJythonScript

          Traceback (most recent call last):

            File "<string>", line 557, in executeJythonScript

            File "D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py", line 92, in <module>

              raise RuntimeError, "Failed to connected to: %s" % str(fdmContext["TARGETAPPNAME"]).encode("utf-8")

          RuntimeError: Failed to connected to: VCONSOL

           

           

          2017-02-01 15:23:31,413 FATAL [AIF]: Error in CommData.validateData

          Traceback (most recent call last):

            File "<string>", line 4499, in validateData

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

            File "<string>", line 557, in executeJythonScript

            File "D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py", line 92, in <module>

              raise RuntimeError, "Failed to connected to: %s" % str(fdmContext["TARGETAPPNAME"]).encode("utf-8")

          RuntimeError: Failed to connected to: VCONSOL

           

           

          2017-02-01 15:23:31,413 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-01 15:23:31,413 DEBUG [AIF]:

                  UPDATE TLOGPROCESS

                  SET PROCESSENDTIME=CURRENT_TIMESTAMP

                     ,PROCESSSTATUS=12,PROCESSVAL=0,BLNVALDIRTY=0

                     ,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_ERR;0'

                  WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                 

          2017-02-01 15:23:31,415 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-01 15:23:31,416 DEBUG [AIF]: Comm.executeScript - START

          2017-02-01 15:23:31,416 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftValidate.py

          2017-02-01 15:23:31,416 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-01 15:23:31,416 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftValidate.vbs

          2017-02-01 15:23:31,416 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-01 15:23:31,416 DEBUG [AIF]: Comm.executeScript - END

          2017-02-01 15:23:31,491 DEBUG [AIF]: Comm.finalizeProcess - START

          2017-02-01 15:23:31,492 DEBUG [AIF]: CommData.updateRuleStatus - START

          2017-02-01 15:23:31,492 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 = 31 AND pd.STATUS IN ('FAILED','WARNING') )

                    WHEN 0 THEN 'SUCCESS'

                    ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 31 AND pd.STATUS IN ('FAILED','WARNING') ) END

                ELSE 'FAILED' END

              WHERE RULE_ID = 5

             

          2017-02-01 15:23:31,496 DEBUG [AIF]: CommData.updateRuleStatus - END

          2017-02-01 15:23:31,496 FATAL [AIF]: Error in COMM Validate Data

          2017-02-01 15:23:31,497 DEBUG [AIF]: Comm.updateProcess - START

          2017-02-01 15:23:31,501 DEBUG [AIF]: Comm.updateProcess - END

          2017-02-01 15:23:31,502 DEBUG [AIF]: The fdmAPI connection has been closed.

          2017-02-01 15:23:31,502 INFO  [AIF]: FDMEE Process End, Process ID: 31

          • 2. Re: Validation error for multiperiod file
            JohnGoodwin

            2017-02-01 15:23:31,367 DEBUG [AIF]: oracle.epm.fm.common.exception.HFMException: EPMHFM-65550: EPMHFM-65550: Angemeldeter Benutzer besitzt keine Zugriffsberechtigung für diese Anwendung: HFM:VCONSOL

              at oracle.epm.fm.hssservice.SecurityWrapper.authenticateUserAndGetInfoInternal(SecurityWrapper.java:426)

             

            The error is "Registered user does not have access to this application" so it sounds like a HFM provisioning issue for the user that is running the load

            • 3. Re: Validation error for multiperiod file
              3355552

              Hi John,

               

              I am using admin user which has all the access.

              • 4. Re: Validation error for multiperiod file
                USER1211

                You would need to ensure that you are loading data to a valid HFM intersection.

                You should consult with your business team to get a valid intersection for your test data file or you can go in HFM and Create a data grid and get to level zero(base level) and ensure the intersection is valid.

                • 5. Re: Validation error for multiperiod file
                  3355552

                  I tried to export and it gives the same error again, keep saying that I dont have the rights to login to VCONSOL....

                  • 6. Re: Validation error for multiperiod file
                    3355552

                    Hi User1211,

                     

                    It is a valid base level as far as I understand. Now i try a different user, and it works,and it shows another error during load.

                     

                    Log file as below:

                    2017-02-01 16:48:39,520 INFO  [AIF]: FDMEE Process: 39, Log Level: 5, Log File: C:\FDMEE\outbox\logs\VCONSOL_39.log

                    2017-02-01 16:48:39,520 INFO  [AIF]: Location     : ALL_VLR (Partitionkey:66)

                    2017-02-01 16:48:39,520 INFO  [AIF]: Period Name  : Jan-2017 (Period Key:31.01.17 00:00)

                    2017-02-01 16:48:39,520 INFO  [AIF]: Category Name: ACT (Category key:3)

                    2017-02-01 16:48:39,521 INFO  [AIF]: Rule Name    : DLR_ALLVLR (Rule ID:5)

                    2017-02-01 16:48:41,271 INFO  [AIF]: FDM Version: 11.1.2.4.210

                    2017-02-01 16:48:41,271 INFO  [AIF]: Log File Encoding: UTF-8

                    2017-02-01 16:48:43,877 INFO  [AIF]: -------START IMPORT STEP-------

                    2017-02-01 16:48:43,951 INFO  [AIF]: -------END IMPORT STEP-------

                    2017-02-01 16:48:44,034 INFO  [AIF]: -------START EXPORT STEP-------

                    2017-02-01 16:48:44,080 DEBUG [AIF]: CommData.exportData - START

                    2017-02-01 16:48:44,086 DEBUG [AIF]: Comm.doScriptInit - START

                    2017-02-01 16:48:44,169 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\FDMEE\inbox, LOCNAME=ALL_VLR, SOURCENAME=File, APPID=3, SOURCEID=1, APPROOTDIR=C:\FDMEE, IMPORTFORMAT=IF_MULTILOAD, SCRIPTSDIR=C:\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=5, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=39, PERIODNAME=Jan-2017, IMPORTMODE=null, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=null, LOCKEY=66, RULENAME=DLR_ALLVLR, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=Merge, CATKEY=3, USERNAME=MBUG, FILEDIR=null, IMPORTFLAG=N, USERLOCALE=null}

                    2017-02-01 16:48:44,177 DEBUG [AIF]: The executeEventScript is set to: YES

                    2017-02-01 16:48:44,177 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE

                    2017-02-01 16:48:44,177 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

                    2017-02-01 16:48:44,177 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

                    2017-02-01 16:48:44,178 DEBUG [AIF]: Comm.doScriptInit - END

                    2017-02-01 16:48:44,178 DEBUG [AIF]: Comm.executeScript - START

                    2017-02-01 16:48:44,178 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefExportToDat.py

                    2017-02-01 16:48:44,182 DEBUG [AIF]: Comm.executeVBScript - START

                    2017-02-01 16:48:44,182 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

                    2017-02-01 16:48:44,182 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefExportToDat.vbs

                    2017-02-01 16:48:44,182 DEBUG [AIF]: Comm.executeVBScript - END

                    2017-02-01 16:48:44,182 DEBUG [AIF]: Comm.executeScript - END

                    2017-02-01 16:48:44,192 DEBUG [AIF]: CommData.getRuleInfo - START

                    2017-02-01 16:48:44,204 DEBUG [AIF]:

                          SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, adim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

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

                          FROM TPOVPARTITION tpp

                          INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                            ON adim.APPLICATION_ID = 3

                          LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                            ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

                          WHERE tpp.PARTITIONKEY = 66

                          AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                          AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                          ORDER BY adim.BALANCE_COLUMN_NAME

                         

                    2017-02-01 16:48:44,209 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVLR', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, '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'VCONSOL', 'RECALCULATE_FLAG': u'N', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'EXPORT_TO_TARGET_FLAG': u'Y', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'IMPGROUPFILETYPE': u'MULTIPER', 'RULE_ID': 5L, 'SOURCE_ADAPTER_FLAG': u'N', 'CALENDAR_ID': None, 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}

                    2017-02-01 16:48:44,213 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}

                    2017-02-01 16:48:44,214 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

                    2017-02-01 16:48:44,215 DEBUG [AIF]: CommData.getRuleInfo - END

                    2017-02-01 16:48:44,222 DEBUG [AIF]: CommData.insertFilePeriods - START

                    2017-02-01 16:48:44,225 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N

                    2017-02-01 16:48:44,225 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 39 AND PARAMETER_TYPE = 'SOURCE_PERIODS'

                    2017-02-01 16:48:44,226 DEBUG [AIF]: Period mapping section: SINGLE-COLUMN

                    2017-02-01 16:48:44,226 DEBUG [AIF]:

                                SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT

                                      ,0 GL_EFFECTIVE_PERIOD_NUM, 0 GL_PERIOD_NUM, '0' GL_PERIOD_NAME, 0 GL_PERIOD_YEAR

                                FROM 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 = 39

                                ORDER BY PERIODKEY

                             

                    2017-02-01 16:48:44,235 INFO  [AIF]: File Name: dummy.txt

                    2017-02-01 16:48:44,236 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, GL_PERIOD_YEAR_CHAR)

                            VALUES (39,'2017-01-31','N',0,'0' ,'0',0,1,'2017','January', 'PROCESS_BAL_IMP_FILE','dummy.txt','PROCESS_BAL_TRANS','Jan-2017','N', 0)

                           

                    2017-02-01 16:48:44,238 DEBUG [AIF]: CommData.insertFilePeriods - END

                    2017-02-01 16:48:44,244 DEBUG [AIF]: CommData.moveData - START

                    2017-02-01 16:48:44,248 DEBUG [AIF]: CommData.getPovList - START

                    2017-02-01 16:48:44,248 DEBUG [AIF]:

                            SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

                                  ,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) 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 = 39

                            ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

                           

                    2017-02-01 16:48:44,255 DEBUG [AIF]: CommData.getPovList - END

                    2017-02-01 16:48:44,257 INFO  [AIF]:

                    Move Data for Period 'Jan-2017'

                    2017-02-01 16:48:44,257 DEBUG [AIF]:

                              UPDATE TDATASEG

                              SET LOADID = 39

                              WHERE PARTITIONKEY = 66

                              AND CATKEY = 3

                              AND RULE_ID = 5

                              AND LOADID < 39

                             

                                AND PERIODKEY = '2017-01-31'

                    2017-02-01 16:48:44,266 DEBUG [AIF]: Number of Rows updated on TDATASEG: 2

                    2017-02-01 16:48:44,266 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

                              39, 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 = 66 AND CATKEY = 3 AND RULE_ID = 5 AND LOADID < 39

                           

                                AND PERIODKEY = '2017-01-31'

                    2017-02-01 16:48:44,267 DEBUG [AIF]: Number of Rows inserted into AIF_APPL_LOAD_AUDIT: 1

                    2017-02-01 16:48:44,268 DEBUG [AIF]: CommData.moveData - END

                    2017-02-01 16:48:44,277 DEBUG [AIF]: CommData.updateWorkflow - START

                    2017-02-01 16:48:44,277 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 = 66 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2017-01-31' AND tlp.RULE_ID = 5 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

                       

                    2017-02-01 16:48:44,278 DEBUG [AIF]:

                            UPDATE TLOGPROCESS

                            SET PROCESSENDTIME=CURRENT_TIMESTAMP

                               ,PROCESSSTATUS=20,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0

                               ,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

                            WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                           

                    2017-02-01 16:48:44,280 DEBUG [AIF]: CommData.updateWorkflow - END

                    2017-02-01 16:48:44,281 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START

                    2017-02-01 16:48:44,283 DEBUG [AIF]:

                            DELETE FROM TDATASEG

                            WHERE LOADID = 39

                           

                              AND (

                               

                            PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND PERIODKEY = '2017-01-31'

                            AND RULE_ID = 5

                            AND VALID_FLAG = 'N'

                           

                              )

                    2017-02-01 16:48:44,284 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0

                    2017-02-01 16:48:44,284 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END

                    2017-02-01 16:48:44,285 DEBUG [AIF]: CommData.updateAppLoadAudit - START

                    2017-02-01 16:48:44,286 DEBUG [AIF]:

                            UPDATE AIF_APPL_LOAD_AUDIT

                            SET EXPORT_TO_TARGET_FLAG = 'Y'

                            WHERE LOADID = 39

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND PERIODKEY= '2017-01-31'

                            AND RULE_ID = 5

                           

                    2017-02-01 16:48:44,287 DEBUG [AIF]: Number of Rows updated on AIF_APPL_LOAD_AUDIT: 1

                    2017-02-01 16:48:44,287 DEBUG [AIF]: CommData.updateAppLoadAudit - END

                    2017-02-01 16:48:44,288 DEBUG [AIF]: CommData.updateWorkflow - START

                    2017-02-01 16:48:44,289 DEBUG [AIF]:

                            UPDATE TLOGPROCESS

                            SET PROCESSENDTIME=CURRENT_TIMESTAMP

                               ,PROCESSSTATUS=21,PROCESSEXP=1

                               ,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_OK_TXT'

                            WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                           

                    2017-02-01 16:48:44,290 DEBUG [AIF]: CommData.updateWorkflow - END

                    2017-02-01 16:48:44,292 DEBUG [AIF]: Comm.executeJythonScript - START

                    2017-02-01 16:48:44,298 INFO  [AIF]: Executing the following script: D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_EXPORT.py

                    2017-02-01 16:48:44,360 DEBUG [AIF]: ************************************************************************************

                    2017-02-01 16:48:44,360 DEBUG [AIF]: *      HFM_EXPORT.py Started for LoadID: 39

                    2017-02-01 16:48:44,360 DEBUG [AIF]: ************************************************************************************

                    2017-02-01 16:48:44,385 DEBUG [AIF]: User Locale is not set. Defaulting to: en_US

                    2017-02-01 16:48:44,567 INFO  [AIF]: Cluster name:  HFMcluster

                    2017-02-01 16:48:44,568 DEBUG [AIF]: getGlobalUserID(): GET_GLOBAL_USER_ID returned no rows for LoadID = 39

                    2017-02-01 16:48:44,568 DEBUG [AIF]: Global User ID:

                    2017-02-01 16:48:44,703 DEBUG [AIF]: Session created on HFM server = WVVARZ0176

                    2017-02-01 16:48:44,706 DEBUG [AIF]: HFM_STICKY_SERVER was saved.

                    2017-02-01 16:48:44,743 DEBUG [AIF]: Session ID = 2b34802d-6cbe-4b18-8850-a29a1f6fac0b

                    2017-02-01 16:48:44,747 DEBUG [AIF]: Connected to: VCONSOL

                    2017-02-01 16:48:44,760 DEBUG [AIF]: importFormatLoadsIcp() = false: IMPORT_FORMAT_LOADS_ICP_QUERY returned no rows for IMPORTFORMAT = IF_MULTILOAD.

                    2017-02-01 16:48:44,761 DEBUG [AIF]: importFormatLoadsIcp() = false: IMPORT_FORMAT_LOADS_ICP_QUERY returned no rows for IMPORTFORMAT = IF_MULTILOAD.

                    2017-02-01 16:48:44,761 DEBUG [AIF]: getActiveTargetDims(true): Executing ACTIVE_TARGET_DIMS_INCLUDE_ATTR_QUERY with APPID = 3

                    2017-02-01 16:48:44,765 DEBUG [AIF]: ***Export data and Journals as data***

                    2017-02-01 16:48:44,843 DEBUG [AIF]: HFM Export Complete.

                    2017-02-01 16:48:44,843 DEBUG [AIF]: ************************************************************************************

                    2017-02-01 16:48:44,843 DEBUG [AIF]: Comm.executeJythonScript - END

                    2017-02-01 16:48:44,843 DEBUG [AIF]: Comm.executeScript - START

                    2017-02-01 16:48:44,843 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftExportToDat.py

                    2017-02-01 16:48:44,843 DEBUG [AIF]: Comm.executeVBScript - START

                    2017-02-01 16:48:44,844 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftExportToDat.vbs

                    2017-02-01 16:48:44,844 DEBUG [AIF]: Comm.executeVBScript - END

                    2017-02-01 16:48:44,844 DEBUG [AIF]: Comm.executeScript - END

                    2017-02-01 16:48:44,844 DEBUG [AIF]: CommData.exportData - END

                    2017-02-01 16:48:44,931 DEBUG [AIF]: HfmData.loadData - START

                    2017-02-01 16:48:44,931 DEBUG [AIF]: Comm.executeScript - START

                    2017-02-01 16:48:44,931 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefLoad.py

                    2017-02-01 16:48:44,932 DEBUG [AIF]: Comm.executeVBScript - START

                    2017-02-01 16:48:44,932 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefLoad.vbs

                    2017-02-01 16:48:44,932 DEBUG [AIF]: Comm.executeVBScript - END

                    2017-02-01 16:48:44,932 DEBUG [AIF]: Comm.executeScript - END

                    2017-02-01 16:48:44,932 DEBUG [AIF]: CommData.getRuleInfo - START

                    2017-02-01 16:48:44,935 DEBUG [AIF]:

                          SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, adim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

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

                          FROM TPOVPARTITION tpp

                          INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                            ON adim.APPLICATION_ID = 3

                          LEFT OUTER JOIN TBHVIMPITEMERPI tiie

                            ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

                          WHERE tpp.PARTITIONKEY = 66

                          AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                          AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                          ORDER BY adim.BALANCE_COLUMN_NAME

                         

                    2017-02-01 16:48:44,940 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'N', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVLR', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, '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'VCONSOL', 'RECALCULATE_FLAG': u'N', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'EXPORT_TO_TARGET_FLAG': u'Y', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'IMPGROUPFILETYPE': u'MULTIPER', 'RULE_ID': 5L, 'SOURCE_ADAPTER_FLAG': u'N', 'CALENDAR_ID': None, 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}

                    2017-02-01 16:48:44,944 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}

                    2017-02-01 16:48:44,944 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

                    2017-02-01 16:48:44,944 DEBUG [AIF]: CommData.getRuleInfo - END

                    2017-02-01 16:48:44,945 DEBUG [AIF]: CommData.getPovList - START

                    2017-02-01 16:48:44,945 DEBUG [AIF]:

                            SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

                                  ,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) 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 = 39

                            ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

                           

                    2017-02-01 16:48:44,951 DEBUG [AIF]: CommData.getPovList - END

                    2017-02-01 16:48:44,951 DEBUG [AIF]: CommData.updateWorkflow - START

                    2017-02-01 16:48:44,951 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 = 66 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2017-01-31' AND tlp.RULE_ID = 5 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

                       

                    2017-02-01 16:48:44,952 DEBUG [AIF]:

                            UPDATE TLOGPROCESS

                            SET PROCESSENDTIME=CURRENT_TIMESTAMP

                               ,PROCESSSTATUS=30,PROCESSENTLOAD=0,PROCESSENTVAL=0

                               ,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

                            WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                           

                    2017-02-01 16:48:44,954 DEBUG [AIF]: CommData.updateWorkflow - END

                    2017-02-01 16:48:44,954 DEBUG [AIF]: Comm.executeJythonScript - START

                    2017-02-01 16:48:44,960 INFO  [AIF]: Executing the following script: D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_LOAD.py

                    2017-02-01 16:48:45,064 INFO  [AIF]: ************************************************************************************

                    2017-02-01 16:48:45,064 INFO  [AIF]: *      HFM_LOAD.py Started for LoadID: 39

                    2017-02-01 16:48:45,064 INFO  [AIF]: ************************************************************************************

                    2017-02-01 16:48:45,064 DEBUG [AIF]: User Locale is not set. Defaulting to: en_US

                    2017-02-01 16:48:45,216 INFO  [AIF]: Cluster name:  HFMcluster

                    2017-02-01 16:48:45,217 DEBUG [AIF]: getGlobalUserID(): GET_GLOBAL_USER_ID returned no rows for LoadID = 39

                    2017-02-01 16:48:45,217 DEBUG [AIF]: Global User ID:

                    2017-02-01 16:48:45,343 DEBUG [AIF]: Using HFM sticky server

                    2017-02-01 16:48:45,343 DEBUG [AIF]: Session created on HFM server = WVVARZ0176 and port number = 9091

                    2017-02-01 16:48:45,357 DEBUG [AIF]: Session ID = b9111e3f-77bd-4801-a4f5-3de8b506b4ba

                    2017-02-01 16:48:45,359 INFO  [AIF]: Connected to: VCONSOL

                    2017-02-01 16:48:45,368 DEBUG [AIF]: importFormatLoadsIcp() = false: IMPORT_FORMAT_LOADS_ICP_QUERY returned no rows for IMPORTFORMAT = IF_MULTILOAD.

                    2017-02-01 16:48:45,415 DEBUG [AIF]: USERACTIVITYCODE_DATA_LOAD |    | USERACTIVITYSTATUS_RUNNING | 0

                    2017-02-01 16:48:47,422 DEBUG [AIF]: USERACTIVITYCODE_DATA_LOAD |   Completed with errors | USERACTIVITYSTATUS_COMPLETED | 100

                    2017-02-01 16:48:49,427 DEBUG [AIF]: Before downloadFileFromRunningTask

                    2017-02-01 16:48:49,437 DEBUG [AIF]: Load data failed.

                    2017-02-01 16:48:49,438 ERROR [AIF]: Load data started: 01.02.2017 16:48:45.

                    2017-02-01 16:48:49,438 ERROR [AIF]: Line: 2, Error: No such member

                    2017-02-01 16:48:49,438 ERROR [AIF]: ACT;2017;January;YTD;111001;<Entity Currency>;FTE;[ICP None];[None];[None];[None];[None];[None];766.100000000000

                    2017-02-01 16:48:49,438 ERROR [AIF]: >>>>>>January

                    2017-02-01 16:48:49,438 ERROR [AIF]:

                    2017-02-01 16:48:49,438 ERROR [AIF]: Line: 3, Error: No such member

                    2017-02-01 16:48:49,438 ERROR [AIF]: ACT;2017;January;YTD;130001;<Entity Currency>;FTE;[ICP None];[None];[None];[None];[None];[None];42.000000000000

                    2017-02-01 16:48:49,438 ERROR [AIF]: >>>>>>January

                    2017-02-01 16:48:49,438 ERROR [AIF]:

                    2017-02-01 16:48:49,438 ERROR [AIF]: Load data completed: 01.02.2017 16:48:45.

                    2017-02-01 16:48:49,473 INFO  [AIF]: ************************************************************************************

                    2017-02-01 16:48:49,473 DEBUG [AIF]: Comm.executeJythonScript - END

                    2017-02-01 16:48:49,474 DEBUG [AIF]:

                        SELECT STATUS

                        FROM AIF_PROCESS_DETAILS

                        WHERE PROCESS_ID = 39 AND ENTITY_TYPE = 'PROCESS_BAL_LOAD_HFM'

                       

                    2017-02-01 16:48:49,481 FATAL [AIF]: Error in HfmData.loadData

                    Traceback (most recent call last):

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

                    RuntimeError: Load Error

                     

                     

                    2017-02-01 16:48:49,481 DEBUG [AIF]: CommData.updateWorkflow - START

                    2017-02-01 16:48:49,481 DEBUG [AIF]:

                            UPDATE TLOGPROCESS

                            SET PROCESSENDTIME=CURRENT_TIMESTAMP

                               ,PROCESSSTATUS=32,PROCESSENTLOAD=0

                               ,PROCESSENTLOADNOTE='AIF_WF_LD_LOAD_ERR'

                            WHERE PARTITIONKEY=66 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=5

                           

                    2017-02-01 16:48:49,483 DEBUG [AIF]: CommData.updateWorkflow - END

                    2017-02-01 16:48:49,483 DEBUG [AIF]: Comm.executeScript - START

                    2017-02-01 16:48:49,484 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftLoad.py

                    2017-02-01 16:48:49,484 DEBUG [AIF]: Comm.executeVBScript - START

                    2017-02-01 16:48:49,484 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftLoad.vbs

                    2017-02-01 16:48:49,484 DEBUG [AIF]: Comm.executeVBScript - END

                    2017-02-01 16:48:49,484 DEBUG [AIF]: Comm.executeScript - END

                    2017-02-01 16:48:49,484 DEBUG [AIF]:

                        SELECT COALESCE(usr.PROFILE_OPTION_VALUE, app.PROFILE_OPTION_VALUE, site.PROFILE_OPTION_VALUE) PROFILE_OPTION_VALUE

                        FROM AIF_PROFILE_OPTIONS po

                        LEFT OUTER JOIN AIF_PROFILE_OPTION_VALUES site

                          ON site.PROFILE_OPTION_NAME = po.PROFILE_OPTION_NAME AND site.LEVEL_ID = 1000 AND site.LEVEL_VALUE = 0 AND site.LEVEL_ID <= po.MAX_LEVEL_ID

                        LEFT OUTER JOIN AIF_PROFILE_OPTION_VALUES app

                          ON app.PROFILE_OPTION_NAME = po.PROFILE_OPTION_NAME AND app.LEVEL_ID = 1005 AND app.LEVEL_VALUE = 3 AND app.LEVEL_ID <= po.MAX_LEVEL_ID

                        LEFT OUTER JOIN AIF_PROFILE_OPTION_VALUES usr

                          ON usr.PROFILE_OPTION_NAME = po.PROFILE_OPTION_NAME AND usr.LEVEL_ID = 1010 AND usr.LEVEL_VALUE = NULL AND usr.LEVEL_ID <= po.MAX_LEVEL_ID

                        WHERE po.PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'

                       

                    2017-02-01 16:48:49,485 DEBUG [AIF]: HFM logFile : C:\FDMEE/outbox/logs/VCONSOL_39_HFM.log

                    2017-02-01 16:48:49,485 DEBUG [AIF]: HFM Log File not found: C:\FDMEE/outbox/logs/VCONSOL_39_HFM.log

                    2017-02-01 16:48:49,545 DEBUG [AIF]: Comm.finalizeProcess - START

                    2017-02-01 16:48:49,546 DEBUG [AIF]: CommData.updateRuleStatus - START

                    2017-02-01 16:48:49,546 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 = 39 AND pd.STATUS IN ('FAILED','WARNING') )

                              WHEN 0 THEN 'SUCCESS'

                              ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 39 AND pd.STATUS IN ('FAILED','WARNING') ) END

                          ELSE 'FAILED' END

                        WHERE RULE_ID = 5

                       

                    2017-02-01 16:48:49,549 DEBUG [AIF]: CommData.updateRuleStatus - END

                    2017-02-01 16:48:49,550 FATAL [AIF]: Error in HFM Load Data

                    2017-02-01 16:48:49,550 DEBUG [AIF]: Comm.updateProcess - START

                    2017-02-01 16:48:49,554 DEBUG [AIF]: Comm.updateProcess - END

                    2017-02-01 16:48:49,554 DEBUG [AIF]: The fdmAPI connection has been closed.

                    2017-02-01 16:48:49,555 INFO  [AIF]: FDMEE Process End, Process ID: 39

                    • 7. Re: Validation error for multiperiod file
                      3355552

                      Hi User 1211,

                       

                      you were right, I put a wrong period category in details instead of Jan-- i put January... , but John was also right that my admin does not have user rights. I am not sure why???

                      After I change the user for non admin user, I can upload the data to VCONSOL.

                       

                      Thx.

                      • 8. Re: Validation error for multiperiod file
                        3355552

                        Hi John, I am moving this conversation to another trail.

                         

                        As it is actually resolved by using another user, but admin user does not work not sure why.

                        Admin has no sufficient right to export data to applications

                         

                        Thanks.