3 Replies Latest reply on Feb 13, 2017 7:28 PM by 3355552

    Jython in handling null Amount

    3355552

      Hi,

       

      One of my customer is using FDMEE latest patch 210 and would like to subtract Debit-Credit.

       

      I use the Jython code below to subtract debit-credit and put it into AMOUNT dimension:

      def DRCR_AMOUNT(strField, strRecord):

          strField=strRecord.split(";")

          strAmountDR=strField[8].strip()

          strAmountCR=strField[9].strip()

          strResult=strAmountDR-strAmountCR

          return strResult

       

      This is how my loadfile look like(.csv)

      I applied the Jython script it to the import format:

       

       

       

       

      But whenever I import my load file, it keeps complaining that it cannot recognize the NULL value:

       

       

      Error Evaluating scriptnullorg.python.core.PyException.fillInStackTrace

       

      As you have seen, I actually put NZP in AMOUNT import format to tell the FDMEE that there is a value there which is 0, not NULL.

       

      Any idea how to bypass this NULL problem? Or maybe I understand the ERROR wrongly?

       

       

        • 1. Re: Jython in handling null Amount
          3355552

          Full log script as below, maybe it is not the null problem either--not really sure about that anymore, just now trying to take off the 0 value and change it to 2 instead.. but still generate same error:

           

          2017-02-13 12:13:04,425 INFO  [AIF]: FDMEE Process: 70, Log Level: 5, Log File: C:\FDMEE\outbox\logs\VCONSOL_70.log

          2017-02-13 12:13:04,425 INFO  [AIF]: Location     : TEST (Partitionkey:83)

          2017-02-13 12:13:04,425 INFO  [AIF]: Period Name  : Jan-2017 (Period Key:31.01.17 00:00)

          2017-02-13 12:13:04,425 INFO  [AIF]: Category Name: ACT (Category key:3)

          2017-02-13 12:13:04,425 INFO  [AIF]: Rule Name    : r_dlr_test (Rule ID:25)

          2017-02-13 12:13:10,224 INFO  [AIF]: FDM Version: 11.1.2.4.210

          2017-02-13 12:13:10,224 INFO  [AIF]: Log File Encoding: UTF-8

          2017-02-13 12:13:13,550 INFO  [AIF]: -------START IMPORT STEP-------

          2017-02-13 12:13:13,967 DEBUG [AIF]: CommData.preImportData - START

          2017-02-13 12:13:13,977 DEBUG [AIF]: CommData.getRuleInfo - START

          2017-02-13 12:13:13,985 DEBUG [AIF]:

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

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

                FROM TPOVPARTITION tpp

                INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                  ON adim.APPLICATION_ID = 3

                LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                WHERE tpp.PARTITIONKEY = 83

                AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                ORDER BY adim.BALANCE_COLUMN_NAME

               

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

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

          2017-02-13 12:13:13,995 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

          2017-02-13 12:13:13,995 DEBUG [AIF]: CommData.getRuleInfo - END

          2017-02-13 12:13:14,001 DEBUG [AIF]: CommData.insertFilePeriods - START

          2017-02-13 12:13:14,005 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N

          2017-02-13 12:13:14,005 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 70 AND PARAMETER_TYPE = 'SOURCE_PERIODS'

          2017-02-13 12:13:14,006 DEBUG [AIF]: Period mapping section: SINGLE-COLUMN

          2017-02-13 12:13:14,006 DEBUG [AIF]:

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

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

                      FROM AIF_BAL_RULE_LOADS brl

                      INNER JOIN TPOVCATEGORY pc

                        ON pc.CATKEY = brl.CATKEY

                  INNER JOIN TPOVPERIOD_FLAT_V pp

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

                      WHERE brl.LOADID = 70

                      ORDER BY PERIODKEY

                   

          2017-02-13 12:13:14,015 INFO  [AIF]: File Name: ImportFormatTemplate17_2.csv

          2017-02-13 12:13:14,016 DEBUG [AIF]:

                  INSERT INTO AIF_PROCESS_PERIODS (

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

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

                  VALUES (70,'2017-01-31','N',0,'0' ,'0',0,1,'2017','Jan', 'PROCESS_BAL_IMP_FILE','ImportFormatTemplate17_2.csv','PROCESS_BAL_TRANS','Jan-2017','N', 0)

                 

          2017-02-13 12:13:14,054 DEBUG [AIF]: CommData.insertFilePeriods - END

          2017-02-13 12:13:14,058 DEBUG [AIF]: CommData.getPovList - START

          2017-02-13 12:13:14,058 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 = 70

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

                 

          2017-02-13 12:13:14,065 DEBUG [AIF]: CommData.getPovList - END

          2017-02-13 12:13:14,067 DEBUG [AIF]: CommData.insertImportProcessDetails - START

          2017-02-13 12:13:14,068 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 = 70

                    ) q

                    ORDER BY ENTITY_NAME_ORDER

                   

          2017-02-13 12:13:14,088 DEBUG [AIF]: CommData.insertImportProcessDetails - END

          2017-02-13 12:13:14,095 DEBUG [AIF]: Comm.doScriptInit - START

          2017-02-13 12:13:14,175 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\FDMEE\inbox, LOCNAME=TEST, SOURCENAME=File, APPID=3, SOURCEID=1, APPROOTDIR=C:\FDMEE, IMPORTFORMAT=Test, SCRIPTSDIR=C:\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=25, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=70, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate17_2.csv, LOCKEY=83, RULENAME=r_dlr_test, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=MBUG, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

          2017-02-13 12:13:14,183 DEBUG [AIF]: The executeEventScript is set to: YES

          2017-02-13 12:13:14,183 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE

          2017-02-13 12:13:14,183 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

          2017-02-13 12:13:14,183 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

          2017-02-13 12:13:14,183 DEBUG [AIF]: Comm.doScriptInit - END

          2017-02-13 12:13:14,183 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:14,183 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefImport.py

          2017-02-13 12:13:14,187 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:14,187 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

          2017-02-13 12:13:14,187 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefImport.vbs

          2017-02-13 12:13:14,188 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:14,188 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:14,188 DEBUG [AIF]: CommData.preImportData - END

          2017-02-13 12:13:23,393 DEBUG [AIF]: FileData.importData - START

          2017-02-13 12:13:23,393 DEBUG [AIF]: Importing data for load id: 70

          2017-02-13 12:13:23,403 DEBUG [AIF]: CommData.getRuleInfo - START

          2017-02-13 12:13:23,411 DEBUG [AIF]:

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

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

                FROM TPOVPARTITION tpp

                INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                  ON adim.APPLICATION_ID = 3

                LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                WHERE tpp.PARTITIONKEY = 83

                AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                ORDER BY adim.BALANCE_COLUMN_NAME

               

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

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

          2017-02-13 12:13:23,420 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

          2017-02-13 12:13:23,420 DEBUG [AIF]: CommData.getRuleInfo - END

          2017-02-13 12:13:23,423 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N

          2017-02-13 12:13:23,423 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       = 70

                                          AND a.start_periodkey=b.periodkey

                                          AND a.loadid         =c.process_id

                                          AND br.rule_id = a.rule_id

                                         

          2017-02-13 12:13:23,426 DEBUG [AIF]: FileData.py: Importing Text data for load id: 70

          2017-02-13 12:13:23,446 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::70;83:3:25:[NONE]:C:\FDMEE/:DELIMITED

          2017-02-13 12:13:23,452 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

          2017-02-13 12:13:23,452 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

          2017-02-13 12:13:23,452 DEBUG [AIF]: EPMFDM-140274:Message -  SELECT pp.PERIODKEY,

            pp.PERIODTARGET,

            pp.GL_PERIOD_NAME,

            en.FILE_ENTITY_NAME,

            en.ENTITY_NAME_ORDER,

            br.MULTI_PERIOD_FILE_FLAG,

            pp.TRANS_ENTITY_NAME,

            pp.GL_PERIOD_YEAR_CHAR,

            pp.GL_PERIOD_NUM ,

            pp.YEARTARGET

          FROM AIF_PROCESS_PERIODS pp,

            AIF_BALANCE_RULES br,

            AIF_PROCESSES p,

            (SELECT DISTINCT entity_name FILE_ENTITY_NAME,

              pd.process_id,

              pd.entity_name_order

            FROM aif_process_details pd

            WHERE pd.entity_type     = 'PROCESS_BAL_IMP_FILE'

            AND pd.target_table_name = 'TDATASEG'

            AND pd.status            = 'PENDING'

            ) en

          WHERE pp.PROCESS_ID             = ?

          AND p.process_id                = pp.process_id

          AND en.process_id               = pp.process_id

          AND pp.IMP_ENTITY_NAME          = en.file_entity_name

          AND br.rule_id                  = p.rule_id

          AND en.entity_name_order        = pp.GL_EFFECTIVE_PERIOD_NUM

          ORDER BY en.entity_name_order

          2017-02-13 12:13:23,497 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=NZP;Script=DRCR_AMOUNT.py:StartPos=9:SourceClName=null

          2017-02-13 12:13:23,497 INFO  [AIF]: EPMFDM-140274:Message - Instantiating JythonInterpreter

          2017-02-13 12:13:23,594 DEBUG [AIF]: EPMFDM-140274:Message - Passing script file for execution to jython interpretor: C:\FDMEE/data/scripts/import/DRCR_AMOUNT.py

          2017-02-13 12:13:23,595 INFO  [AIF]: Execute File: C:\FDMEE/data/scripts/import/DRCR_AMOUNT.py

          2017-02-13 12:13:23,595 DEBUG [AIF]: LOG_LEVEL: 4

          2017-02-13 12:13:23,596 DEBUG [AIF]: Script File encoding: UTF-8

          2017-02-13 12:13:23,596 DEBUG [AIF]: def DRCR_AMOUNT(strField, strRecord):

              strField=strRecord.split(";")

              strAmountDR=strField[8].strip()

              strAmountCR=strField[9].strip()

              strResult=strAmountDR-strAmountCR

              return strResult

           

           

          2017-02-13 12:13:23,604 DEBUG [AIF]: EPMFDM-140274:Message - compiling script:DRCR_AMOUNT(strField,strRecord)

          2017-02-13 12:13:23,605 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=null

          2017-02-13 12:13:23,605 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=4:SourceClName=null

          2017-02-13 12:13:23,605 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=7:SourceClName=null

          2017-02-13 12:13:23,605 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=null

          2017-02-13 12:13:23,605 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=3:SourceClName=null

          2017-02-13 12:13:23,605 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=5:SourceClName=null

          2017-02-13 12:13:23,606 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=6:SourceClName=null

          2017-02-13 12:13:23,606 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=8:SourceClName=null

          2017-02-13 12:13:23,606 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=4:SourceClName=null

          2017-02-13 12:13:23,606 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

          2017-02-13 12:13:23,606 INFO  [AIF]: EPMFDM-140274:Message - File Name ImportFormatTemplate17_2.csv

          periodKey2017-01-31

          2017-02-13 12:13:23,608 DEBUG [AIF]: EPMFDM-140274:Message - Error Evaluating scriptnullorg.python.core.PyException.fillInStackTrace(PyException.java:70)

          java.lang.Throwable.<init>(Throwable.java:181)

          java.lang.Exception.<init>(Exception.java:29)

          java.lang.RuntimeException.<init>(RuntimeException.java:32)

          org.python.core.PyException.<init>(PyException.java:46)

          org.python.core.PyException.<init>(PyException.java:43)

          org.python.core.PyException.<init>(PyException.java:61)

          org.python.core.Py.TypeError(Py.java:195)

          org.python.core.PyObject._basic_sub(PyObject.java:2125)

          org.python.core.PyObject._sub(PyObject.java:2103)

          org.python.pycode._pyx608.DRCR_AMOUNT$1(<string>:6)

          org.python.pycode._pyx608.call_function(<string>)

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

          org.python.core.PyBaseCode.call(PyBaseCode.java:146)

          org.python.core.PyFunction.__call__(PyFunction.java:327)

          org.python.pycode._pyx611.f$0(<script>:1)

          org.python.pycode._pyx611.call_function(<script>)

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

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

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

          org.python.core.__builtin__.eval(__builtin__.java:504)

          org.python.util.PythonInterpreter.eval(PythonInterpreter.java:164)

          com.hyperion.aif.file.common.util.DataLoadEngine$Expression.evaluateScript(DataLoadEngine.java:1552)

          com.hyperion.aif.file.common.util.DataLoadEngine$Expression.access$300(DataLoadEngine.java:1458)

          com.hyperion.aif.file.common.util.DataLoadEngine$ImportItemFileEntity.evaluateExpressions(DataLoadEngine.java:1403)

          com.hyperion.aif.file.common.util.DataLoadEngine$Delimited.processFileRow(DataLoadEngine.java:2419)

          com.hyperion.aif.file.common.util.DataLoadEngine.loadRow(DataLoadEngine.java:442)

          com.hyperion.aif.file.data.ImportTextData.performLoad(ImportTextData.java:538)

          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

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

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

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

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

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

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

          org.python.core.PyObject.__call__(PyObject.java:381)

          org.python.core.PyObject.__call__(PyObject.java:385)

          org.python.pycode._pyx598.importData$2(<string>:119)

          org.python.pycode._pyx598.call_function(<string>)

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

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

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

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

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

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

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

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

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

          org.python.pycode._pyx601.f$0(<string>:5)

          org.python.pycode._pyx601.call_function(<string>)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

          oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

          org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

          oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

          oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

          oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

          oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

          oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

          oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

          oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

          com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

          com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

          com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

          com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

          oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

           

           

          2017-02-13 12:13:23,608 DEBUG [AIF]: EPMFDM-140274:Message - Error Evaluating scriptnullorg.python.core.PyException.fillInStackTrace(PyException.java:70)

          java.lang.Throwable.<init>(Throwable.java:181)

          java.lang.Exception.<init>(Exception.java:29)

          java.lang.RuntimeException.<init>(RuntimeException.java:32)

          org.python.core.PyException.<init>(PyException.java:46)

          org.python.core.PyException.<init>(PyException.java:43)

          org.python.core.PyException.<init>(PyException.java:61)

          org.python.core.Py.TypeError(Py.java:195)

          org.python.core.PyObject._basic_sub(PyObject.java:2125)

          org.python.core.PyObject._sub(PyObject.java:2103)

          org.python.pycode._pyx608.DRCR_AMOUNT$1(<string>:6)

          org.python.pycode._pyx608.call_function(<string>)

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

          org.python.core.PyBaseCode.call(PyBaseCode.java:146)

          org.python.core.PyFunction.__call__(PyFunction.java:327)

          org.python.pycode._pyx611.f$0(<script>:1)

          org.python.pycode._pyx611.call_function(<script>)

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

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

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

          org.python.core.__builtin__.eval(__builtin__.java:504)

          org.python.util.PythonInterpreter.eval(PythonInterpreter.java:164)

          com.hyperion.aif.file.common.util.DataLoadEngine$Expression.evaluateScript(DataLoadEngine.java:1552)

          com.hyperion.aif.file.common.util.DataLoadEngine$Expression.access$300(DataLoadEngine.java:1458)

          com.hyperion.aif.file.common.util.DataLoadEngine$ImportItemFileEntity.evaluateExpressions(DataLoadEngine.java:1403)

          com.hyperion.aif.file.common.util.DataLoadEngine$Delimited.processFileRow(DataLoadEngine.java:2419)

          com.hyperion.aif.file.common.util.DataLoadEngine.loadRow(DataLoadEngine.java:442)

          com.hyperion.aif.file.data.ImportTextData.performLoad(ImportTextData.java:538)

          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

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

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

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

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

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

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

          org.python.core.PyObject.__call__(PyObject.java:381)

          org.python.core.PyObject.__call__(PyObject.java:385)

          org.python.pycode._pyx598.importData$2(<string>:119)

          org.python.pycode._pyx598.call_function(<string>)

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

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

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

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

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

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

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

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

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

          org.python.pycode._pyx601.f$0(<string>:5)

          org.python.pycode._pyx601.call_function(<string>)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

          oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

          org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

          oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

          oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

          oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

          oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

          oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

          oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

          oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

          com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

          com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

          com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

          com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

          oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

           

           

          2017-02-13 12:13:23,608 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 70

          PARTITIONKEY: 83

          IMPORT GROUP: Test

          FILE TYPE: DELIMITED

          DELIMITER: ;

          SOURCE FILE: ImportFormatTemplate17_2.csv

          PROCESSING CODES:

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

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

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

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

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

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

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

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

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

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

           

           

           

           

          [SKIP FROM SCRIPT ] Entity;Account;ICP;Custom1;Custom2;Custom3;Custom4;Custom5;Debit;Credit;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Custom1Add

          [SKIP FROM SCRIPT ] 130001;FTE;[ICP None];;[None];[None];[None];[None];42;2;41;42;41;42;41;1;1;11;1;0;CD2_Serv3

          Rows Loaded: 0

          Rows Rejected: 2

           

           

          2017-02-13 12:13:23,610 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: null

          2017-02-13 12:13:23,610 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

          2017-02-13 12:13:23,610 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 7020170131

          2017-02-13 12:13:23,610 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: ImportFormatTemplate17_2

          Extension: csv

          2017-02-13 12:13:23,611 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 7020170131.csv

          2017-02-13 12:13:23,611 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: ImportFormatTemplate17_2.csv

          2017-02-13 12:13:23,612 INFO  [AIF]: EPMFDM-140274:Message - File not deleted: C:\FDMEE\ImportFormatTemplate17_2.csv

          2017-02-13 12:13:23,639 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

          2017-02-13 12:13:23,639 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 187

          2017-02-13 12:13:23,640 INFO  [AIF]: EPMFDM-140274:Message - Releasing JythonInterpreter

          2017-02-13 12:13:23,640 DEBUG [AIF]: FileData.importData - END

          2017-02-13 12:13:23,983 DEBUG [AIF]: CommData.postImportData - START

          2017-02-13 12:13:23,983 DEBUG [AIF]: CommData.getRuleInfo - START

          2017-02-13 12:13:23,987 DEBUG [AIF]:

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

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

                FROM TPOVPARTITION tpp

                INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                  ON adim.APPLICATION_ID = 3

                LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                WHERE tpp.PARTITIONKEY = 83

                AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                ORDER BY adim.BALANCE_COLUMN_NAME

               

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

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

          2017-02-13 12:13:23,996 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}

          2017-02-13 12:13:23,996 DEBUG [AIF]: CommData.getRuleInfo - END

          2017-02-13 12:13:24,004 DEBUG [AIF]: CommData.updateTDATASEG_T - START

          2017-02-13 12:13:24,006 DEBUG [AIF]: CommData.getLedgerListAndMap - START

          2017-02-13 12:13:24,007 DEBUG [AIF]: CommData.getLedgerSQL - START

          2017-02-13 12:13:24,007 DEBUG [AIF]: CommData.getLedgerSQL - END

          2017-02-13 12:13:24,007 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 = 25

                   

          2017-02-13 12:13:24,008 DEBUG [AIF]: CommData.getLedgerListAndMap - END

          2017-02-13 12:13:24,011 DEBUG [AIF]: CommData.getPovList - START

          2017-02-13 12:13:24,013 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 = 70

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

                 

          2017-02-13 12:13:24,020 DEBUG [AIF]: CommData.getPovList - END

          2017-02-13 12:13:24,020 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    = 70

                    AND en.process_id      = pp.process_id

                    AND pp.IMP_ENTITY_NAME = en.file_entity_name

                    order by en.entity_name_order

                   

          2017-02-13 12:13:24,022 INFO  [AIF]:

          Import Data from Source for Period 'Jan-2017'

          2017-02-13 12:13:24,029 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-13 12:13:24,029 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 = 83 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2017-01-31' AND tlp.RULE_ID = 25 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

             

          2017-02-13 12:13:24,031 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=83 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=25

                 

          2017-02-13 12:13:24,037 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-13 12:13:24,037 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 = 83

                      AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                      ORDER BY adim.BALANCE_COLUMN_NAME

                     

          2017-02-13 12:13:24,041 DEBUG [AIF]: 

                      UPDATE TDATASEG_T

                      SET AMOUNTX = AMOUNT, DATAX = DATA

                         ,ACCOUNTX = NULL

                         ,ENTITYX = NULL

                         ,ICPX = NULL

                         ,UD1X = NULL

                         ,UD2X = NULL

                         ,UD3X = NULL

                         ,UD4X = NULL

                         ,UD5X = NULL

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

                     

          2017-02-13 12:13:24,042 INFO  [AIF]: Generic Data Rows Imported from Source: 0

          2017-02-13 12:13:24,042 INFO  [AIF]: Total Data Rows Imported from Source: 0

          2017-02-13 12:13:24,042 DEBUG [AIF]: CommData.updateTDATASEG_T - END

          2017-02-13 12:13:24,048 DEBUG [AIF]: Comm.doScriptInit - START

          2017-02-13 12:13:24,131 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\FDMEE\inbox, LOCNAME=TEST, SOURCENAME=File, APPID=3, SOURCEID=1, APPROOTDIR=C:\FDMEE, IMPORTFORMAT=Test, SCRIPTSDIR=C:\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=25, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=70, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate17_2.csv, LOCKEY=83, RULENAME=r_dlr_test, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=MBUG, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}

          2017-02-13 12:13:24,140 DEBUG [AIF]: The executeEventScript is set to: YES

          2017-02-13 12:13:24,140 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE

          2017-02-13 12:13:24,140 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

          2017-02-13 12:13:24,140 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB

          2017-02-13 12:13:24,140 DEBUG [AIF]: Comm.doScriptInit - END

          2017-02-13 12:13:24,140 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:24,141 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftImport.py

          2017-02-13 12:13:24,145 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:24,145 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

          2017-02-13 12:13:24,145 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftImport.vbs

          2017-02-13 12:13:24,145 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:24,145 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:24,145 DEBUG [AIF]: CommData.postImportData - END

          2017-02-13 12:13:25,633 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

          2017-02-13 12:13:25,633 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:25,634 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcLogicGrp.py

          2017-02-13 12:13:25,634 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:25,634 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcLogicGrp.vbs

          2017-02-13 12:13:25,634 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:25,634 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:25,636 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

          2017-02-13 12:13:25,636 DEBUG [AIF]:

                  select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

                  from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

                  and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

                 

          2017-02-13 12:13:25,639 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

          2017-02-13 12:13:25,639 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:25,640 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcLogicGrp.py

          2017-02-13 12:13:25,640 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:25,640 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcLogicGrp.vbs

          2017-02-13 12:13:25,640 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:25,640 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:25,640 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

          2017-02-13 12:13:25,669 DEBUG [AIF]: CommData.mapData - START

          2017-02-13 12:13:25,670 DEBUG [AIF]: CommData.insertTransProcessDetails - START

          2017-02-13 12:13:25,671 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 = 70

                      AND PRIOR_PERIOD_FLAG = 'N'

                      GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

                    ) q

                    ORDER BY ENTITY_NAME_ORDER

                   

          2017-02-13 12:13:25,677 DEBUG [AIF]: CommData.insertTransProcessDetails - END

          2017-02-13 12:13:25,680 DEBUG [AIF]:

                  DELETE FROM TDATAMAP_T

                  WHERE LOADID < 70

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

                 

          2017-02-13 12:13:25,681 DEBUG [AIF]:

                  DELETE FROM TDATASEG_T

                  WHERE LOADID < 70

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

                 

          2017-02-13 12:13:25,683 DEBUG [AIF]:

                  DELETE FROM AIF_PROCESS_PERIODS

                  WHERE PROCESS_ID < 70

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

                 

          2017-02-13 12:13:25,703 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

          2017-02-13 12:13:25,705 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

          2017-02-13 12:13:25,705 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 = 83

                 

          2017-02-13 12:13:25,706 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

          2017-02-13 12:13:25,707 INFO  [AIF]: Processing Mappings from Parent Location: VALORAGROUP

          2017-02-13 12:13:25,708 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 70, DATAKEY, 83 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '<BLANK>' THEN ' ' ELSE TARGKEY END

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

                  FROM TDATAMAP

                  WHERE PARTITIONKEY = 82

                  AND ( RULE_ID IS NULL OR RULE_ID = 25 )

                 

          2017-02-13 12:13:25,709 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 8

          2017-02-13 12:13:25,755 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

          2017-02-13 12:13:25,755 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:25,755 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcMap.py

          2017-02-13 12:13:25,755 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:25,756 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcMap.vbs

          2017-02-13 12:13:25,756 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:25,756 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:25,756 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 = 70

                  AND atad.APPLICATION_ID = 3

                  AND tdm.PARTITIONKEY = 83

                  AND tdm.TDATAMAPTYPE = 'ERP'

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

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

                  AND atad.APPLICATION_ID = 3

                  AND tdm.PARTITIONKEY = 83

                  AND tdm.TDATAMAPTYPE = 'ERP'

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

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

                ) q

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

               

          2017-02-13 12:13:25,762 INFO  [AIF]:

          Map Data for Period 'Jan-2017'

          2017-02-13 12:13:25,763 DEBUG [AIF]: Comm.updateProcessDetail - START

          2017-02-13 12:13:25,764 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 = 70 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jan-2017'

             

          2017-02-13 12:13:25,771 DEBUG [AIF]: Comm.updateProcessDetail - END

          2017-02-13 12:13:25,774 DEBUG [AIF]:

                SELECT COUNT(*) ROW_COUNT

                FROM TDATASEG_T

                WHERE LOADID = 70

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

               

          2017-02-13 12:13:25,776 WARN  [AIF]: Warning: No records exist for Period 'Jan-2017'

          2017-02-13 12:13:25,776 DEBUG [AIF]: Comm.updateProcessDetail - START

          2017-02-13 12:13:25,776 DEBUG [AIF]:

              UPDATE AIF_PROCESS_DETAILS

              SET STATUS = 'WARNING'

                 ,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 = 70 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jan-2017'

             

          2017-02-13 12:13:25,778 DEBUG [AIF]: Comm.updateProcessDetail - END

          2017-02-13 12:13:25,786 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-13 12:13:25,786 DEBUG [AIF]:

                  UPDATE TLOGPROCESS

                  SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

                     ,PROCESSIMPNOTE='AIF_WF_IMP_IMPORT_ERR'

                  WHERE PARTITIONKEY=83 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=25

                 

          2017-02-13 12:13:25,788 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-13 12:13:25,788 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

          2017-02-13 12:13:25,798 DEBUG [AIF]: CommData.updateYtdAmounts - START

          2017-02-13 12:13:25,800 DEBUG [AIF]: CommData.getLedgerListAndMap - START

          2017-02-13 12:13:25,801 DEBUG [AIF]: CommData.getLedgerSQL - START

          2017-02-13 12:13:25,801 DEBUG [AIF]: CommData.getLedgerSQL - END

          2017-02-13 12:13:25,801 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 = 25

                   

          2017-02-13 12:13:25,802 DEBUG [AIF]: CommData.getLedgerListAndMap - END

          2017-02-13 12:13:25,802 DEBUG [AIF]: CommData.updateYtdAmounts - END

          2017-02-13 12:13:25,813 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

          2017-02-13 12:13:25,813 INFO  [AIF]:

          Stage Data for Period 'Jan-2017'

          2017-02-13 12:13:25,813 DEBUG [AIF]:

                  DELETE FROM TDATAMAPSEG

                  WHERE PARTITIONKEY = 83

                  AND CATKEY = 3

                  AND PERIODKEY = '2017-01-31'

                 

          2017-02-13 12:13:25,815 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 8

          2017-02-13 12:13:25,815 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 = 70

                 

          2017-02-13 12:13:25,816 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 8

          2017-02-13 12:13:25,816 DEBUG [AIF]:

                  DELETE FROM TDATAMAP_T

                  WHERE LOADID = 70

                 

          2017-02-13 12:13:25,817 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 8

          2017-02-13 12:13:25,817 DEBUG [AIF]:

                      DELETE FROM TDATASEG

                      WHERE LOADID < 70 AND PARTITIONKEY = 83 AND CATKEY = 3 AND RULE_ID = 25 AND PERIODKEY = '2017-01-31'

                     

          2017-02-13 12:13:25,818 INFO  [AIF]: Number of Rows deleted from TDATASEG: 0

          2017-02-13 12:13:25,818 DEBUG [AIF]:

                      DELETE FROM TDATAMEMOITEMS

                      WHERE PARTITIONKEY = 83 AND PERIODKEY = '2017-01-31' AND CATKEY = 3 AND RULE_ID = 25

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

                     

          2017-02-13 12:13:25,819 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

          2017-02-13 12:13:25,819 DEBUG [AIF]:

                      DELETE FROM TDATAARCHIVE

                      WHERE PARTITIONKEY = 83 AND PERIODKEY = '2017-01-31' AND CATKEY = 3 AND RULE_ID = 25

                      AND ARCHIVEPROCTYPEID = 1

                      AND NOT EXISTS ( SELECT 1

                                       FROM TDATAMEMOITEMS

                                       WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID

                                       OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID                         

                                       OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )

                     

          2017-02-13 12:13:25,820 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

          2017-02-13 12:13:25,820 DEBUG [AIF]:

                    INSERT INTO TDATASEG (

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

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

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

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

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

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

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

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

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

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

                    SELECT

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

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

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

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

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

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

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

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

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

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

                    FROM TDATASEG_T

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

                   

          2017-02-13 12:13:25,822 INFO  [AIF]: Number of Rows inserted into TDATASEG: 0

          2017-02-13 12:13:25,822 DEBUG [AIF]:

                  DELETE FROM TDATASEG_T

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

                 

          2017-02-13 12:13:25,823 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 0

          2017-02-13 12:13:25,823 DEBUG [AIF]: CommData.updateWorkflow - START

          2017-02-13 12:13:25,823 DEBUG [AIF]:

                  UPDATE TLOGPROCESS

                  SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

                     ,PROCESSIMPNOTE='Import Error'

                  WHERE PARTITIONKEY=83 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE_ID=25

                 

          2017-02-13 12:13:25,828 DEBUG [AIF]: CommData.updateWorkflow - END

          2017-02-13 12:13:25,829 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

          2017-02-13 12:13:25,829 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:25,829 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcMap.py

          2017-02-13 12:13:25,829 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:25,829 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcMap.vbs

          2017-02-13 12:13:25,829 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:25,829 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:25,829 DEBUG [AIF]: CommData.mapData - END

          2017-02-13 12:13:25,858 INFO  [AIF]: -------END IMPORT STEP-------

          2017-02-13 12:13:25,881 INFO  [AIF]: -------START VALIDATE STEP-------

          2017-02-13 12:13:25,920 DEBUG [AIF]: CommData.validateData - START

          2017-02-13 12:13:25,920 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:25,921 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefValidate.py

          2017-02-13 12:13:25,921 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:25,921 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefValidate.vbs

          2017-02-13 12:13:25,921 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:25,921 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:25,927 DEBUG [AIF]: CommMap.validateData - START

          2017-02-13 12:13:25,929 WARN  [AIF]: Warning: The Import step has not been completed for period Jan-2017

          2017-02-13 12:13:25,929 DEBUG [AIF]: CommMap.validateData - END

          2017-02-13 12:13:25,930 WARN  [AIF]: Warning: The Import step has not been completed for period Jan-2017

          2017-02-13 12:13:25,930 DEBUG [AIF]: Comm.executeScript - START

          2017-02-13 12:13:25,931 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftValidate.py

          2017-02-13 12:13:25,931 DEBUG [AIF]: Comm.executeVBScript - START

          2017-02-13 12:13:25,931 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftValidate.vbs

          2017-02-13 12:13:25,931 DEBUG [AIF]: Comm.executeVBScript - END

          2017-02-13 12:13:25,931 DEBUG [AIF]: Comm.executeScript - END

          2017-02-13 12:13:25,931 DEBUG [AIF]: CommData.validateData - END

          2017-02-13 12:13:25,954 INFO  [AIF]: -------END VALIDATE STEP-------

          2017-02-13 12:13:26,731 DEBUG [AIF]: Comm.finalizeProcess - START

          2017-02-13 12:13:26,732 DEBUG [AIF]: CommData.updateRuleStatus - START

          2017-02-13 12:13:26,733 DEBUG [AIF]:

              UPDATE AIF_BALANCE_RULES

              SET STATUS = CASE 'SUCCESS'

                WHEN 'SUCCESS' THEN

                  CASE ( SELECT COUNT(*) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 70 AND pd.STATUS IN ('FAILED','WARNING') )

                    WHEN 0 THEN 'SUCCESS'

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

                ELSE 'SUCCESS' END

              WHERE RULE_ID = 25

             

          2017-02-13 12:13:26,740 DEBUG [AIF]: CommData.updateRuleStatus - END

          2017-02-13 12:13:26,741 DEBUG [AIF]: Comm.updateProcess - START

          2017-02-13 12:13:26,748 DEBUG [AIF]: Comm.updateProcess - END

          2017-02-13 12:13:26,749 DEBUG [AIF]: The fdmAPI connection has been closed.

          2017-02-13 12:13:26,750 INFO  [AIF]: FDMEE Process End, Process ID: 70

          • 2. Re: Jython in handling null Amount
            SH_INT

            Are you sure this has anything to do with the script? What happens if you remove the reference to the script from the import format do your records import successfully? 

            • 3. Re: Jython in handling null Amount
              3355552

              Hi , I realized that I put the wrong field number on my Import format (for a different target though.. not amount).

              Now I fixed that, but it says I have mapping error.

              I tried to take out the script just now and put single "field number" instead, and there is no more mapping error.... But anyway, I continue this in a seperate trail:

               

              Mapping Error after putting Jython script for Amount calculation

               

              Because I think it is not the Null issue in Jython.

               

              Thanks.