5 Replies Latest reply on Nov 17, 2017 5:54 AM by 3194629

    unable to map the period dimension in Data Management

    3194629

      Hi,

       

      we are working on writing back EPM cloud Budget Balances to the Budgetary Control in this process we have mapped period mapping with Budgetary Control both in Global and Application Mapping but once we execute the rule it will be running with warnings. As we have mapped the periods correctly but still we are unable to export the balances.

      we have a budget balances in Total_Year Period in pbcs but in the ERP we have period called PRD_01-02 both the periods we mapped in period mapping but no luck.

       

      And we have defined periods separately in source mapping as well but its not taking that source periods only taking Application mapping periods.

       

      once the Rule executes it will be executed  with warnings, below is my log.

      2017-11-06 07:13:23,999 INFO  [AIF]: FDMEE Process: 856, Log Level: 5

      2017-11-06 07:13:23,999 INFO  [AIF]: Location     : Export-PBCS to BC (Partitionkey:31)

      2017-11-06 07:13:23,999 INFO  [AIF]: Period Name  : PRD_01-02 (Period Key:3/31/18 12:00 AM)

      2017-11-06 07:13:23,999 INFO  [AIF]: Category Name: Budget (Category key:3)

      2017-11-06 07:13:23,999 INFO  [AIF]: Rule Name    : Export-PBCS to BC (Rule ID:46)

      2017-11-06 07:13:25,564 INFO  [AIF]: FDM Version: 11.1.2.4.220

      2017-11-06 07:13:25,564 INFO  [AIF]: Log File Encoding: UTF-8

      2017-11-06 07:13:26,508 INFO  [AIF]: -------START IMPORT STEP-------

      2017-11-06 07:13:26,640 DEBUG [AIF]: CommData.preImportData - START

      2017-11-06 07:13:26,640 DEBUG [AIF]: CommData.getRuleInfo - START

      2017-11-06 07:13:26,643 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 = 38

            LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

            WHERE tpp.PARTITIONKEY = 31

            AND adim.BALANCE_COLUMN_NAME IS NOT NULL

            AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

            ORDER BY adim.BALANCE_COLUMN_NAME

           

      2017-11-06 07:13:26,644 DEBUG [AIF]: {'EXPORT_TO_TARGET_FLAG': u'N', 'PLAN_NUMBER': 0L, 'SRC_TARGET_APP_NAME': u'BVBudget', 'JOURNAL_FLAG': None, 'DIMNAME_MAP': {u'UD1': {'DIMNAME': u'UD1', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD3': {'DIMNAME': u'UD3', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'ACCOUNT': {'DIMNAME': u'ACCOUNT', 'TARGET_DIMENSION_CLASS_NAME': u'Account'}}, 'CATKEY': 3L, 'TGT_APP_SUB_TYPE': u'FUSION', 'TGT_APP_ID': 38L, 'DIMNAME_LIST': [u'ACCOUNT', u'UD1', u'UD3'], 'SRC_SOURCE_SYSTEM_ID': 0L, 'TGT_SOURCE_SYSTEM_TYPE': u'FUSION_GL_CLOUD', 'TGT_APP_TYPE': u'ESSBASE', 'CALENDAR_ID': None, 'TGT_TARGET_APP_NAME': u'XCC_BVBudget7_2', 'PARTITIONKEY': 31L, 'EXECUTION_MODE': u'REPLACE', 'LEDGER_GROUP_CODE': u'NONE', 'PS_LEDGER': None, 'SRC_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://ap1pbcsr302111.audc1.oraclecloud.com:9000/aif', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'IS_INCREMENTAL_LOAD': False, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'SRC_APP_NAME': u'BVBudget', 'FCI_FLAG': 'N', 'KK_FLAG': u'N', 'LAST_UPDATED_BY': u'raghunandan.rao@bharatividyapeeth.edu', 'CHECK_FLAG': u'N', 'RULE_ID': 46L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SRC_APP_ID': u'4', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'IMPGROUPKEY': u'Export-PBCS to BC', 'TGT_SOURCE_SYSTEM_ID': 19L, 'SRC_APP_TYPE': u'HPL', 'TGT_APP_NAME': u'XCC_BVBudget7_2', 'IMPGROUPFILETYPE': u'EPM_EPM', 'LEDGER_GROUP': None, 'TGT_COA_ID': 0L, 'SOURCE_ADAPTER_FLAG': u'N', 'RECALCULATE_FLAG': u'Y', 'TGT_DATA_LOAD_METHOD': u'FUSION_GL_CLOUD', 'SRC_SOURCE_SYSTEM_TYPE': u'EPM', 'PLAN_TYPE': None}

      2017-11-06 07:13:26,645 DEBUG [AIF]: {u'AccountingPeriod': {'BCN': None, 'DCN': u'Period'}, u'COURSE': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Control Budget': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'ACCOUNT': {'BCN': u'UD3', 'DCN': u'Generic'}, u'Balance Amount': {'BCN': None, 'DCN': u'Generic'}, u'Amount Type': {'BCN': None, 'DCN': u'Generic'}}

      2017-11-06 07:13:26,646 DEBUG [AIF]: {u'UD1': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'UD3': {'IMPFLDSOURCECOLNAME': u'Account'}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': u'Version'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Amount'}}

      2017-11-06 07:13:26,646 DEBUG [AIF]: CommData.getRuleInfo - END

      2017-11-06 07:13:26,647 DEBUG [AIF]: CommData.insertEpmPeriods - START

      2017-11-06 07:13:26,648 DEBUG [AIF]: doAppPeriodMappingsExist - XCC_BVBudget7_2: Y

      2017-11-06 07:13:26,648 DEBUG [AIF]: doAppPeriodMappingsExist - BVBudget: Y

      2017-11-06 07:13:26,648 DEBUG [AIF]: Period mapping section: DEFAULT

      2017-11-06 07:13:26,649 DEBUG [AIF]:

              INSERT INTO AIF_PROCESS_PERIODS (

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

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

              )

              SELECT DISTINCT brl.LOADID PROCESS_ID

                  ,tpp.PERIODKEY PERIODKEY

                  ,'N' ADJUSTMENT_PERIOD_FLAG

                  ,0 GL_PERIOD_YEAR

                  ,spp.YEARTARGET GL_PERIOD_YEAR_CHAR

                  ,0 GL_PERIOD_NUM

                  ,spp.PERIODTARGET GL_PERIOD_NAME

                  ,spp.PERIODKEY GL_PERIOD_CODE

                  ,0 GL_EFFECTIVE_PERIOD_NUM

                  ,tpp.YEARTARGET YEARTARGET

                  ,tpp.PERIODTARGET PERIODTARGET

                  ,'PROCESS_BAL_IMP_FILE' IMP_ENTITY_TYPE

                  ,'BVBudget_856.dat'

                  ,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

                  ,tpp.PERIODDESC TRANS_ENTITY_NAME

                  ,'N' PRIOR_PERIOD_FLAG

              FROM (

                AIF_BAL_RULE_LOADS brl

                INNER JOIN TPOVCATEGORY pc

                  ON pc.CATKEY = brl.CATKEY

                 

                INNER JOIN TPOVPERIODADAPTOR_FLAT_V tpp

                  ON tpp.PERIODFREQ = pc.CATFREQ

                  AND tpp.PERIODKEY >= brl.START_PERIODKEY

                  AND tpp.PERIODKEY <= brl.END_PERIODKEY

                  AND tpp.INTSYSTEMKEY = 'XCC_BVBudget7_2'

                )

                INNER JOIN TPOVPERIODADAPTOR_FLAT_V spp

                  ON spp.PERIODFREQ = pc.CATFREQ

                  AND spp.PERIODKEY > tpp.PRIORPERIODKEY

                  AND spp.PERIODKEY <= tpp.PERIODKEY

                  AND spp.INTSYSTEMKEY = 'BVBudget'

              WHERE brl.LOADID = 856

              ORDER BY tpp.PERIODKEY, spp.PERIODKEY

             

      2017-11-06 07:13:26,649 DEBUG [AIF]: periodSQL - periodParams: [u'BVBudget_856.dat', u'XCC_BVBudget7_2', u'BVBudget', 856]

      2017-11-06 07:13:26,651 DEBUG [AIF]: insertRowCount: 5

      2017-11-06 07:13:26,652 DEBUG [AIF]: CommData.insertEpmPeriods - END

      2017-11-06 07:13:26,652 DEBUG [AIF]: CommData.updateBalRuleLoadParams - START

      2017-11-06 07:13:26,655 DEBUG [AIF]: yearDimensionName=Years, yearFilter="FY18"

      2017-11-06 07:13:26,655 DEBUG [AIF]: periodDimensionName=Period, periodFilter="FY18"

      2017-11-06 07:13:26,657 DEBUG [AIF]: CommData.updateBalRuleLoadParams - END

      2017-11-06 07:13:26,657 DEBUG [AIF]: CommData.getPovList - START

      2017-11-06 07:13:26,657 DEBUG [AIF]:

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

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

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

              FROM AIF_BAL_RULE_LOADS brl

              INNER JOIN AIF_BALANCE_RULES br

                ON br.RULE_ID = brl.RULE_ID

              INNER JOIN TPOVPARTITION part

                ON part.PARTITIONKEY = brl.PARTITIONKEY

              INNER JOIN TPOVCATEGORY cat

                ON cat.CATKEY = brl.CATKEY

              INNER JOIN AIF_PROCESS_PERIODS pprd

                ON pprd.PROCESS_ID = brl.LOADID

              LEFT OUTER JOIN TPOVPERIODADAPTOR pp

                ON pp.PERIODKEY = pprd.PERIODKEY AND pp.INTSYSTEMKEY = 'XCC_BVBudget7_2'

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

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

             

      2017-11-06 07:13:26,658 DEBUG [AIF]: CommData.getPovList - END

      2017-11-06 07:13:26,658 DEBUG [AIF]: Comm.doScriptInit - START

      2017-11-06 07:13:26,699 DEBUG [AIF]: fdmContext: {PERIODKEY=2018-03-31, CATKEY=3, APPNAME=XCC_BVBudget7_2, EXPORTFLAG=N, SOURCEID=0, TARGETAPPNAME=XCC_BVBudget7_2, USERLOCALE=en, IMPORTFLAG=Y, SCRIPTSDIR=/u03/inbox/data/scripts, SOURCENAME=EPM, PERIODNAME=PRD_01-02, BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality, LOCNAME=Export-PBCS to BC, USERNAME=raghunandan.rao@bharatividyapeeth.edu, APPROOTDIR=/u03/inbox, EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=ESSBASE, OUTBOXDIR=/u03/inbox/outbox, TARGETAPPDB=db, FILEDIR=inbox, APPID=38, MULTIPERIODLOAD=N, LOADID=856, RULEID=46, IMPORTMODE=REPLACE, SOURCETYPE=EPM, CATNAME=Budget, RULENAME=Export-PBCS to BC, LOCKEY=31, EXPORTMODE=null, INBOXDIR=/u03/inbox/inbox, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0, IMPORTFORMAT=Export-PBCS to BC}

      2017-11-06 07:13:26,702 DEBUG [AIF]: The executeEventScript is set to: NO

      2017-11-06 07:13:26,702 DEBUG [AIF]: The AppRootFolder is set to: /u03/inbox

      2017-11-06 07:13:26,702 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

      2017-11-06 07:13:26,702 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

      2017-11-06 07:13:26,702 DEBUG [AIF]: Comm.doScriptInit - END

      2017-11-06 07:13:26,702 DEBUG [AIF]: CommData.preImportData - END

      2017-11-06 07:13:26,740 DEBUG [AIF]: CommData.extractDataFromSource - START

      2017-11-06 07:13:26,740 DEBUG [AIF]: AIFUtil.callOdiServlet - START

      2017-11-06 07:13:26,753 INFO  [AIF]: EssbaseService.extractData - START

      2017-11-06 07:13:26,785 DEBUG [AIF]: appId:38, appType:HPL, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:false, isJournalLoad:false

      2017-11-06 07:13:26,785 DEBUG [AIF]: LOAD_METHOD:ESSFILE, LOAD_TYPE:DATA, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000

      2017-11-06 07:13:26,846 INFO  [AIF]: cloudServiceType: Planning, Resolved user name for application access: epm_default_cloud_admin

      2017-11-06 07:13:26,846 DEBUG [AIF]: We need to connect to Essbase server.

      2017-11-06 07:13:26,893 DEBUG [AIF]: Extracting data from BVBudget:Budget...

      2017-11-06 07:13:26,935 INFO  [AIF]: Extract Script (Calc): SET DataExportOptions

      {

      DATAEXPORTCOLFORMAT ON;

      DATAEXPORTDIMHEADER ON;

      DATAEXPORTDRYRUN OFF;

      DataExportRelationalFile OFF;

      DataExportNonExistingBlocks OFF;

      DataExportLevel ALL;

      DATAEXPORTCOLHEADER "Period";

      DATAEXPORTOVERWRITEFILE ON;

      DataExportDynamicCalc OFF;

      };

       

       

      FIX (@Relative("40000000",0),"21001","FY18","Budget","Working","FY18")

      DATAEXPORT "File" "," "/u03/inbox/data/BVBudget_Budget_856.txt"  "#";

      ENDFIX

       

       

      2017-11-06 07:13:26,951 INFO  [AIF]: List of exported files to be merged from dir /u03/inbox/data for file name BVBudget_Budget_856*

      2017-11-06 07:13:26,960 INFO  [AIF]: Number of files to be merged: 1

      2017-11-06 07:13:26,969 INFO  [AIF]: EssbaseService.extractData - END (true)

      2017-11-06 07:13:26,977 DEBUG [AIF]: AIFUtil.callOdiServlet - END

      2017-11-06 07:13:26,978 DEBUG [AIF]: CommData.extractDataFromSource - END

      2017-11-06 07:13:27,001 DEBUG [AIF]: CommData.insertImportProcessDetails - START

      2017-11-06 07:13:27,001 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, 'raghunandan.rao@bharatividyapeeth.edu' 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 = 856

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2017-11-06 07:13:27,017 DEBUG [AIF]: CommData.insertImportProcessDetails - END

      2017-11-06 07:13:27,037 DEBUG [AIF]: FileData.importData - START

      2017-11-06 07:13:27,037 DEBUG [AIF]: Importing data for load id: 856

      2017-11-06 07:13:27,038 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

                  FROM aif_bal_rule_loads a,

                       aif_balance_rules br,

                       tpovperiodadaptor b,

                       aif_processes c

                  WHERE a.loadid       = 856

                  AND a.start_periodkey=b.periodkey

                  AND a.loadid         =c.process_id

                  AND br.rule_id = a.rule_id

                  AND b.INTSYSTEMKEY = 'XCC_BVBudget7_2'

                 

      2017-11-06 07:13:27,040 DEBUG [AIF]: FileData.py: Importing Text data for load id: 856

      2017-11-06 07:13:27,098 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::856;31:3:46:INR:/u03/inbox/data:EPM_EPM

      2017-11-06 07:13:27,102 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

      2017-11-06 07:13:27,102 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

      2017-11-06 07:13:27,102 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-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

      2017-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account

      2017-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Version

      2017-11-06 07:13:27,138 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity

      2017-11-06 07:13:27,139 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

      2017-11-06 07:13:27,139 INFO  [AIF]: EPMFDM-140274:Message - File Name BVBudget_856.dat

      periodKey2018-03-31

      2017-11-06 07:13:27,139 INFO  [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL

      2017-11-06 07:13:27,139 DEBUG [AIF]: BOM exists

      2017-11-06 07:13:27,139 DEBUG [AIF]: After removing BOM ["Years","Scenario","Version","Entity","Account","Period"]

      2017-11-06 07:13:27,139 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Version", "Entity", "Account", "Period"]

      2017-11-06 07:13:27,142 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000]

      2017-11-06 07:13:27,168 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,169 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,170 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000]

      2017-11-06 07:13:27,171 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 856

      PARTITIONKEY: 31

      IMPORT GROUP: Export-PBCS to BC

      FILE TYPE: DELIMITED

      DELIMITER: ,

      SOURCE FILE: BVBudget_856.dat

      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.

       

       

       

       

      [BLANK] "FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200

      [BLANK] "FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300

      [BLANK] "FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800

      [BLANK] "FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000

      [BLANK] "FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000

      [BLANK] "FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000

      [BLANK] "FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000

      [BLANK] "FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700

      [BLANK] "FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000

      [BLANK] "FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000

      [BLANK] "FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000

      [BLANK] "FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000

      [BLANK] "FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000

      [BLANK] "FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000

      [BLANK] "FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000

      [BLANK] "FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000

      [BLANK] "FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000

      [BLANK] "FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000

      [BLANK] "FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000

      [BLANK] "FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000

      [BLANK] "FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000

      [BLANK] "FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000

      [BLANK] "FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000

      [BLANK] "FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000

      [BLANK] "FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000

      Rows Loaded: 0

      Rows Rejected: 62

       

       

      2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

      2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account

      2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Version

      2017-11-06 07:13:27,207 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity

      2017-11-06 07:13:27,208 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

      2017-11-06 07:13:27,208 INFO  [AIF]: EPMFDM-140274:Message - File Name BVBudget_856.dat

      periodKey2018-03-31

      2017-11-06 07:13:27,208 INFO  [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL

      2017-11-06 07:13:27,208 DEBUG [AIF]: BOM exists

      2017-11-06 07:13:27,208 DEBUG [AIF]: After removing BOM ["Years","Scenario","Version","Entity","Account","Period"]

      2017-11-06 07:13:27,208 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Version", "Entity", "Account", "Period"]

      2017-11-06 07:13:27,211 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700]

      2017-11-06 07:13:27,236 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,237 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,238 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000]

      2017-11-06 07:13:27,239 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 856

      PARTITIONKEY: 31

      IMPORT GROUP: Export-PBCS to BC

      FILE TYPE: DELIMITED

      DELIMITER: ,

      SOURCE FILE: BVBudget_856.dat

      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.

       

       

       

       

      [BLANK] "FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200

      [BLANK] "FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300

      [BLANK] "FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800

      [BLANK] "FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000

      [BLANK] "FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000

      [BLANK] "FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000

      [BLANK] "FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000

      [BLANK] "FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700

      [BLANK] "FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000

      [BLANK] "FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000

      [BLANK] "FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000

      [BLANK] "FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000

      [BLANK] "FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000

      [BLANK] "FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000

      [BLANK] "FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000

      [BLANK] "FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000

      [BLANK] "FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000

      [BLANK] "FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000

      [BLANK] "FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000

      [BLANK] "FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000

      [BLANK] "FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000

      [BLANK] "FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000

      [BLANK] "FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000

      [BLANK] "FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000

      [BLANK] "FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000

      Rows Loaded: 0

      Rows Rejected: 62

       

       

      2017-11-06 07:13:27,274 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

      2017-11-06 07:13:27,274 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account

      2017-11-06 07:13:27,274 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Version

      2017-11-06 07:13:27,274 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity

      2017-11-06 07:13:27,275 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

      2017-11-06 07:13:27,275 INFO  [AIF]: EPMFDM-140274:Message - File Name BVBudget_856.dat

      periodKey2018-03-31

      2017-11-06 07:13:27,275 INFO  [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL

      2017-11-06 07:13:27,275 DEBUG [AIF]: BOM exists

      2017-11-06 07:13:27,275 DEBUG [AIF]: After removing BOM ["Years","Scenario","Version","Entity","Account","Period"]

      2017-11-06 07:13:27,275 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Version", "Entity", "Account", "Period"]

      2017-11-06 07:13:27,278 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency

      2017-11-06 07:13:27,302 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200]

      2017-11-06 07:13:27,302 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,303 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000]

      2017-11-06 07:13:27,304 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,305 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000]

      2017-11-06 07:13:27,305 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 856

      PARTITIONKEY: 31

      IMPORT GROUP: Export-PBCS to BC

      FILE TYPE: DELIMITED

      DELIMITER: ,

      SOURCE FILE: BVBudget_856.dat

      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.

       

       

       

       

      [BLANK] "FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200

      [BLANK] "FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300

      [BLANK] "FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800

      [BLANK] "FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000

      [BLANK] "FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000

      [BLANK] "FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000

      [BLANK] "FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000

      [BLANK] "FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700

      [BLANK] "FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000

      [BLANK] "FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000

      [BLANK] "FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000

      [BLANK] "FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000

      [BLANK] "FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000

      [BLANK] "FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000

      [BLANK] "FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000

      [BLANK] "FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000

      [BLANK] "FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000

      [BLANK] "FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000

      [BLANK] "FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000

      [BLANK] "FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000

      [BLANK] "FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000

      [BLANK] "FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000

      [BLANK] "FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000

      [BLANK] "FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000

      [BLANK] "FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000

      Rows Loaded: 0

      Rows Rejected: 62

       

       

      2017-11-06 07:13:27,340 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

      2017-11-06 07:13:27,340 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account

      2017-11-06 07:13:27,340 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Version

      2017-11-06 07:13:27,340 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity

      2017-11-06 07:13:27,340 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

      2017-11-06 07:13:27,341 INFO  [AIF]: EPMFDM-140274:Message - File Name BVBudget_856.dat

      periodKey2018-03-31

      2017-11-06 07:13:27,341 INFO  [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL

      2017-11-06 07:13:27,341 DEBUG [AIF]: BOM exists

      2017-11-06 07:13:27,341 DEBUG [AIF]: After removing BOM ["Years","Scenario","Version","Entity","Account","Period"]

      2017-11-06 07:13:27,341 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Version", "Entity", "Account", "Period"]

      2017-11-06 07:13:27,344 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency

      2017-11-06 07:13:27,368 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000]

      2017-11-06 07:13:27,369 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,370 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,371 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000]

      2017-11-06 07:13:27,372 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 856

      PARTITIONKEY: 31

      IMPORT GROUP: Export-PBCS to BC

      FILE TYPE: DELIMITED

      DELIMITER: ,

      SOURCE FILE: BVBudget_856.dat

      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.

       

       

       

       

      [BLANK] "FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200

      [BLANK] "FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300

      [BLANK] "FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800

      [BLANK] "FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000

      [BLANK] "FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000

      [BLANK] "FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000

      [BLANK] "FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000

      [BLANK] "FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700

      [BLANK] "FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000

      [BLANK] "FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000

      [BLANK] "FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000

      [BLANK] "FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000

      [BLANK] "FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000

      [BLANK] "FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000

      [BLANK] "FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000

      [BLANK] "FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000

      [BLANK] "FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000

      [BLANK] "FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000

      [BLANK] "FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000

      [BLANK] "FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000

      [BLANK] "FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000

      [BLANK] "FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000

      [BLANK] "FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000

      [BLANK] "FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000

      [BLANK] "FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000

      Rows Loaded: 0

      Rows Rejected: 62

       

       

      2017-11-06 07:13:27,408 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

      2017-11-06 07:13:27,408 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Account

      2017-11-06 07:13:27,408 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Version

      2017-11-06 07:13:27,408 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Entity

      2017-11-06 07:13:27,409 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

      2017-11-06 07:13:27,409 INFO  [AIF]: EPMFDM-140274:Message - File Name BVBudget_856.dat

      periodKey2018-03-31

      2017-11-06 07:13:27,409 INFO  [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL

      2017-11-06 07:13:27,409 DEBUG [AIF]: BOM exists

      2017-11-06 07:13:27,409 DEBUG [AIF]: After removing BOM ["Years","Scenario","Version","Entity","Account","Period"]

      2017-11-06 07:13:27,409 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Version", "Entity", "Account", "Period"]

      2017-11-06 07:13:27,412 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,437 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,438 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000]

      2017-11-06 07:13:27,439 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000]

      2017-11-06 07:13:27,440 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 856

      PARTITIONKEY: 31

      IMPORT GROUP: Export-PBCS to BC

      FILE TYPE: DELIMITED

      DELIMITER: ,

      SOURCE FILE: BVBudget_856.dat

      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.

       

       

       

       

      [BLANK] "FY18","Budget","Working","21001","40101001",#,#,#,#,#,#,#,#,#,#,#,#,#,1200

      [BLANK] "FY18","Budget","Working","21001","40101010",#,#,#,#,#,#,#,#,#,#,#,#,#,160185300

      [BLANK] "FY18","Budget","Working","21001","40102006",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40102007",#,#,#,#,#,#,#,#,#,#,#,#,#,48909800

      [BLANK] "FY18","Budget","Working","21001","40103001",#,#,#,#,#,#,#,#,#,#,#,#,#,3507000

      [BLANK] "FY18","Budget","Working","21001","40104001",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201001",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40201003",#,#,#,#,#,#,#,#,#,#,#,#,#,90000

      [BLANK] "FY18","Budget","Working","21001","40201004",#,#,#,#,#,#,#,#,#,#,#,#,#,75000

      [BLANK] "FY18","Budget","Working","21001","40201005",#,#,#,#,#,#,#,#,#,#,#,#,#,7500000

      [BLANK] "FY18","Budget","Working","21001","40201006",#,#,#,#,#,#,#,#,#,#,#,#,#,41379700

      [BLANK] "FY18","Budget","Working","21001","40201007",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40201008",#,#,#,#,#,#,#,#,#,#,#,#,#,3250000

      [BLANK] "FY18","Budget","Working","21001","40201009",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201010",#,#,#,#,#,#,#,#,#,#,#,#,#,10000000

      [BLANK] "FY18","Budget","Working","21001","40201011",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40201013",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201014",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40201015",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40201016",#,#,#,#,#,#,#,#,#,#,#,#,#,1350000

      [BLANK] "FY18","Budget","Working","21001","40201017",#,#,#,#,#,#,#,#,#,#,#,#,#,1000000

      [BLANK] "FY18","Budget","Working","21001","40201018",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201019",#,#,#,#,#,#,#,#,#,#,#,#,#,400000

      [BLANK] "FY18","Budget","Working","21001","40201020",#,#,#,#,#,#,#,#,#,#,#,#,#,3000000

      [BLANK] "FY18","Budget","Working","21001","40201022",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201023",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40201025",#,#,#,#,#,#,#,#,#,#,#,#,#,450000

      [BLANK] "FY18","Budget","Working","21001","40201026",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40201027",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40201028",#,#,#,#,#,#,#,#,#,#,#,#,#,100000

      [BLANK] "FY18","Budget","Working","21001","40201029",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301001",#,#,#,#,#,#,#,#,#,#,#,#,#,150000

      [BLANK] "FY18","Budget","Working","21001","40301003",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40301004",#,#,#,#,#,#,#,#,#,#,#,#,#,950000

      [BLANK] "FY18","Budget","Working","21001","40301005",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40301006",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301007",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40301008",#,#,#,#,#,#,#,#,#,#,#,#,#,900000

      [BLANK] "FY18","Budget","Working","21001","40301009",#,#,#,#,#,#,#,#,#,#,#,#,#,2250000

      [BLANK] "FY18","Budget","Working","21001","40301010",#,#,#,#,#,#,#,#,#,#,#,#,#,50000

      [BLANK] "FY18","Budget","Working","21001","40301011",#,#,#,#,#,#,#,#,#,#,#,#,#,550000

      [BLANK] "FY18","Budget","Working","21001","40301012",#,#,#,#,#,#,#,#,#,#,#,#,#,750000

      [BLANK] "FY18","Budget","Working","21001","40301013",#,#,#,#,#,#,#,#,#,#,#,#,#,60000

      [BLANK] "FY18","Budget","Working","21001","40301014",#,#,#,#,#,#,#,#,#,#,#,#,#,800000

      [BLANK] "FY18","Budget","Working","21001","40301015",#,#,#,#,#,#,#,#,#,#,#,#,#,125000

      [BLANK] "FY18","Budget","Working","21001","40302004",#,#,#,#,#,#,#,#,#,#,#,#,#,2000000

      [BLANK] "FY18","Budget","Working","21001","40601001",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40601002",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40601003",#,#,#,#,#,#,#,#,#,#,#,#,#,2750000

      [BLANK] "FY18","Budget","Working","21001","40601004",#,#,#,#,#,#,#,#,#,#,#,#,#,250000

      [BLANK] "FY18","Budget","Working","21001","40601005",#,#,#,#,#,#,#,#,#,#,#,#,#,13000000

      [BLANK] "FY18","Budget","Working","21001","40601006",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602001",#,#,#,#,#,#,#,#,#,#,#,#,#,500000

      [BLANK] "FY18","Budget","Working","21001","40602002",#,#,#,#,#,#,#,#,#,#,#,#,#,0

      [BLANK] "FY18","Budget","Working","21001","40602003",#,#,#,#,#,#,#,#,#,#,#,#,#,2500000

      [BLANK] "FY18","Budget","Working","21001","40602004",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40602005",#,#,#,#,#,#,#,#,#,#,#,#,#,45000

      [BLANK] "FY18","Budget","Working","21001","40602006",#,#,#,#,#,#,#,#,#,#,#,#,#,1250000

      [BLANK] "FY18","Budget","Working","21001","40602007",#,#,#,#,#,#,#,#,#,#,#,#,#,6000000

      [BLANK] "FY18","Budget","Working","21001","40602008",#,#,#,#,#,#,#,#,#,#,#,#,#,1500000

      [BLANK] "FY18","Budget","Working","21001","40603001",#,#,#,#,#,#,#,#,#,#,#,#,#,1700000

      Rows Loaded: 0

      Rows Rejected: 62

       

       

      2017-11-06 07:13:27,442 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start

      2017-11-06 07:13:27,442 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy

      2017-11-06 07:13:27,442 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

      2017-11-06 07:13:27,442 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 85620180331

      2017-11-06 07:13:27,442 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: BVBudget_856

      Extension: dat

      2017-11-06 07:13:27,443 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 85620180331.dat

      2017-11-06 07:13:27,444 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: BVBudget_856.dat

      2017-11-06 07:13:27,444 INFO  [AIF]: EPMFDM-140274:Message - File not deleted: /u03/inbox/data/BVBudget_856.dat

      2017-11-06 07:13:27,446 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:BVBudget_856-raghunandan.rao@bharatividyapeeth.edu-20171106_071327-1

      2017-11-06 07:13:27,448 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End

      2017-11-06 07:13:27,449 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

      2017-11-06 07:13:27,449 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 347

      2017-11-06 07:13:27,451 DEBUG [AIF]: FileData.importData - END

      2017-11-06 07:13:27,515 DEBUG [AIF]: CommData.postImportData - START

      2017-11-06 07:13:27,515 DEBUG [AIF]: CommData.updateTDATASEG_T - START

      2017-11-06 07:13:27,515 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    = 856

                AND en.process_id      = pp.process_id

                AND pp.IMP_ENTITY_NAME = en.file_entity_name

                order by en.entity_name_order

               

      2017-11-06 07:13:27,516 INFO  [AIF]:

      Import Data from Source for Period 'PRD_01-02'

      2017-11-06 07:13:27,517 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-06 07:13:27,517 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 = 31 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2018-03-31' AND tlp.RULE_ID = 46 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

         

      2017-11-06 07:13:27,518 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=31 AND CATKEY=3 AND PERIODKEY='2018-03-31' AND RULE_ID=46

             

      2017-11-06 07:13:27,520 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-11-06 07:13:27,520 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 = 31

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                  ORDER BY adim.BALANCE_COLUMN_NAME

                 

      2017-11-06 07:13:27,521 DEBUG [AIF]: 

                  UPDATE TDATASEG_T

                  SET AMOUNTX = AMOUNT, DATAX = NULL

                     ,ACCOUNTX = NULL

                     ,UD1X = NULL

                     ,UD3X = NULL

                  WHERE TDATASEG_T.LOADID = 856 AND TDATASEG_T.PARTITIONKEY = 31 AND TDATASEG_T.CATKEY = 3 AND TDATASEG_T.PERIODKEY = '2018-03-31'

                 

      2017-11-06 07:13:27,522 INFO  [AIF]: Generic Data Rows Imported from Source: 0

      2017-11-06 07:13:27,522 INFO  [AIF]: Total Data Rows Imported from Source: 0

      2017-11-06 07:13:27,522 DEBUG [AIF]: CommData.updateTDATASEG_T - END

      2017-11-06 07:13:27,522 DEBUG [AIF]: CommData.postImportData - END

      2017-11-06 07:13:27,543 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

      2017-11-06 07:13:27,543 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

      2017-11-06 07:13:27,543 DEBUG [AIF]:

              select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

              from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

              and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

             

      2017-11-06 07:13:27,544 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

      2017-11-06 07:13:27,545 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

      2017-11-06 07:13:27,565 DEBUG [AIF]: CommData.mapData - START

      2017-11-06 07:13:27,565 DEBUG [AIF]: CommData.insertTransProcessDetails - START

      2017-11-06 07:13:27,565 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, 'raghunandan.rao@bharatividyapeeth.edu' 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 = 856

                  AND PRIOR_PERIOD_FLAG = 'N'

                  GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

                ) q

                ORDER BY ENTITY_NAME_ORDER

               

      2017-11-06 07:13:27,567 DEBUG [AIF]: CommData.insertTransProcessDetails - END

      2017-11-06 07:13:27,567 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID < 856

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

             

      2017-11-06 07:13:27,569 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID < 856

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

             

      2017-11-06 07:13:27,570 DEBUG [AIF]:

              DELETE FROM AIF_PROCESS_PERIODS

              WHERE PROCESS_ID < 856

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

             

      2017-11-06 07:13:27,572 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

      2017-11-06 07:13:27,572 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

      2017-11-06 07:13:27,572 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 = 31

             

      2017-11-06 07:13:27,573 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

      2017-11-06 07:13:27,573 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 856, DATAKEY, 31 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 = 31

              AND ( RULE_ID IS NULL OR RULE_ID = 46 )

             

      2017-11-06 07:13:27,575 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 5

      2017-11-06 07:13:27,576 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

      2017-11-06 07:13:27,576 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 = 856

                AND atad.APPLICATION_ID = 38

                AND tdm.PARTITIONKEY = 31

                AND tdm.TDATAMAPTYPE = 'ERP'

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

                AND tdm.WHERECLAUSETYPE IS NULL

                UNION ALL

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

                      ,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 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 = 856

                AND atad.APPLICATION_ID = 38

                AND tdm.PARTITIONKEY = 31

                AND tdm.TDATAMAPTYPE = 'ERP'

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

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

              ) q

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

             

      2017-11-06 07:13:27,578 INFO  [AIF]:

      Map Data for Period 'PRD_01-02'

      2017-11-06 07:13:27,578 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-11-06 07:13:27,578 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 ('raghunandan.rao@bharatividyapeeth.edu' IS NULL) THEN LAST_UPDATED_BY ELSE 'raghunandan.rao@bharatividyapeeth.edu' END

             ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 856 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'PRD_01-02'

         

      2017-11-06 07:13:27,580 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-11-06 07:13:27,580 DEBUG [AIF]:

            SELECT COUNT(*) ROW_COUNT

            FROM TDATASEG_T

            WHERE LOADID = 856

            AND (PARTITIONKEY = 31 AND CATKEY = 3 AND PERIODKEY = '2018-03-31' AND RULE_ID = 46 AND VALID_FLAG = 'Y')

           

      2017-11-06 07:13:27,581 WARN  [AIF]: Warning: No records exist for Period 'PRD_01-02'

      2017-11-06 07:13:27,581 DEBUG [AIF]: Comm.updateProcessDetail - START

      2017-11-06 07:13:27,581 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 ('raghunandan.rao@bharatividyapeeth.edu' IS NULL) THEN LAST_UPDATED_BY ELSE 'raghunandan.rao@bharatividyapeeth.edu' END

             ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 856 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'PRD_01-02'

         

      2017-11-06 07:13:27,583 DEBUG [AIF]: Comm.updateProcessDetail - END

      2017-11-06 07:13:27,583 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-06 07:13:27,583 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=31 AND CATKEY=3 AND PERIODKEY='2018-03-31' AND RULE_ID=46

             

      2017-11-06 07:13:27,585 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-11-06 07:13:27,585 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

      2017-11-06 07:13:27,585 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

      2017-11-06 07:13:27,585 INFO  [AIF]:

      Stage Data for Period 'PRD_01-02'

      2017-11-06 07:13:27,585 DEBUG [AIF]:

              DELETE FROM TDATAMAPSEG

              WHERE PARTITIONKEY = 31

              AND CATKEY = 3

              AND PERIODKEY = '2018-03-31'

             

      2017-11-06 07:13:27,586 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 5

      2017-11-06 07:13:27,586 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, '2018-03-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                     WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

              FROM TDATAMAP_T

              WHERE LOADID = 856

             

      2017-11-06 07:13:27,587 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 5

      2017-11-06 07:13:27,587 DEBUG [AIF]:

              DELETE FROM TDATAMAP_T

              WHERE LOADID = 856

             

      2017-11-06 07:13:27,588 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 5

      2017-11-06 07:13:27,589 DEBUG [AIF]:

                  DELETE FROM TDATASEG

                  WHERE LOADID < 856 AND PARTITIONKEY = 31 AND CATKEY = 3 AND RULE_ID = 46 AND PERIODKEY = '2018-03-31'

                 

      2017-11-06 07:13:27,589 INFO  [AIF]: Number of Rows deleted from TDATASEG: 0

      2017-11-06 07:13:27,590 DEBUG [AIF]:

                  DELETE FROM TDATAMEMOITEMS

                  WHERE PARTITIONKEY = 31 AND PERIODKEY = '2018-03-31' AND CATKEY = 3 AND RULE_ID = 46

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

                 

      2017-11-06 07:13:27,590 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

      2017-11-06 07:13:27,590 DEBUG [AIF]:

                  DELETE FROM TDATAARCHIVE

                  WHERE PARTITIONKEY = 31 AND PERIODKEY = '2018-03-31' AND CATKEY = 3 AND RULE_ID = 46

                  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-11-06 07:13:27,591 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

      2017-11-06 07:13:27,592 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 = 856 AND PARTITIONKEY = 31 AND CATKEY = 3 AND PERIODKEY = '2018-03-31'

               

      2017-11-06 07:13:27,593 INFO  [AIF]: Number of Rows inserted into TDATASEG: 0

      2017-11-06 07:13:27,593 DEBUG [AIF]:

              DELETE FROM TDATASEG_T

              WHERE LOADID = 856 AND PARTITIONKEY = 31 AND CATKEY = 3 AND PERIODKEY = '2018-03-31'

             

      2017-11-06 07:13:27,594 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 0

      2017-11-06 07:13:27,594 DEBUG [AIF]: CommData.updateWorkflow - START

      2017-11-06 07:13:27,594 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

                 ,PROCESSIMPNOTE='Import Error'

              WHERE PARTITIONKEY=31 AND CATKEY=3 AND PERIODKEY='2018-03-31' AND RULE_ID=46

             

      2017-11-06 07:13:27,600 DEBUG [AIF]: CommData.updateWorkflow - END

      2017-11-06 07:13:27,601 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

      2017-11-06 07:13:27,601 DEBUG [AIF]: CommData.mapData - END

      2017-11-06 07:13:27,620 INFO  [AIF]: -------END IMPORT STEP-------

      2017-11-06 07:13:27,640 INFO  [AIF]: -------START VALIDATE STEP-------

      2017-11-06 07:13:27,660 DEBUG [AIF]: CommData.validateData - START

      2017-11-06 07:13:27,661 DEBUG [AIF]: CommMap.validateData - START

      2017-11-06 07:13:27,661 WARN  [AIF]: Warning: The Import step has not been completed for period PRD_01-02

      2017-11-06 07:13:27,661 DEBUG [AIF]: CommMap.validateData - END

      2017-11-06 07:13:27,662 WARN  [AIF]: Warning: The Import step has not been completed for period PRD_01-02

      2017-11-06 07:13:27,662 DEBUG [AIF]: CommData.validateData - END

      2017-11-06 07:13:27,681 INFO  [AIF]: -------END VALIDATE STEP-------

      2017-11-06 07:13:27,822 DEBUG [AIF]: Comm.finalizeProcess - START

      2017-11-06 07:13:27,822 DEBUG [AIF]: CommData.updateRuleStatus - START

      2017-11-06 07:13:27,822 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 = 856 AND pd.STATUS IN ('FAILED','WARNING') )

                WHEN 0 THEN 'SUCCESS'

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

            ELSE 'SUCCESS' END

          WHERE RULE_ID = 46

         

      2017-11-06 07:13:27,824 DEBUG [AIF]: CommData.updateRuleStatus - END

      2017-11-06 07:13:27,824 DEBUG [AIF]: Comm.updateProcess - START

      2017-11-06 07:13:27,825 DEBUG [AIF]: Comm.updateProcess - END

      2017-11-06 07:13:27,827 DEBUG [AIF]: The fdmAPI connection has been closed.

      2017-11-06 07:13:27,827 INFO  [AIF]: FDMEE Process End, Process ID: 856

       

      please help me to resolve this issue.