9 Replies Latest reply on Feb 1, 2017 10:22 AM by 3355552

    During Validation FDMEE server always crash

    3355552

      Hi everyone,

       

      I am using csv load file and try to upload multiperiod data to FDMEE, and everytime I do import, it seems to be ok but when it comes to "Validate" part in process details... FDMEE connection always crashed and I need to restart the services.

       

      The data that I uploaded was only one line:

       

      When I opened the log file, the last few errors were:

       

      2017-01-31 16:43:37,837 INFO  [AIF]: Total Data Rows available for Export to Target: 1

      2017-01-31 16:43:37,838 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 14 and parameter_name = 'CHECK_INTERSECTION'

      2017-01-31 16:43:37,843 DEBUG [AIF]: Comm.executeJythonScript - START

      2017-01-31 16:43:37,855 INFO  [AIF]: Executing the following script: D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py

      2017-01-31 16:43:37,972 DEBUG [AIF]: User Locale is not set. Defaulting to: en_US

      2017-01-31 16:43:37,972 DEBUG [AIF]: HFM_VALIDATE.py Started for LoadID: 14

      2017-01-31 16:43:38,705 INFO  [AIF]: Cluster name:  HFMcluster

      2017-01-31 16:43:38,706 DEBUG [AIF]: Global User ID:

      2017-01-31 16:43:38,939 DEBUG [AIF]: Session ID = 7c8a4070-6604-4005-8c10-7eb74c2a852a

      2017-01-31 16:43:39,055 DEBUG [AIF]: Connected to: CONSOLAPP

       

       

      Have anyone face this problem before?

        • 1. Re: During Validation FDMEE server always crash
          ThinkFDM

          Which version of FDMEE are you using?  Can you set the log level to 5 (in System Settings), re-run the integration, and attach the entire process details log?

          • 2. Re: During Validation FDMEE server always crash
            USER1211

            have you opened an oracle Sr?

            Is this a new environment? Was it ever working before?

            What is the exact version of Hyperion(including patch level)?

            Have you spoke to your IT Team about issues with your sever and connection?

            • 3. Re: During Validation FDMEE server always crash
              3355552

              2017-01-31 16:43:14,237 INFO  [AIF]: FDMEE Process: 14, Log Level: 5, Log File: C:\FDMEE\outbox\logs\VCONSOL_14.log

              2017-01-31 16:43:14,242 INFO  [AIF]: Location     : ALL_VLR (Partitionkey:66)

              2017-01-31 16:43:14,243 INFO  [AIF]: Period Name  : Jan-2017 (Period Key:31.01.17 00:00)

              2017-01-31 16:43:14,243 INFO  [AIF]: Category Name: ACT (Category key:3)

              2017-01-31 16:43:14,243 INFO  [AIF]: Rule Name    : DLR_ALLVLR (Rule ID:5)

              2017-01-31 16:43:22,439 INFO  [AIF]: FDM Version: 11.1.2.4.200

              2017-01-31 16:43:22,444 INFO  [AIF]: Log File Encoding: UTF-8

              2017-01-31 16:43:28,294 INFO  [AIF]: -------START IMPORT STEP-------

              2017-01-31 16:43:28,411 DEBUG [AIF]: CommData.preImportData - START

              2017-01-31 16:43:28,420 DEBUG [AIF]: CommData.getRuleInfo - START

              2017-01-31 16:43:28,472 DEBUG [AIF]:

                    SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.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

                    INNER JOIN AIF_DIMENSIONS dim

                      ON dim.DIMENSION_ID = adim.DIMENSION_ID

                    LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                    WHERE tpp.PARTITIONKEY = 66

                    AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                    AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                    ORDER BY adim.BALANCE_COLUMN_NAME

                   

              2017-01-31 16:43:28,484 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVLR', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', '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, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 24L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 21L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 18L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 23L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 26L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 25L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 20L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 22L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'Y', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'MULTIPER', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 5L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 3L, 'IMPTARGETSOURCESYSTEMID': 0L}

              2017-01-31 16:43:28,485 DEBUG [AIF]: CommData.getRuleInfo - END

              2017-01-31 16:43:28,490 DEBUG [AIF]: CommData.insertFilePeriods - START

              2017-01-31 16:43:28,499 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N

              2017-01-31 16:43:28,499 DEBUG [AIF]:

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

                      FROM (

                        SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, 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

                        FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                        INNER JOIN TPOVCATEGORY pc

                          ON pc.CATKEY = brl.CATKEY

                        INNER JOIN TPOVPERIOD_FLAT_V pp

                          ON pp.PERIODFREQ = pc.CATFREQ

                        INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp

                          ON brp.loadid = brl.loadid AND convert(varchar,brp.parameter_value,111) = pp.periodkey

                        WHERE brl.LOADID = 14   

                          AND br.rule_id = brl.rule_id

                          AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')

                          AND brp.parameter_name like 'AMOUNT%'

                        UNION

                        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

                        FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                        INNER JOIN TPOVCATEGORY pc

                          ON pc.CATKEY = brl.CATKEY

                        INNER JOIN TPOVPERIOD_FLAT_V pp

                          ON pp.PERIODFREQ = pc.CATFREQ AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY        

                        WHERE brl.LOADID = 14   

                          AND br.rule_id = brl.rule_id

                          AND br.MULTI_PERIOD_FILE_FLAG in('Y', 'X','E')

                        ) qrslt

                        UNION

                        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

                        FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl

                        INNER JOIN TPOVCATEGORY pc

                          ON pc.CATKEY = brl.CATKEY

                        INNER JOIN TPOVPERIOD_FLAT_V pp

                          ON pp.PERIODFREQ = pc.CATFREQ AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY

                        WHERE brl.LOADID = 14

                          AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )

                          AND br.rule_id = brl.rule_id 

                        ORDER BY PERIODKEY

                       

              2017-01-31 16:43:28,504 INFO  [AIF]: File Name: ImportFormatTemplate9.csv

              2017-01-31 16:43:28,505 INFO  [AIF]: File Name: ImportFormatTemplate9.csv

              2017-01-31 16:43:28,508 DEBUG [AIF]:

                      INSERT INTO AIF_PROCESS_PERIODS (

                        PROCESS_ID, PERIODKEY, ADJUSTMENT_PERIOD_FLAG, GL_PERIOD_YEAR, GL_PERIOD_CODE, GL_PERIOD_NAME, GL_PERIOD_NUM, GL_EFFECTIVE_PERIOD_NUM

                       ,YEARTARGET, PERIODTARGET, IMP_ENTITY_TYPE, IMP_ENTITY_NAME, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME, PRIOR_PERIOD_FLAG)

                      VALUES (14,'2017-01-31','N',0,'0' ,'0',0,1,'2017','January', 'PROCESS_BAL_IMP_FILE','ImportFormatTemplate9.csv','PROCESS_BAL_TRANS','Jan-2017','N')

                     

              2017-01-31 16:43:28,510 DEBUG [AIF]:

                      INSERT INTO AIF_PROCESS_PERIODS (

                        PROCESS_ID, PERIODKEY, ADJUSTMENT_PERIOD_FLAG, GL_PERIOD_YEAR, GL_PERIOD_CODE, GL_PERIOD_NAME, GL_PERIOD_NUM, GL_EFFECTIVE_PERIOD_NUM

                       ,YEARTARGET, PERIODTARGET, IMP_ENTITY_TYPE, IMP_ENTITY_NAME, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME, PRIOR_PERIOD_FLAG)

                      VALUES (14,'2017-02-28','N',0,'0' ,'0',0,2,'2017','February', 'PROCESS_BAL_IMP_FILE','ImportFormatTemplate9.csv','PROCESS_BAL_TRANS','Feb-2017','N')

                     

              2017-01-31 16:43:28,514 DEBUG [AIF]: CommData.insertFilePeriods - END

              2017-01-31 16:43:28,518 DEBUG [AIF]: CommData.getPovList - START

              2017-01-31 16:43:28,518 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 = 14

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

                     

              2017-01-31 16:43:28,525 DEBUG [AIF]: CommData.getPovList - END

              2017-01-31 16:43:28,527 DEBUG [AIF]: CommData.insertImportProcessDetails - START

              2017-01-31 16:43:28,528 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, 'MBUG' 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 = 14

                        ) q

                        ORDER BY ENTITY_NAME_ORDER

                       

              2017-01-31 16:43:28,531 DEBUG [AIF]: CommData.insertImportProcessDetails - END

              2017-01-31 16:43:28,538 DEBUG [AIF]: Comm.doScriptInit - START

              2017-01-31 16:43:28,718 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=14, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate9.csv, LOCKEY=66, RULENAME=DLR_ALLVLR, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=Y, EXPORTMODE=null, CATKEY=3, USERNAME=MBUG, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

              2017-01-31 16:43:28,779 DEBUG [AIF]: Added jar to Classpath: D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\lib\epm-aif-odi-manual.jar

              2017-01-31 16:43:28,813 DEBUG [AIF]: The executeEventScript is set to: YES

              2017-01-31 16:43:28,814 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE

              2017-01-31 16:43:28,814 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

              2017-01-31 16:43:28,814 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

              2017-01-31 16:43:28,814 DEBUG [AIF]: Comm.doScriptInit - END

              2017-01-31 16:43:28,814 DEBUG [AIF]: Comm.executeScript - START

              2017-01-31 16:43:28,814 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefImport.py

              2017-01-31 16:43:28,818 DEBUG [AIF]: Comm.executeVBScript - START

              2017-01-31 16:43:28,845 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

              2017-01-31 16:43:28,845 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefImport.vbs

              2017-01-31 16:43:28,845 DEBUG [AIF]: Comm.executeVBScript - END

              2017-01-31 16:43:28,845 DEBUG [AIF]: Comm.executeScript - END

              2017-01-31 16:43:28,845 DEBUG [AIF]: CommData.preImportData - END

              2017-01-31 16:43:35,789 DEBUG [AIF]: FileData.importData - START

              2017-01-31 16:43:35,789 DEBUG [AIF]: Importing data for load id: 14

              2017-01-31 16:43:35,900 DEBUG [AIF]: CommData.getRuleInfo - START

              2017-01-31 16:43:35,910 DEBUG [AIF]:

                    SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.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

                    INNER JOIN AIF_DIMENSIONS dim

                      ON dim.DIMENSION_ID = adim.DIMENSION_ID

                    LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                    WHERE tpp.PARTITIONKEY = 66

                    AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                    AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                    ORDER BY adim.BALANCE_COLUMN_NAME

                   

              2017-01-31 16:43:35,915 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVLR', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', '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, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 24L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 21L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 18L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 23L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 26L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 25L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 20L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 22L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'Y', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'MULTIPER', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 5L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 3L, 'IMPTARGETSOURCESYSTEMID': 0L}

              2017-01-31 16:43:35,915 DEBUG [AIF]: CommData.getRuleInfo - END

              2017-01-31 16:43:35,917 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N

              2017-01-31 16:43:35,917 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       = 14

                                              AND a.start_periodkey=b.periodkey

                                              AND a.loadid         =c.process_id

                                              AND br.rule_id = a.rule_id

                                             

              2017-01-31 16:43:35,923 DEBUG [AIF]: FileData.py: Importing Text data for load id: 14

              2017-01-31 16:43:35,985 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :C:\FDMEE\outbox\logs\VCONSOL_14.log

              2017-01-31 16:43:35,987 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::14;66:3:5:[NONE]:C:\FDMEE/

              2017-01-31 16:43:35,994 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

              2017-01-31 16:43:36,015 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

              2017-01-31 16:43:36,049 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :C:\FDMEE\outbox\logs\VCONSOL_14.log

              2017-01-31 16:43:36,060 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT1:ImpFieldText=Column=9,10;:StartPos=9:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT2:ImpFieldText=Column=9,10;:StartPos=10:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=4:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=3:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=5:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=6:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=7:SourceClName=null

              2017-01-31 16:43:36,062 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=8:SourceClName=null

              2017-01-31 16:43:36,063 INFO  [AIF]: EPMFDM-140274:Message - File Name ImportFormatTemplate9.csv

              periodKey2017-01-31

              2017-01-31 16:43:36,231 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 14

              PARTITIONKEY: 66

              IMPORT GROUP: IF_MULTILOAD

              FILE TYPE: MULTIPERIOD

              DELIMITER: ;

              SOURCE FILE: ImportFormatTemplate9.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

               

               

              [TC] - [Amount=NN] Entity;Account;ICP;Custom1;Custom2;Custom3;Custom4;Custom5;Jan;Feb

              Rows Loaded: 2

              Rows Rejected: 1

               

              2017-01-31 16:43:36,241 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy

              2017-01-31 16:43:36,241 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

              2017-01-31 16:43:36,241 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 1420170131

              2017-01-31 16:43:36,241 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: ImportFormatTemplate9

              Extension: csv

              2017-01-31 16:43:36,242 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 1420170131.csv

              2017-01-31 16:43:36,243 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: ImportFormatTemplate9.csv

              2017-01-31 16:43:36,243 INFO  [AIF]: EPMFDM-140274:Message - File not deleted: C:\FDMEE\ImportFormatTemplate9.csv

              2017-01-31 16:43:36,295 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

              2017-01-31 16:43:36,295 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 279

              2017-01-31 16:43:36,301 DEBUG [AIF]: FileData.importData - END

              2017-01-31 16:43:36,612 DEBUG [AIF]: CommData.postImportData - START

              2017-01-31 16:43:36,612 DEBUG [AIF]: CommData.getRuleInfo - START

              2017-01-31 16:43:36,616 DEBUG [AIF]:

                    SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.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

                    INNER JOIN AIF_DIMENSIONS dim

                      ON dim.DIMENSION_ID = adim.DIMENSION_ID

                    LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                    WHERE tpp.PARTITIONKEY = 66

                    AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                    AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                    ORDER BY adim.BALANCE_COLUMN_NAME

                   

              2017-01-31 16:43:36,621 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'DLR_ALLVLR', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'IF_MULTILOAD', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', '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, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 24L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 21L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 18L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 23L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 26L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 25L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 20L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 22L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 66L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': u'Y', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'MULTIPER', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 5L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 3L, 'IMPTARGETSOURCESYSTEMID': 0L}

              2017-01-31 16:43:36,621 DEBUG [AIF]: CommData.getRuleInfo - END

              2017-01-31 16:43:36,628 DEBUG [AIF]: CommData.updateTDATASEG_T - START

              2017-01-31 16:43:36,631 DEBUG [AIF]: CommData.getLedgerListAndMap - START

              2017-01-31 16:43:36,632 DEBUG [AIF]: CommData.getLedgerSQL - START

              2017-01-31 16:43:36,632 DEBUG [AIF]: CommData.getLedgerSQL - END

              2017-01-31 16:43:36,632 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-01-31 16:43:36,633 DEBUG [AIF]: CommData.getLedgerListAndMap - END

              2017-01-31 16:43:36,636 DEBUG [AIF]: CommData.getPovList - START

              2017-01-31 16:43:36,637 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 = 14

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

                     

              2017-01-31 16:43:36,643 DEBUG [AIF]: CommData.getPovList - END

              2017-01-31 16:43:36,643 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    = 14

                        AND en.process_id      = pp.process_id

                        AND pp.IMP_ENTITY_NAME = en.file_entity_name

                        order by en.entity_name_order

                       

              2017-01-31 16:43:36,646 INFO  [AIF]:

              Import Data from Source for Period 'Jan-2017'

              2017-01-31 16:43:36,652 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:36,653 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-01-31 16:43:36,655 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-01-31 16:43:36,659 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:36,659 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-01-31 16:43:36,664 DEBUG [AIF]: 

                          UPDATE TDATASEG_T

                          SET AMOUNTX = AMOUNT

                             ,ACCOUNTX = NULL

                             ,ENTITYX = NULL

                             ,ICPX = NULL

                             ,UD1X = NULL

                             ,UD2X = NULL

                             ,UD3X = NULL

                             ,UD4X = NULL

                             ,UD5X = NULL

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

                         

              2017-01-31 16:43:36,665 INFO  [AIF]:     Generic Data Rows Imported from Source: 1

              2017-01-31 16:43:36,666 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 = 14

                            AND PERIODKEY = '2017-01-31'

                           

              2017-01-31 16:43:36,668 INFO  [AIF]: Total Data Rows Imported from Source: 1

              2017-01-31 16:43:36,668 INFO  [AIF]:

              Import Data from Source for Period 'Feb-2017'

              2017-01-31 16:43:36,668 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:36,668 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-02-28' AND tlp.RULE_ID = 5 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

                 

              2017-01-31 16:43:36,669 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-02-28' AND RULE_ID=5

                     

              2017-01-31 16:43:36,671 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:36,671 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-01-31 16:43:36,675 DEBUG [AIF]: 

                          UPDATE TDATASEG_T

                          SET AMOUNTX = AMOUNT

                             ,ACCOUNTX = NULL

                             ,ENTITYX = NULL

                             ,ICPX = NULL

                             ,UD1X = NULL

                             ,UD2X = NULL

                             ,UD3X = NULL

                             ,UD4X = NULL

                             ,UD5X = NULL

                          WHERE TDATASEG_T.LOADID = 14 AND TDATASEG_T.PARTITIONKEY = 66 AND TDATASEG_T.CATKEY = 3 AND TDATASEG_T.PERIODKEY = '2017-02-28'

                         

              2017-01-31 16:43:36,676 INFO  [AIF]:     Generic Data Rows Imported from Source: 1

              2017-01-31 16:43:36,676 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 = 14

                            AND PERIODKEY = '2017-02-28'

                           

              2017-01-31 16:43:36,682 INFO  [AIF]: Total Data Rows Imported from Source: 1

              2017-01-31 16:43:36,682 DEBUG [AIF]: CommData.updateTDATASEG_T - END

              2017-01-31 16:43:36,688 DEBUG [AIF]: Comm.doScriptInit - START

              2017-01-31 16:43:36,769 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=14, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate9.csv, LOCKEY=66, RULENAME=DLR_ALLVLR, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=Y, EXPORTMODE=null, CATKEY=3, USERNAME=MBUG, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

              2017-01-31 16:43:36,776 DEBUG [AIF]: The executeEventScript is set to: YES

              2017-01-31 16:43:36,776 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE

              2017-01-31 16:43:36,776 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

              2017-01-31 16:43:36,776 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

              2017-01-31 16:43:36,776 DEBUG [AIF]: Comm.doScriptInit - END

              2017-01-31 16:43:36,776 DEBUG [AIF]: Comm.executeScript - START

              2017-01-31 16:43:36,776 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftImport.py

              2017-01-31 16:43:36,780 DEBUG [AIF]: Comm.executeVBScript - START

              2017-01-31 16:43:36,780 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

              2017-01-31 16:43:36,780 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftImport.vbs

              2017-01-31 16:43:36,780 DEBUG [AIF]: Comm.executeVBScript - END

              2017-01-31 16:43:36,780 DEBUG [AIF]: Comm.executeScript - END

              2017-01-31 16:43:36,780 DEBUG [AIF]: CommData.postImportData - END

              2017-01-31 16:43:37,118 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

              2017-01-31 16:43:37,118 DEBUG [AIF]: Comm.executeScript - START

              2017-01-31 16:43:37,118 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcLogicGrp.py

              2017-01-31 16:43:37,118 DEBUG [AIF]: Comm.executeVBScript - START

              2017-01-31 16:43:37,119 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcLogicGrp.vbs

              2017-01-31 16:43:37,119 DEBUG [AIF]: Comm.executeVBScript - END

              2017-01-31 16:43:37,119 DEBUG [AIF]: Comm.executeScript - END

              2017-01-31 16:43:37,121 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

              2017-01-31 16:43:37,121 DEBUG [AIF]:

                      select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

                      from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

                      and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

                     

              2017-01-31 16:43:37,124 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

              2017-01-31 16:43:37,125 DEBUG [AIF]: Comm.executeScript - START

              2017-01-31 16:43:37,126 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcLogicGrp.py

              2017-01-31 16:43:37,126 DEBUG [AIF]: Comm.executeVBScript - START

              2017-01-31 16:43:37,127 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcLogicGrp.vbs

              2017-01-31 16:43:37,127 DEBUG [AIF]: Comm.executeVBScript - END

              2017-01-31 16:43:37,127 DEBUG [AIF]: Comm.executeScript - END

              2017-01-31 16:43:37,127 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

              2017-01-31 16:43:37,155 DEBUG [AIF]: CommData.mapData - START

              2017-01-31 16:43:37,157 DEBUG [AIF]: CommData.insertTransProcessDetails - START

              2017-01-31 16:43:37,157 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, 'MBUG' 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 = 14

                          AND PRIOR_PERIOD_FLAG = 'N'

                          GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

                        ) q

                        ORDER BY ENTITY_NAME_ORDER

                       

              2017-01-31 16:43:37,159 DEBUG [AIF]: CommData.insertTransProcessDetails - END

              2017-01-31 16:43:37,163 DEBUG [AIF]:

                      DELETE FROM TDATAMAP_T

                      WHERE LOADID < 14

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

                     

              2017-01-31 16:43:37,164 DEBUG [AIF]:

                      DELETE FROM TDATASEG_T

                      WHERE LOADID < 14

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

                     

              2017-01-31 16:43:37,165 DEBUG [AIF]:

                      DELETE FROM AIF_PROCESS_PERIODS

                      WHERE PROCESS_ID < 14

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

                     

              2017-01-31 16:43:37,169 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

              2017-01-31 16:43:37,170 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

              2017-01-31 16:43:37,170 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-01-31 16:43:37,171 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

              2017-01-31 16:43:37,173 INFO  [AIF]: Processing Mappings from Parent Location: VLRGROUP

              2017-01-31 16:43:37,173 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 14, 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 tdm

                      WHERE PARTITIONKEY = 82

                      AND ( RULE_ID IS NULL OR RULE_ID = 5 )

                      AND ( TDATAMAPTYPE = 'ERP'

                            OR

                            ( TDATAMAPTYPE = 'MULTIDIM'

                              AND EXISTS ( SELECT 1

                                           FROM TDATAMAP multidim

                                           WHERE multidim.PARTITIONKEY = tdm.PARTITIONKEY

                                           AND multidim.TDATAMAPTYPE = 'ERP'

                                           AND multidim.DATAKEY = tdm.TARGKEY )

                            )

                          )

                     

              2017-01-31 16:43:37,175 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 8

              2017-01-31 16:43:37,228 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

              2017-01-31 16:43:37,228 DEBUG [AIF]: Comm.executeScript - START

              2017-01-31 16:43:37,229 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcMap.py

              2017-01-31 16:43:37,229 DEBUG [AIF]: Comm.executeVBScript - START

              2017-01-31 16:43:37,229 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcMap.vbs

              2017-01-31 16:43:37,229 DEBUG [AIF]: Comm.executeVBScript - END

              2017-01-31 16:43:37,229 DEBUG [AIF]: Comm.executeScript - END

              2017-01-31 16:43:37,230 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 = 14

                      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 = 14

                      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-01-31 16:43:37,239 INFO  [AIF]:

              Map Data for Period 'Jan-2017'

              2017-01-31 16:43:37,240 DEBUG [AIF]: Comm.updateProcessDetail - START

              2017-01-31 16:43:37,241 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 ('MBUG' IS NULL) THEN LAST_UPDATED_BY ELSE 'MBUG' END

                     ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

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

                 

              2017-01-31 16:43:37,244 DEBUG [AIF]: Comm.updateProcessDetail - END

              2017-01-31 16:43:37,247 DEBUG [AIF]:

                    SELECT COUNT(*) ROW_COUNT

                    FROM TDATASEG_T

                    WHERE LOADID = 14

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

                   

              2017-01-31 16:43:37,248 INFO  [AIF]:

              Processing Mappings for Column 'ACCOUNT'

              2017-01-31 16:43:37,248 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET ACCOUNTX = ACCOUNT

                               ,ACCOUNTR = 1

                               ,ACCOUNTF = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,249 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ACCOUNT' (LIKE): 1

              2017-01-31 16:43:37,252 INFO  [AIF]:

              Processing Mappings for Column 'ENTITY'

              2017-01-31 16:43:37,252 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET ENTITYX = ENTITY

                               ,ENTITYR = 4

                               ,ENTITYF = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (ENTITYX IS NULL OR ENTITYX = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,254 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ENTITY' (LIKE): 1

              2017-01-31 16:43:37,255 INFO  [AIF]:

              Processing Mappings for Column 'ICP'

              2017-01-31 16:43:37,255 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET ICPX = ICP

                               ,ICPR = 5

                               ,ICPF = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (ICPX IS NULL OR ICPX = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,256 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ICP' (LIKE): 1

              2017-01-31 16:43:37,258 INFO  [AIF]:

              Processing Mappings for Column 'UD1'

              2017-01-31 16:43:37,259 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD1X = UD1

                               ,UD1R = 2

                               ,UD1F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD1X IS NULL OR UD1X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,260 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ACCDET' (LIKE): 1

              2017-01-31 16:43:37,261 INFO  [AIF]:

              Processing Mappings for Column 'UD2'

              2017-01-31 16:43:37,261 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD2X = UD2

                               ,UD2R = 6

                               ,UD2F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD2X IS NULL OR UD2X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,262 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_NATURE' (LIKE): 1

              2017-01-31 16:43:37,266 INFO  [AIF]:

              Processing Mappings for Column 'UD3'

              2017-01-31 16:43:37,266 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD3X = UD3

                               ,UD3R = 7

                               ,UD3F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD3X IS NULL OR UD3X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,267 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_REGIONS' (LIKE): 1

              2017-01-31 16:43:37,268 INFO  [AIF]:

              Processing Mappings for Column 'UD4'

              2017-01-31 16:43:37,268 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD4X = UD4

                               ,UD4R = 3

                               ,UD4F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD4X IS NULL OR UD4X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,269 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_APPENDIX' (LIKE): 1

              2017-01-31 16:43:37,270 INFO  [AIF]:

              Processing Mappings for Column 'UD5'

              2017-01-31 16:43:37,270 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD5X = UD5

                               ,UD5R = 8

                               ,UD5F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD5X IS NULL OR UD5X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-01-31'

              2017-01-31 16:43:37,271 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_SSTORE' (LIKE): 1

              2017-01-31 16:43:37,273 DEBUG [AIF]: Comm.updateProcessDetail - START

              2017-01-31 16:43:37,273 DEBUG [AIF]:

                  UPDATE AIF_PROCESS_DETAILS

                  SET STATUS = 'SUCCESS'

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

                     ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

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

                     ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

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

                 

              2017-01-31 16:43:37,275 DEBUG [AIF]: Comm.updateProcessDetail - END

              2017-01-31 16:43:37,275 INFO  [AIF]:

              Map Data for Period 'Feb-2017'

              2017-01-31 16:43:37,275 DEBUG [AIF]: Comm.updateProcessDetail - START

              2017-01-31 16:43:37,275 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 ('MBUG' IS NULL) THEN LAST_UPDATED_BY ELSE 'MBUG' END

                     ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                  WHERE PROCESS_ID = 14 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Feb-2017'

                 

              2017-01-31 16:43:37,278 DEBUG [AIF]: Comm.updateProcessDetail - END

              2017-01-31 16:43:37,279 DEBUG [AIF]:

                    SELECT COUNT(*) ROW_COUNT

                    FROM TDATASEG_T

                    WHERE LOADID = 14

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

                   

              2017-01-31 16:43:37,280 INFO  [AIF]:

              Processing Mappings for Column 'ACCOUNT'

              2017-01-31 16:43:37,280 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET ACCOUNTX = ACCOUNT

                               ,ACCOUNTR = 1

                               ,ACCOUNTF = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,281 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ACCOUNT' (LIKE): 1

              2017-01-31 16:43:37,283 INFO  [AIF]:

              Processing Mappings for Column 'ENTITY'

              2017-01-31 16:43:37,283 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET ENTITYX = ENTITY

                               ,ENTITYR = 4

                               ,ENTITYF = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (ENTITYX IS NULL OR ENTITYX = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,285 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ENTITY' (LIKE): 1

              2017-01-31 16:43:37,301 INFO  [AIF]:

              Processing Mappings for Column 'ICP'

              2017-01-31 16:43:37,301 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET ICPX = ICP

                               ,ICPR = 5

                               ,ICPF = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (ICPX IS NULL OR ICPX = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,303 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ICP' (LIKE): 1

              2017-01-31 16:43:37,311 INFO  [AIF]:

              Processing Mappings for Column 'UD1'

              2017-01-31 16:43:37,311 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD1X = UD1

                               ,UD1R = 2

                               ,UD1F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD1X IS NULL OR UD1X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,312 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_ACCDET' (LIKE): 1

              2017-01-31 16:43:37,320 INFO  [AIF]:

              Processing Mappings for Column 'UD2'

              2017-01-31 16:43:37,320 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD2X = UD2

                               ,UD2R = 6

                               ,UD2F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD2X IS NULL OR UD2X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,321 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_NATURE' (LIKE): 1

              2017-01-31 16:43:37,326 INFO  [AIF]:

              Processing Mappings for Column 'UD3'

              2017-01-31 16:43:37,326 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD3X = UD3

                               ,UD3R = 7

                               ,UD3F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD3X IS NULL OR UD3X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,327 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_REGIONS' (LIKE): 1

              2017-01-31 16:43:37,336 INFO  [AIF]:

              Processing Mappings for Column 'UD4'

              2017-01-31 16:43:37,336 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD4X = UD4

                               ,UD4R = 3

                               ,UD4F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD4X IS NULL OR UD4X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,337 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_APPENDIX' (LIKE): 1

              2017-01-31 16:43:37,360 INFO  [AIF]:

              Processing Mappings for Column 'UD5'

              2017-01-31 16:43:37,360 DEBUG [AIF]:

                            UPDATE TDATASEG_T

                            SET UD5X = UD5

                               ,UD5R = 8

                               ,UD5F = 3

                            WHERE LOADID = 14

                            AND PARTITIONKEY = 66

                            AND CATKEY = 3

                            AND (UD5X IS NULL OR UD5X = '')

                            AND (1=1)

                            AND PERIODKEY = '2017-02-28'

              2017-01-31 16:43:37,361 INFO  [AIF]: Data Rows Updated by Location Mapping '01_LI_SSTORE' (LIKE): 1

              2017-01-31 16:43:37,375 DEBUG [AIF]: Comm.updateProcessDetail - START

              2017-01-31 16:43:37,375 DEBUG [AIF]:

                  UPDATE AIF_PROCESS_DETAILS

                  SET STATUS = 'SUCCESS'

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

                     ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

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

                     ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                  WHERE PROCESS_ID = 14 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Feb-2017'

                 

              2017-01-31 16:43:37,399 DEBUG [AIF]: Comm.updateProcessDetail - END

              2017-01-31 16:43:37,399 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

              2017-01-31 16:43:37,401 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ATTR14 = DATAKEY

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

                   

              2017-01-31 16:43:37,429 DEBUG [AIF]:

                    UPDATE TDATASEG_T

                    SET ATTR14 = DATAKEY

                    WHERE LOADID = 14 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-02-28'

                   

              2017-01-31 16:43:37,457 DEBUG [AIF]: CommData.updateYtdAmounts - START

              2017-01-31 16:43:37,460 DEBUG [AIF]: CommData.getLedgerListAndMap - START

              2017-01-31 16:43:37,461 DEBUG [AIF]: CommData.getLedgerSQL - START

              2017-01-31 16:43:37,461 DEBUG [AIF]: CommData.getLedgerSQL - END

              2017-01-31 16:43:37,461 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-01-31 16:43:37,462 DEBUG [AIF]: CommData.getLedgerListAndMap - END

              2017-01-31 16:43:37,462 DEBUG [AIF]:

                          SELECT brl.PARTITIONKEY, brl.CATKEY, pprd.YEARTARGET, pprd.PERIODTARGET, pprd.SOURCE_LEDGER_ID

                          FROM AIF_BAL_RULE_LOADS brl

                              ,AIF_PROCESS_PERIODS pprd

                          WHERE brl.LOADID = 14

                          AND pprd.PROCESS_ID = brl.LOADID

                          AND pprd.PRIOR_PERIOD_FLAG = 'N'

                          GROUP BY brl.PARTITIONKEY, brl.CATKEY, pprd.YEARTARGET, pprd.PERIODTARGET, pprd.SOURCE_LEDGER_ID

                          HAVING COUNT(*) > 1

                         

              2017-01-31 16:43:37,463 DEBUG [AIF]: CommData.updateYtdAmounts - END

              2017-01-31 16:43:37,476 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

              2017-01-31 16:43:37,476 INFO  [AIF]:

              Stage Data for Period 'Jan-2017'

              2017-01-31 16:43:37,476 DEBUG [AIF]:

                      DELETE FROM TDATAMAPSEG

                      WHERE PARTITIONKEY = 66

                      AND CATKEY = 3

                      AND PERIODKEY = '2017-01-31'

                      AND ( TDATAMAPTYPE = 'ERP'

                            OR

                            ( TDATAMAPTYPE = 'MULTIDIM'

                              AND EXISTS ( SELECT 1

                                           FROM TDATAMAPSEG parent

                                           WHERE parent.PARTITIONKEY = TDATAMAPSEG.PARTITIONKEY

                                           AND parent.DATAKEY = TDATAMAPSEG.TARGKEY

                                           AND parent.CATKEY = TDATAMAPSEG.CATKEY

                                           AND parent.PERIODKEY = TDATAMAPSEG.PERIODKEY

                                           AND parent.TDATAMAPTYPE = 'ERP' )

                            )

                          )

                     

              2017-01-31 16:43:37,478 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 8

              2017-01-31 16:43:37,478 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 = 14

                     

              2017-01-31 16:43:37,480 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 8

              2017-01-31 16:43:37,480 DEBUG [AIF]:

                          DELETE FROM TDATASEG

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

                         

              2017-01-31 16:43:37,481 INFO  [AIF]: Number of Rows deleted from TDATASEG: 2

              2017-01-31 16:43:37,481 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-01-31 16:43:37,482 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

              2017-01-31 16:43:37,482 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-01-31 16:43:37,483 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

              2017-01-31 16:43:37,484 DEBUG [AIF]:

                        INSERT INTO TDATASEG (

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

                          ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, 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, 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 = 14 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31'

                       

              2017-01-31 16:43:37,486 INFO  [AIF]: Number of Rows inserted into TDATASEG: 1

              2017-01-31 16:43:37,486 DEBUG [AIF]:

                      DELETE FROM TDATASEG_T

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

                     

              2017-01-31 16:43:37,487 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 1

              2017-01-31 16:43:37,494 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:37,495 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-01-31 16:43:37,504 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:37,504 INFO  [AIF]:

              Stage Data for Period 'Feb-2017'

              2017-01-31 16:43:37,504 DEBUG [AIF]:

                      DELETE FROM TDATAMAPSEG

                      WHERE PARTITIONKEY = 66

                      AND CATKEY = 3

                      AND PERIODKEY = '2017-02-28'

                      AND ( TDATAMAPTYPE = 'ERP'

                            OR

                            ( TDATAMAPTYPE = 'MULTIDIM'

                              AND EXISTS ( SELECT 1

                                           FROM TDATAMAPSEG parent

                                           WHERE parent.PARTITIONKEY = TDATAMAPSEG.PARTITIONKEY

                                           AND parent.DATAKEY = TDATAMAPSEG.TARGKEY

                                           AND parent.CATKEY = TDATAMAPSEG.CATKEY

                                           AND parent.PERIODKEY = TDATAMAPSEG.PERIODKEY

                                           AND parent.TDATAMAPTYPE = 'ERP' )

                            )

                          )

                     

              2017-01-31 16:43:37,506 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 8

              2017-01-31 16:43:37,506 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-02-28', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                             WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

                      FROM TDATAMAP_T

                      WHERE LOADID = 14

                     

              2017-01-31 16:43:37,508 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 8

              2017-01-31 16:43:37,508 DEBUG [AIF]:

                      DELETE FROM TDATAMAP_T

                      WHERE LOADID = 14

                     

              2017-01-31 16:43:37,509 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 8

              2017-01-31 16:43:37,509 DEBUG [AIF]:

                          DELETE FROM TDATASEG

                          WHERE LOADID < 14 AND PARTITIONKEY = 66 AND CATKEY = 3 AND RULE_ID = 5 AND PERIODKEY = '2017-02-28'

                         

              2017-01-31 16:43:37,510 INFO  [AIF]: Number of Rows deleted from TDATASEG: 0

              2017-01-31 16:43:37,510 DEBUG [AIF]:

                          DELETE FROM TDATAMEMOITEMS

                          WHERE PARTITIONKEY = 66 AND PERIODKEY = '2017-02-28' AND CATKEY = 3 AND RULE_ID = 5

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

                         

              2017-01-31 16:43:37,511 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

              2017-01-31 16:43:37,511 DEBUG [AIF]:

                          DELETE FROM TDATAARCHIVE

                          WHERE PARTITIONKEY = 66 AND PERIODKEY = '2017-02-28' 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-01-31 16:43:37,512 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

              2017-01-31 16:43:37,512 DEBUG [AIF]:

                        INSERT INTO TDATASEG (

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

                          ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, 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, 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 = 14 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-02-28'

                       

              2017-01-31 16:43:37,514 INFO  [AIF]: Number of Rows inserted into TDATASEG: 1

              2017-01-31 16:43:37,514 DEBUG [AIF]:

                      DELETE FROM TDATASEG_T

                      WHERE LOADID = 14 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-02-28'

                     

              2017-01-31 16:43:37,515 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 1

              2017-01-31 16:43:37,515 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:37,516 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-02-28' AND RULE_ID=5

                     

              2017-01-31 16:43:37,526 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:37,526 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

              2017-01-31 16:43:37,526 DEBUG [AIF]: Comm.executeScript - START

              2017-01-31 16:43:37,527 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcMap.py

              2017-01-31 16:43:37,527 DEBUG [AIF]: Comm.executeVBScript - START

              2017-01-31 16:43:37,527 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcMap.vbs

              2017-01-31 16:43:37,527 DEBUG [AIF]: Comm.executeVBScript - END

              2017-01-31 16:43:37,527 DEBUG [AIF]: Comm.executeScript - END

              2017-01-31 16:43:37,527 DEBUG [AIF]: CommData.mapData - END

              2017-01-31 16:43:37,587 INFO  [AIF]: -------END IMPORT STEP-------

              2017-01-31 16:43:37,660 INFO  [AIF]: -------START VALIDATE STEP-------

              2017-01-31 16:43:37,767 DEBUG [AIF]: CommData.validateData - START

              2017-01-31 16:43:37,767 DEBUG [AIF]: Comm.executeScript - START

              2017-01-31 16:43:37,768 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefValidate.py

              2017-01-31 16:43:37,768 DEBUG [AIF]: Comm.executeVBScript - START

              2017-01-31 16:43:37,769 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefValidate.vbs

              2017-01-31 16:43:37,769 DEBUG [AIF]: Comm.executeVBScript - END

              2017-01-31 16:43:37,769 DEBUG [AIF]: Comm.executeScript - END

              2017-01-31 16:43:37,775 DEBUG [AIF]: CommMap.validateData - START

              2017-01-31 16:43:37,777 INFO  [AIF]:

              Validate Data Mappings for Period 'Jan-2017'

              2017-01-31 16:43:37,778 DEBUG [AIF]:

                    SELECT COUNT(*) ROW_COUNT

                    FROM TDATASEG

                    WHERE LOADID = 14

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

                   

              2017-01-31 16:43:37,779 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:37,779 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-01-31 16:43:37,780 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-01-31 16:43:37,792 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:37,792 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 = 14 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-01-31'

                              AND VALID_FLAG = 'Y'

                              AND CALCACCTTYPE > 0

                             

              2017-01-31 16:43:37,795 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:37,795 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-01-31 16:43:37,813 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:37,814 INFO  [AIF]: Total Data Rows available for Export to Target: 1

              2017-01-31 16:43:37,815 INFO  [AIF]:

              Validate Data Mappings for Period 'Feb-2017'

              2017-01-31 16:43:37,815 DEBUG [AIF]:

                    SELECT COUNT(*) ROW_COUNT

                    FROM TDATASEG

                    WHERE LOADID = 14

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

                   

              2017-01-31 16:43:37,816 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:37,816 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-02-28' AND tlp.RULE_ID = 5 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

                 

              2017-01-31 16:43:37,818 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-02-28' AND RULE_ID=5

                     

              2017-01-31 16:43:37,824 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:37,824 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 = 14 AND PARTITIONKEY = 66 AND CATKEY = 3 AND PERIODKEY = '2017-02-28'

                              AND VALID_FLAG = 'Y'

                              AND CALCACCTTYPE > 0

                             

              2017-01-31 16:43:37,826 DEBUG [AIF]: CommData.updateWorkflow - START

              2017-01-31 16:43:37,826 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-02-28' AND RULE_ID=5

                     

              2017-01-31 16:43:37,832 DEBUG [AIF]: CommData.updateWorkflow - END

              2017-01-31 16:43:37,832 INFO  [AIF]: Total Data Rows available for Export to Target: 1

              2017-01-31 16:43:37,832 DEBUG [AIF]: CommMap.validateData - END

              2017-01-31 16:43:37,834 INFO  [AIF]:

              Validate Data Members for Period 'Jan-2017'

              2017-01-31 16:43:37,834 DEBUG [AIF]:

                    SELECT COUNT(*) ROW_COUNT

                    FROM TDATASEG

                    WHERE LOADID = 14

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

                   

              2017-01-31 16:43:37,835 INFO  [AIF]: Total Data Rows available for Export to Target: 1

              2017-01-31 16:43:37,836 INFO  [AIF]:

              Validate Data Members for Period 'Feb-2017'

              2017-01-31 16:43:37,836 DEBUG [AIF]:

                    SELECT COUNT(*) ROW_COUNT

                    FROM TDATASEG

                    WHERE LOADID = 14

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

                   

              2017-01-31 16:43:37,837 INFO  [AIF]: Total Data Rows available for Export to Target: 1

              2017-01-31 16:43:37,838 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 14 and parameter_name = 'CHECK_INTERSECTION'

              2017-01-31 16:43:37,843 DEBUG [AIF]: Comm.executeJythonScript - START

              2017-01-31 16:43:37,855 INFO  [AIF]: Executing the following script: D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py

              2017-01-31 16:43:37,972 DEBUG [AIF]: User Locale is not set. Defaulting to: en_US

              2017-01-31 16:43:37,972 DEBUG [AIF]: HFM_VALIDATE.py Started for LoadID: 14

              2017-01-31 16:43:38,705 INFO  [AIF]: Cluster name:  HFMcluster

              2017-01-31 16:43:38,706 DEBUG [AIF]: Global User ID:

              2017-01-31 16:43:38,939 DEBUG [AIF]: Session ID = 7c8a4070-6604-4005-8c10-7eb74c2a852a

              2017-01-31 16:43:39,055 DEBUG [AIF]: Connected to: VCONSOL

              • 4. Re: During Validation FDMEE server always crash
                3355552

                Yes this is totally a new environment. I havent try to raised any SR yet, as I am not sure if it is a bug, or it is only from my side that did not setup the environment properly.

                 

                FDMEE version is :11.1.2.4.200.012

                • 5. Re: During Validation FDMEE server always crash
                  JohnGoodwin

                  There is a bug that can cause the FDMEE web app to crash at the validate stage which has been fixed in 11.1.2.4.210, maybe you are seeing the same issue.

                   

                  Cheers

                   

                  John

                  • 6. Re: During Validation FDMEE server always crash
                    ThinkFDM

                    Is this the 1st integration you've set up?  Have you successfully used this instance of FDMEE for any data loads?  If not, I'd say you gotta take a closer look at your install.  Don't see an specific errors in the process details log you provided.

                    • 7. Re: During Validation FDMEE server always crash
                      3355552

                      Ok. let me check with our infra team to patch , and will inform you all if it is really the issue of validation.

                       

                      Is there already Oracle SR on this before that mentioned that it is a bug? Any link will be great.

                      • 8. Re: During Validation FDMEE server always crash
                        USER1211

                        Yes let us know how you make out with your Install team and also your Oracle SR.

                         

                        John G already provided you guidance about a bug fix in patch FDMEE 11.1.2.4.210

                        • 9. Re: During Validation FDMEE server always crash
                          3355552

                          we have patched the environment and at least now the validation works instead of giving crashing the whole FDMEE system.

                           

                          No the validation error comes out and I post it here:

                          Validation error for multiperiod file