2022-09-30 14:38:27,080 INFO [AIF]: FDMEE Process: 15780, Log Level: 5 2022-09-30 14:38:27,080 INFO [AIF]: Location : BelcanExtractLoc (Partitionkey:93) 2022-09-30 14:38:27,080 INFO [AIF]: Period Name : Jun-22 (Period Key:6/30/22 12:00 AM) 2022-09-30 14:38:27,080 INFO [AIF]: Category Name: Actual (Category key:1) 2022-09-30 14:38:27,080 INFO [AIF]: Rule Name : BelcanExtract_Rule (Rule ID:131) 2022-09-30 14:38:29,375 DEBUG [AIF]: FDMEE Version: 22.09.05 2022-09-30 14:38:29,375 INFO [AIF]: Log File Encoding: UTF-8 2022-09-30 14:38:30,448 INFO [AIF]: -------START IMPORT STEP------- 2022-09-30 14:38:30,636 DEBUG [AIF]: CommData.preImportData - START 2022-09-30 14:38:30,637 DEBUG [AIF]: CommData.getRuleInfo - START 2022-09-30 14:38:30,645 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 = 37 LEFT OUTER JOIN TBHVIMPITEMERPI tiie ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP' WHERE tpp.PARTITIONKEY = 93 AND adim.BALANCE_COLUMN_NAME IS NOT NULL AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS' ORDER BY adim.BALANCE_COLUMN_NAME 2022-09-30 14:38:30,648 DEBUG [AIF]: SELECT property_value FROM aif_target_appl_properties WHERE application_id = 37 and property_type = 'WORKFLOW_MODE' 2022-09-30 14:38:30,650 DEBUG [AIF]: {'EXPORT_TO_TARGET_FLAG': u'Y', 'PLAN_NUMBER': 0L, 'SRC_TARGET_APP_NAME': u'BelcanFC', 'JOURNAL_FLAG': None, 'DIMNAME_MAP': {u'UD2': {'DIMNAME': u'UD2', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD1': {'DIMNAME': u'UD1', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD4': {'DIMNAME': u'UD4', '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'Generic'}, u'ENTITY': {'DIMNAME': u'ENTITY', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'ICP': {'DIMNAME': u'ICP', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}}, 'CATKEY': 1L, 'TGT_APP_SUB_TYPE': None, 'TGT_APP_ID': 37L, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'SRC_SOURCE_SYSTEM_ID': 0L, 'TGT_SOURCE_SYSTEM_TYPE': None, 'TGT_APP_TYPE': u'CUSTOM', 'CALENDAR_ID': None, 'TGT_TARGET_APP_NAME': u'BelcanExtract', 'PARTITIONKEY': 93L, 'EXECUTION_MODE': u'REPLACE', 'END_PERIODKEY': 2022-06-30, 'LEDGER_GROUP_CODE': u'NONE', 'SRC_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://us2pbcsr819116.usdc2.oraclecloud.com:9000/aif', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'SRC_APP_NAME': u'BelcanFC', 'LAST_UPDATED_BY': u'bsenesombath', 'CHECK_FLAG': u'Y', 'RULE_ID': 131L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SRC_APP_ID': u'6', 'IMPGROUPKEY': u'BelcanExtractFormat', 'WORKFLOW_MODE': 'FULL', 'TGT_SOURCE_SYSTEM_ID': 0L, 'SRC_APP_TYPE': u'HPL', 'TGT_APP_NAME': u'BelcanExtract', 'IMPGROUPFILETYPE': u'EPM_EPM', 'LEDGER_GROUP': None, 'TGT_COA_ID': 0L, 'RECALCULATE_FLAG': u'Y', 'TGT_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXPORT_MODE': u'NONE', 'SRC_SOURCE_SYSTEM_TYPE': u'EPM', 'PLAN_TYPE': None, 'TGT_METADATA_LOAD_METHOD': u'NA'} 2022-09-30 14:38:30,655 DEBUG [AIF]: {u'Intercompany': {'BCN': u'ICP', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Generic'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Generic'}, u'Movement': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Years': {'BCN': None, 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Multi-GAAP': {'BCN': u'UD3', 'DCN': u'Generic'}, u'View': {'BCN': None, 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Generic'}, u'Consolidation': {'BCN': None, 'DCN': u'Generic'}, u'Data Source': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Currency': {'BCN': None, 'DCN': u'Generic'}, u'SUBACCOUNT': {'BCN': u'UD2', 'DCN': u'Generic'}} 2022-09-30 14:38:30,657 DEBUG [AIF]: {u'UD2': {'IMPFLDSOURCECOLNAME': u'SUBACCOUNT'}, u'UD1': {'IMPFLDSOURCECOLNAME': u'Data Source'}, u'UD4': {'IMPFLDSOURCECOLNAME': u'Movement'}, u'UD3': {'IMPFLDSOURCECOLNAME': u'Multi-GAAP'}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': u'Account'}, u'ENTITY': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Amount'}, u'ICP': {'IMPFLDSOURCECOLNAME': u'Intercompany'}} 2022-09-30 14:38:30,657 DEBUG [AIF]: CommData.getRuleInfo - END 2022-09-30 14:38:30,657 DEBUG [AIF]: CommData.insertEpmPeriods - START 2022-09-30 14:38:30,660 DEBUG [AIF]: doAppPeriodMappingsExist - BelcanExtract: Y 2022-09-30 14:38:30,662 DEBUG [AIF]: doAppPeriodMappingsExist - BelcanFC: Y 2022-09-30 14:38:30,662 DEBUG [AIF]: Period mapping section: DEFAULT 2022-09-30 14:38:30,663 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 ,'BelcanFC_15780.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 = 'BelcanExtract' ) INNER JOIN TPOVPERIODADAPTOR_FLAT_V spp ON spp.PERIODFREQ = pc.CATFREQ AND spp.PERIODKEY > tpp.PRIORPERIODKEY AND spp.PERIODKEY <= tpp.PERIODKEY AND spp.INTSYSTEMKEY = 'BelcanFC' WHERE brl.LOADID = 15780 ORDER BY tpp.PERIODKEY, spp.PERIODKEY 2022-09-30 14:38:30,663 DEBUG [AIF]: periodSQL - periodParams: [u'BelcanFC_15780.dat', u'BelcanExtract', u'BelcanFC', 15780] 2022-09-30 14:38:30,666 DEBUG [AIF]: insertRowCount: 1 2022-09-30 14:38:30,669 DEBUG [AIF]: CommData.insertEpmPeriods - END 2022-09-30 14:38:30,669 DEBUG [AIF]: CommData.updateBalRuleLoadParams - START 2022-09-30 14:38:30,677 DEBUG [AIF]: yearDimensionName=Years, yearFilter="FY22" 2022-09-30 14:38:30,677 DEBUG [AIF]: periodDimensionName=Period, periodFilter="Jun" 2022-09-30 14:38:30,684 DEBUG [AIF]: CommData.updateBalRuleLoadParams - END 2022-09-30 14:38:30,684 DEBUG [AIF]: CommData.getPovList - START 2022-09-30 14:38:30,684 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 = 'BelcanExtract' 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 = 15780 ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID 2022-09-30 14:38:30,687 DEBUG [AIF]: CommData.getPovList - END 2022-09-30 14:38:30,687 DEBUG [AIF]: CommData.preImportData - END 2022-09-30 14:38:30,794 DEBUG [AIF]: CommData.extractDataFromSource - START 2022-09-30 14:38:30,794 DEBUG [AIF]: Comm.doScriptInit - START 2022-09-30 14:38:30,878 DEBUG [AIF]: fdmContext: {PERIODKEY=2022-06-30, CATKEY=1, APPNAME=BelcanExtract, EXPORTFLAG=Y, SOURCEID=0, TARGETAPPNAME=BelcanExtract, USERLOCALE=en, IMPORTFLAG=Y, DIRECT_FILE_LOAD_FLAG=null, SOURCENAME=EPM, PERIODNAME=Jun-22, LOCNAME=BelcanExtractLoc, USERNAME=bsenesombath, TARGETAPPTYPE=CUSTOM, TARGETAPPDB=null, FILEDIR=inbox, APPID=37, MULTIPERIODLOAD=N, BUSINESS_RULE_EXIST=Y, LOADID=15780, RULEID=131, IMPORTMODE=REPLACE, SOURCETYPE=EPM, CATNAME=Actual, RULENAME=BelcanExtract_Rule, LOCKEY=93, EXPORTMODE=null, IMPORTFORMAT=BelcanExtractFormat} 2022-09-30 14:38:30,881 DEBUG [AIF]: Comm.doScriptInit - END 2022-09-30 14:38:30,882 INFO [AIF]: Executing the following script: BefExtract.py 2022-09-30 14:38:30,896 DEBUG [AIF]: Executing Business Rule:BEGIN 2022-09-30 14:38:30,965 INFO [AIF]: No business rules found for load id:15,780 2022-09-30 14:38:30,968 DEBUG [AIF]: Executing Business Rule:END 2022-09-30 14:38:30,969 DEBUG [AIF]: AIFUtil.callOdiServlet - START 2022-09-30 14:38:31,006 INFO [AIF]: EssbaseService.extractData - START 2022-09-30 14:38:31,014 DEBUG [AIF]: appName:BelcanFC, cubeName:Consol, appType:HPL, mcFlag:false, workflowMode:FULL, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:true, isJournalLoad:false 2022-09-30 14:38:31,014 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, REPLACE_FOR_NON_ADMIN:NUMERIC 2022-09-30 14:38:31,021 DEBUG [AIF]: dataExtractOption: 1 2022-09-30 14:38:31,021 DEBUG [AIF]: We need to connect to Essbase server. 2022-09-30 14:38:31,234 DEBUG [AIF]: Extracting data from BelcanFC:Consol... 2022-09-30 14:38:31,561 DEBUG [AIF]: denseDimensions: Account 2022-09-30 14:38:31,561 DEBUG [AIF]: Updated dataColDimension to: Account 2022-09-30 14:38:31,594 INFO [AIF]: Extract Script (Calc): SET DataExportOptions { DATAEXPORTCOLFORMAT ON; DATAEXPORTDIMHEADER ON; DATAEXPORTDRYRUN OFF; DataExportRelationalFile OFF; DataExportNonExistingBlocks OFF; DataExportLevel ALL; DATAEXPORTCOLHEADER "Account"; DATAEXPORTOVERWRITEFILE ON; DataExportDynamicCalc ON; }; FIX ("FY22","FCCS_Periodic","Actual",@Relative("Total SUBACCOUNT",0),"Jun","FCCS_No Multi-GAAP",@Relative("FCCS_Movements",0),@Relative("Intercompany",0),@Relative("FCCS_Total Geography",0),"FCCS_Data Input",@Relative("Currency",0),@Relative("Consolidation",0),@Relative("FCCS_Income Statement",0)) DATAEXPORT "File" "," "/u03/inbox/data/BelcanFC_Consol_15780.txt" "#"; ENDFIX 2022-09-30 14:38:31,606 INFO [AIF]: List of exported files to be merged for file name BelcanFC_Consol_15780* 2022-09-30 14:38:31,607 INFO [AIF]: Number of files to be merged: 1 2022-09-30 14:38:31,627 INFO [AIF]: EssbaseService.extractData - END (true) 2022-09-30 14:38:31,650 DEBUG [AIF]: AIFUtil.callOdiServlet - END 2022-09-30 14:38:31,653 DEBUG [AIF]: CommData.extractDataFromSource - END 2022-09-30 14:38:31,712 DEBUG [AIF]: CommData.insertImportProcessDetails - START 2022-09-30 14:38:31,713 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, 'bsenesombath' 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 = 15780 ) q ORDER BY ENTITY_NAME_ORDER 2022-09-30 14:38:31,747 DEBUG [AIF]: Comm.doScriptInit - START 2022-09-30 14:38:31,825 DEBUG [AIF]: fdmContext: {PERIODKEY=2022-06-30, CATKEY=1, APPNAME=BelcanExtract, EXPORTFLAG=Y, SOURCEID=0, TARGETAPPNAME=BelcanExtract, USERLOCALE=en, IMPORTFLAG=Y, DIRECT_FILE_LOAD_FLAG=null, SOURCENAME=EPM, PERIODNAME=Jun-22, LOCNAME=BelcanExtractLoc, USERNAME=bsenesombath, TARGETAPPTYPE=CUSTOM, TARGETAPPDB=null, FILEDIR=data, APPID=37, MULTIPERIODLOAD=N, BUSINESS_RULE_EXIST=Y, LOADID=15780, RULEID=131, IMPORTMODE=REPLACE, SOURCETYPE=EPM, CATNAME=Actual, RULENAME=BelcanExtract_Rule, LOCKEY=93, EXPORTMODE=null, IMPORTFORMAT=BelcanExtractFormat} 2022-09-30 14:38:31,828 DEBUG [AIF]: Comm.doScriptInit - END 2022-09-30 14:38:31,828 INFO [AIF]: Executing the following script: BefImport.py 2022-09-30 14:38:31,921 DEBUG [AIF]: Executing Business Rule:BEGIN 2022-09-30 14:38:31,993 INFO [AIF]: No business rules found for load id:15,780 2022-09-30 14:38:31,997 DEBUG [AIF]: Executing Business Rule:END 2022-09-30 14:38:31,997 DEBUG [AIF]: CommData.insertImportProcessDetails - END 2022-09-30 14:38:32,051 DEBUG [AIF]: FileData.importData - START 2022-09-30 14:38:32,051 DEBUG [AIF]: Importing data for load id: 15780 2022-09-30 14:38:32,052 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 = 15780 AND a.start_periodkey=b.periodkey AND a.loadid =c.process_id AND br.rule_id = a.rule_id AND b.INTSYSTEMKEY = 'BelcanExtract' 2022-09-30 14:38:32,057 DEBUG [AIF]: FileData.py: Importing Text data for load id: 15780 2022-09-30 14:38:32,134 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:IMPGROUPFILETYPE::15780;93:1:131:[NONE]::EPM_EPM 2022-09-30 14:38:32,138 INFO [AIF]: EPMFDM-140274:Message - Essbase Version 5 Flag:false 2022-09-30 14:38:32,140 INFO [AIF]: EPMFDM-140274:Message - Method - getUser 2022-09-30 14:38:32,146 INFO [AIF]: EPMFDM-140274:Message - Method - getUser 2022-09-30 14:38:32,148 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8 2022-09-30 14:38:32,148 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start 2022-09-30 14:38:32,148 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 2022-09-30 14:38:32,472 INFO [AIF]: EPMFDM-140274:Message - Fetched dense dimension for FCCS :Account from load method:CLASSIC_VIA_EPMI 2022-09-30 14:38:32,474 INFO [AIF]: EPMFDM-140274:Message - Data Export dynamic calc is :1 2022-09-30 14:38:32,474 INFO [AIF]: EPMFDM-140274:Message - Returning isFccsTrcsSource with value:true 2022-09-30 14:38:32,474 INFO [AIF]: EPMFDM-140274:Message - Retrieved Sorce Application Type:HPL with sub type:FCCS 2022-09-30 14:38:32,474 INFO [AIF]: EPMFDM-140274:Message - Is source application sub type FCCS/TRCS :true 2022-09-30 14:38:32,476 INFO [AIF]: EPMFDM-140274:Message - Checking MDX execution with parameters Source Application Type:HPL , Source Application Sub Type:FCCS , Source App Data Load Method:CLASSIC_VIA_EPMI 2022-09-30 14:38:32,476 INFO [AIF]: EPMFDM-140274:Message - Is data load MDX File Import :false 2022-09-30 14:38:32,483 DEBUG [AIF]: EPMFDM-140274:Message - glPeriodName is :Jun 2022-09-30 14:38:32,483 DEBUG [AIF]: EPMFDM-140274:Message - glYearName is :FY22 2022-09-30 14:38:32,543 DEBUG [AIF]: Script- getRuleInfo 2022-09-30 14:38:32,566 DEBUG [AIF]: Period Dim Name:Period 2022-09-30 14:38:32,568 DEBUG [AIF]: FILE_CHARSET_ENCODING: UTF-8 2022-09-30 14:38:32,568 DEBUG [AIF]: SELECT fl.impgroupkey, fl.impfldfieldname, fl.impfldfixedtext, fl.impfldstartpos, fl.impfldlength, fl.impfldsourcecolname, ig.impgroupfiletype, ig.impgroupdelimiter, fl.impfldfieldname FROM tbhvimpgroup ig, tbhvimpitemfile fl, tpovpartition part, aif_processes pr, aif_balance_rules b WHERE pr.process_id = ? AND part.partitionkey = pr.partitionkey AND coalesce(b.IMPGROUPKEY,part.PARTIMPGROUP) = ig.impgroupkey AND ig.impgroupkey = fl.impgroupkey AND b.rule_id = pr.rule_id AND (fl.impfldfieldname =DATA OR fl.impfldfieldname =AMOUNT) AND fl.impfldfixedtext is not null 2022-09-30 14:38:32,569 DEBUG [AIF]: BOM exists 2022-09-30 14:38:32,569 DEBUG [AIF]: After removing BOM ["Period","Consolidation","Data Source","Currency","Intercompany","Movement","Multi-GAAP","SUBACCOUNT","Scenario","Years","View","Entity","Account"] 2022-09-30 14:38:32,919 INFO [AIF]: EPMFDM-140274:Message - Fetched dense dimension for FCCS :Account from load method:CLASSIC_VIA_EPMI 2022-09-30 14:38:32,921 INFO [AIF]: EPMFDM-140274:Message - Data Export dynamic calc is :1 2022-09-30 14:38:32,922 INFO [AIF]: EPMFDM-140274:Message - Returning isFccsTrcsSource with value:true 2022-09-30 14:38:32,922 INFO [AIF]: EPMFDM-140274:Message - Parser type is:2 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT13:ImpFieldText=null:StartPos=13:SourceClName=Amount:ImpFldTargetExp=null 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=13:SourceClName=Account:ImpFldTargetExp=null 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=12:SourceClName=Entity:ImpFldTargetExp=null 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=3:SourceClName=Data Source:ImpFldTargetExp=null 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=5:SourceClName=Intercompany:ImpFldTargetExp=null 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=6:SourceClName=Movement:ImpFldTargetExp=null 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=7:SourceClName=Multi-GAAP:ImpFldTargetExp=null 2022-09-30 14:38:32,928 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=8:SourceClName=SUBACCOUNT:ImpFldTargetExp=null 2022-09-30 14:38:32,931 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps 2022-09-30 14:38:32,931 INFO [AIF]: EPMFDM-140274:Message - File Name BelcanFC_15780.dat periodKey2022-06-30 GL PeriodNameJun 2022-09-30 14:38:32,931 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=4:SourceClName=Currency:ImpFldTargetExp=null 2022-09-30 14:38:32,933 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR2:ImpFieldText=null:StartPos=1:SourceClName=Period:ImpFldTargetExp=null 2022-09-30 14:38:32,934 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR3:ImpFieldText=null:StartPos=10:SourceClName=Years:ImpFldTargetExp=null 2022-09-30 14:38:32,938 DEBUG [AIF]: BOM exists 2022-09-30 14:38:32,938 DEBUG [AIF]: After removing BOM ["Period","Consolidation","Data Source","Currency","Intercompany","Movement","Multi-GAAP","SUBACCOUNT","Scenario","Years","View","Entity","Account"] 2022-09-30 14:38:32,938 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 15780 PARTITIONKEY: 93 IMPORT GROUP: BelcanExtractFormat FILE TYPE: MULTIPERIOD DELIMITER: , SOURCE FILE: BelcanFC_15780.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. Rows Loaded: 0 Rows Rejected: 0 2022-09-30 14:38:32,938 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start 2022-09-30 14:38:32,940 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy 2022-09-30 14:38:32,940 INFO [AIF]: EPMFDM-140274:Message - Start archiving file: 2022-09-30 14:38:32,940 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 1578020220630 2022-09-30 14:38:32,940 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: BelcanFC_15780 Extension: dat 2022-09-30 14:38:32,942 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 1578020220630.dat 2022-09-30 14:38:32,944 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: BelcanFC_15780.dat 2022-09-30 14:38:32,944 INFO [AIF]: EPMFDM-140274:Message - File not deleted: BelcanFC_15780.dat 2022-09-30 14:38:32,946 INFO [AIF]: EPMFDM-140274:Message - Method - getUser 2022-09-30 14:38:32,946 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:BelcanFC_15780-bsenesombath-20220930_143832-1 2022-09-30 14:38:32,946 INFO [AIF]: EPMFDM-140274:Message - Method - getUser 2022-09-30 14:38:32,951 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End 2022-09-30 14:38:32,952 DEBUG [AIF]: EPMFDM-140274:Message - Script- updateMultiPeriodProcessDetail- Start 2022-09-30 14:38:32,954 WARN [AIF]: 0 records imported for the period:Jun-22 2022-09-30 14:38:32,959 DEBUG [AIF]: EPMFDM-140274:Message - Script- updateMultiPeriodProcessDetail- End 2022-09-30 14:38:32,959 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start 2022-09-30 14:38:32,961 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy 2022-09-30 14:38:32,961 INFO [AIF]: EPMFDM-140274:Message - Start archiving file: 2022-09-30 14:38:32,961 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 1578020220630 2022-09-30 14:38:32,961 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: BelcanFC_15780 Extension: dat 2022-09-30 14:38:32,963 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 1578020220630.dat 2022-09-30 14:38:32,964 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: BelcanFC_15780.dat 2022-09-30 14:38:32,964 INFO [AIF]: EPMFDM-140274:Message - File not deleted: BelcanFC_15780.dat 2022-09-30 14:38:32,966 INFO [AIF]: EPMFDM-140274:Message - Method - getUser 2022-09-30 14:38:32,966 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:BelcanFC_15780-bsenesombath-20220930_143832-2 2022-09-30 14:38:32,967 INFO [AIF]: EPMFDM-140274:Message - Method - getUser 2022-09-30 14:38:32,976 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End 2022-09-30 14:38:32,976 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End 2022-09-30 14:38:32,976 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 828 2022-09-30 14:38:32,978 DEBUG [AIF]: FileData.importData - END 2022-09-30 14:38:33,139 DEBUG [AIF]: CommData.postImportData - START 2022-09-30 14:38:33,139 DEBUG [AIF]: CommData.updateTDATASEG_T - START 2022-09-30 14:38:33,139 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 = 15780 AND en.process_id = pp.process_id AND pp.IMP_ENTITY_NAME = en.file_entity_name order by en.entity_name_order 2022-09-30 14:38:33,142 INFO [AIF]: Import Data from Source for Period 'Jun-22' 2022-09-30 14:38:33,142 DEBUG [AIF]: CommData.updateWorkflow - START 2022-09-30 14:38:33,146 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 = 93 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2022-06-30' AND tlp.RULE_ID = 131 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS 2022-09-30 14:38:33,149 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,LOADID=15780 WHERE PARTITIONKEY=93 AND CATKEY=1 AND PERIODKEY='2022-06-30' AND RULE_ID=131 2022-09-30 14:38:33,154 DEBUG [AIF]: CommData.updateWorkflow - END 2022-09-30 14:38:33,156 DEBUG [AIF]: CommData.updateTDATASEG_T - END 2022-09-30 14:38:33,158 INFO [AIF]: Executing the following script: AftImport.py 2022-09-30 14:38:33,161 DEBUG [AIF]: Executing Business Rule:BEGIN 2022-09-30 14:38:33,238 INFO [AIF]: No business rules found for load id:15,780 2022-09-30 14:38:33,241 DEBUG [AIF]: Executing Business Rule:END 2022-09-30 14:38:33,241 DEBUG [AIF]: CommData.postImportData - END 2022-09-30 14:38:33,294 DEBUG [AIF]: LogicGroup.createLogicAccounts - START 2022-09-30 14:38:33,295 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START 2022-09-30 14:38:33,295 DEBUG [AIF]: select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp where prs.PROCESS_ID=15780 and prs.PARTITIONKEY=part.PARTITIONKEY and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 2022-09-30 14:38:33,298 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END 2022-09-30 14:38:33,302 DEBUG [AIF]: LogicGroup.createLogicAccounts - END 2022-09-30 14:38:33,361 DEBUG [AIF]: CommData.mapData - START 2022-09-30 14:38:33,361 DEBUG [AIF]: CommData.insertTransProcessDetails - START 2022-09-30 14:38:33,361 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, 'bsenesombath' 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 = 15780 AND PRIOR_PERIOD_FLAG = 'N' GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME ) q ORDER BY ENTITY_NAME_ORDER 2022-09-30 14:38:33,370 DEBUG [AIF]: CommData.insertTransProcessDetails - END 2022-09-30 14:38:33,370 DEBUG [AIF]: DELETE FROM TDATAMAP_T WHERE LOADID < 15780 AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 131 AND p.PROCESS_ID = TDATAMAP_T.LOADID ) 2022-09-30 14:38:33,376 DEBUG [AIF]: SELECT COUNT(*) FROM TDATASEG_T WHERE LOADID < 15780 AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 131 AND p.PROCESS_ID = TDATASEG_T.LOADID ) 2022-09-30 14:38:33,378 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False 2022-09-30 14:38:33,380 INFO [AIF]: Executing delete statement: 2022-09-30 14:38:33,380 DEBUG [AIF]: DELETE FROM TDATASEG_T WHERE LOADID < 15780 AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 131 AND p.PROCESS_ID = TDATASEG_T.LOADID ) 2022-09-30 14:38:33,385 INFO [AIF]: Successfully executed delete statement 2022-09-30 14:38:33,387 DEBUG [AIF]: DELETE FROM AIF_PROCESS_PERIODS WHERE PROCESS_ID < 15780 AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 131 AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID ) 2022-09-30 14:38:33,393 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START 2022-09-30 14:38:33,393 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START 2022-09-30 14:38:33,393 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 = 93 2022-09-30 14:38:33,395 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END 2022-09-30 14:38:33,396 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 15780, DATAKEY, 93 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '' THEN ' ' ELSE TARGKEY END ,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID FROM TDATAMAP WHERE PARTITIONKEY = 93 AND ( RULE_ID IS NULL OR RULE_ID = 131 ) 2022-09-30 14:38:33,398 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 7 2022-09-30 14:38:33,401 DEBUG [AIF]: CommMap.loadTDATAMAP_T - END 2022-09-30 14:38:33,401 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START 2022-09-30 14:38:33,403 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 = 15780 AND atad.APPLICATION_ID = 37 AND tdm.PARTITIONKEY = 93 AND tdm.TDATAMAPTYPE = 'ERP' AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 131) 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 = 15780 AND atad.APPLICATION_ID = 37 AND tdm.PARTITIONKEY = 93 AND tdm.TDATAMAPTYPE = 'ERP' AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 131) AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE') ) q ORDER BY CALC_SEQ, DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY 2022-09-30 14:38:33,409 INFO [AIF]: Map Data for Period 'Jun-22' 2022-09-30 14:38:33,409 DEBUG [AIF]: Comm.updateProcessDetail - START 2022-09-30 14:38:33,410 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 ('bsenesombath' IS NULL) THEN LAST_UPDATED_BY ELSE 'bsenesombath' END ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP WHERE PROCESS_ID = 15780 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jun-22' 2022-09-30 14:38:33,414 DEBUG [AIF]: Comm.updateProcessDetail - END 2022-09-30 14:38:33,415 DEBUG [AIF]: SELECT COUNT(*) ROW_COUNT FROM TDATASEG_T WHERE LOADID = 15780 AND (PARTITIONKEY = 93 AND CATKEY = 1 AND PERIODKEY = '2022-06-30' AND RULE_ID = 131 AND VALID_FLAG = 'Y') 2022-09-30 14:38:33,417 WARN [AIF]: Warning: No records exist for Period 'Jun-22' 2022-09-30 14:38:33,417 DEBUG [AIF]: Comm.updateProcessDetail - START 2022-09-30 14:38:33,417 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 ('bsenesombath' IS NULL) THEN LAST_UPDATED_BY ELSE 'bsenesombath' END ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP WHERE PROCESS_ID = 15780 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jun-22' 2022-09-30 14:38:33,422 DEBUG [AIF]: Comm.updateProcessDetail - END 2022-09-30 14:38:33,422 DEBUG [AIF]: CommData.updateWorkflow - START 2022-09-30 14:38:33,422 DEBUG [AIF]: UPDATE TLOGPROCESS SET PROCESSENDTIME=CURRENT_TIMESTAMP ,PROCESSSTATUS=2,PROCESSIMP=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0 ,PROCESSIMPNOTE='AIF_WF_IMP_IMPORT_ERR',LOADID=15780 WHERE PARTITIONKEY=93 AND CATKEY=1 AND PERIODKEY='2022-06-30' AND RULE_ID=131 2022-09-30 14:38:33,427 DEBUG [AIF]: CommData.updateWorkflow - END 2022-09-30 14:38:33,427 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END 2022-09-30 14:38:33,427 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START 2022-09-30 14:38:33,429 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False 2022-09-30 14:38:33,429 INFO [AIF]: Stage Data for Period 'Jun-22' 2022-09-30 14:38:33,430 DEBUG [AIF]: DELETE FROM TDATAMAPSEG WHERE PARTITIONKEY = 93 AND CATKEY = 1 AND PERIODKEY = '2022-06-30' 2022-09-30 14:38:33,437 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 7 2022-09-30 14:38:33,437 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, 1, '2022-06-30', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG FROM TDATAMAP_T WHERE LOADID = 15780 2022-09-30 14:38:33,443 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 7 2022-09-30 14:38:33,443 DEBUG [AIF]: DELETE FROM TDATAMAP_T WHERE LOADID = 15780 2022-09-30 14:38:33,446 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 7 2022-09-30 14:38:33,451 INFO [AIF]: Executing delete statement: 2022-09-30 14:38:33,451 DEBUG [AIF]: DELETE FROM TDATASEG WHERE LOADID < 15780 AND PARTITIONKEY = 93 AND CATKEY = 1 AND RULE_ID = 131 AND PERIODKEY = '2022-06-30' 2022-09-30 14:38:33,455 INFO [AIF]: Successfully executed delete statement 2022-09-30 14:38:33,455 INFO [AIF]: Number of Rows deleted from TDATASEG: 0 2022-09-30 14:38:33,457 DEBUG [AIF]: DELETE FROM TDATAMEMOITEMS WHERE PARTITIONKEY = 93 AND PERIODKEY = '2022-06-30' AND CATKEY = 1 AND RULE_ID = 131 AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY) 2022-09-30 14:38:33,459 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0 2022-09-30 14:38:33,460 DEBUG [AIF]: DELETE FROM TDATAARCHIVE WHERE PARTITIONKEY = 93 AND PERIODKEY = '2022-06-30' AND CATKEY = 1 AND RULE_ID = 131 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 ) 2022-09-30 14:38:33,462 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0 2022-09-30 14:38:33,466 INFO [AIF]: Executing insert statement: 2022-09-30 14:38:33,466 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 ,ATTR15, ATTR16, ATTR17, ATTR18, ATTR19, ATTR20, ATTR21, ATTR22, ATTR23, ATTR24, ATTR25, ATTR26, ATTR27 ,ATTR28, ATTR29, ATTR30, ATTR31, ATTR32, ATTR33, ATTR34, ATTR35, ATTR36, ATTR37, ATTR38, ATTR39, ATTR40 ,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 ,ATTR15, ATTR16, ATTR17, ATTR18, ATTR19, ATTR20, ATTR21, ATTR22, ATTR23, ATTR24, ATTR25, ATTR26, ATTR27 ,ATTR28, ATTR29, ATTR30, ATTR31, ATTR32, ATTR33, ATTR34, ATTR35, ATTR36, ATTR37, ATTR38, ATTR39, ATTR40 ,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID, STAT_BALANCE_FLAG, VALID_FLAG FROM TDATASEG_T WHERE LOADID = 15780 AND PARTITIONKEY = 93 AND CATKEY = 1 AND PERIODKEY = '2022-06-30' 2022-09-30 14:38:33,470 INFO [AIF]: Successfully executed insert statement 2022-09-30 14:38:33,470 INFO [AIF]: Number of Rows inserted into TDATASEG: 0 2022-09-30 14:38:33,474 INFO [AIF]: Executing delete statement: 2022-09-30 14:38:33,474 DEBUG [AIF]: DELETE FROM TDATASEG_T WHERE LOADID = 15780 AND PARTITIONKEY = 93 AND CATKEY = 1 AND PERIODKEY = '2022-06-30' 2022-09-30 14:38:33,478 INFO [AIF]: Successfully executed delete statement 2022-09-30 14:38:33,478 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 0 2022-09-30 14:38:33,480 DEBUG [AIF]: CommData.updateWorkflow - START 2022-09-30 14:38:33,481 DEBUG [AIF]: UPDATE TLOGPROCESS SET PROCESSENDTIME=CURRENT_TIMESTAMP ,PROCESSSTATUS=2,PROCESSIMP=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0 ,PROCESSIMPNOTE='Import Error',LOADID=15780 WHERE PARTITIONKEY=93 AND CATKEY=1 AND PERIODKEY='2022-06-30' AND RULE_ID=131 2022-09-30 14:38:33,485 DEBUG [AIF]: CommData.updateWorkflow - END 2022-09-30 14:38:33,487 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END 2022-09-30 14:38:33,488 DEBUG [AIF]: CommData.mapData - END 2022-09-30 14:38:33,535 INFO [AIF]: -------END IMPORT STEP------- 2022-09-30 14:38:33,582 INFO [AIF]: -------START VALIDATE STEP------- 2022-09-30 14:38:33,631 DEBUG [AIF]: CommData.validateData - START 2022-09-30 14:38:33,632 DEBUG [AIF]: CommMap.validateData - START 2022-09-30 14:38:33,635 WARN [AIF]: Warning: The Import step has not been completed for period Jun-22 2022-09-30 14:38:33,635 DEBUG [AIF]: CommMap.validateData - END 2022-09-30 14:38:33,637 WARN [AIF]: Warning: The Import step has not been completed for period Jun-22 2022-09-30 14:38:33,637 DEBUG [AIF]: CommData.validateData - END 2022-09-30 14:38:33,685 INFO [AIF]: -------END VALIDATE STEP------- 2022-09-30 14:38:33,777 INFO [AIF]: -------START EXPORT STEP------- 2022-09-30 14:38:33,830 DEBUG [AIF]: CommData.exportData - START 2022-09-30 14:38:33,833 WARN [AIF]: Warning: The Validate step has not been completed for period Jun-22 2022-09-30 14:38:33,833 DEBUG [AIF]: CommData.exportCustomAppData - START 2022-09-30 14:38:33,833 DEBUG [AIF]: Comm.createProcessDetail - START 2022-09-30 14:38:33,833 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 ) VALUES ( 15780, 'PROCESS_BAL_EXP_CUSTOM', NULL, 'BelcanExtract', NULL, NULL, CURRENT_TIMESTAMP ,NULL, NULL, 'RUNNING', 'bsenesombath', CURRENT_TIMESTAMP ) 2022-09-30 14:38:33,838 DEBUG [AIF]: Comm.createProcessDetail - END 2022-09-30 14:38:33,838 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 15780 and parameter_name = 'COLUMN_DELIMITER' 2022-09-30 14:38:33,840 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 15780 and parameter_name = 'FILE_CHARSET_ENCODING' 2022-09-30 14:38:33,843 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 15780 and parameter_name = 'ENABLE_EXPORT_TO_FILE' 2022-09-30 14:38:33,845 DEBUG [AIF]: Load options: columnDelimiter=,, fileCharsetEncoding=UTF-8, enableExportToFile=1 2022-09-30 14:38:33,845 DEBUG [AIF]: SELECT adim.TARGET_DIMENSION_NAME ,CASE adim.TARGET_DIMENSION_CLASS_NAME WHEN 'Scenario' THEN 'SCENARIO' WHEN 'Year' THEN 'YEAR' WHEN 'Period' THEN 'PERIOD' WHEN 'Currency' THEN 'CURRENCY' ELSE adim.BALANCE_COLUMN_NAME END BALANCE_COLUMN_NAME ,adim.TARGET_DIMENSION_CLASS_NAME FROM AIF_TARGET_APPLICATIONS app ,AIF_TARGET_APPL_DIMENSIONS adim ,AIF_BAL_RULE_LOADS brl WHERE app.TARGET_APPLICATION_NAME = 'BelcanExtract' AND adim.APPLICATION_ID = app.APPLICATION_ID AND adim.TARGET_DIMENSION_CLASS_NAME IN ( SELECT lv.LOOKUP_CODE FROM AIF_LOOKUP_TYPES lt ,AIF_LOOKUP_VALUES lv WHERE lt.LOOKUP_TYPE = 'AIF_APPL_DIM_CLASS' AND lv.LOOKUP_TYPE_ID = lt.LOOKUP_TYPE_ID ) AND adim.TARGET_DIMENSION_CLASS_NAME <> 'Attribute' AND brl.LOADID = 15780 AND brl.APPLICATION_ID = app.APPLICATION_ID ORDER BY CASE WHEN adim.TARGET_DIMENSION_CLASS_NAME = 'Scenario' THEN 'Z1' WHEN adim.TARGET_DIMENSION_CLASS_NAME = 'Year' THEN 'Z2' WHEN adim.TARGET_DIMENSION_CLASS_NAME = 'Period' THEN 'Z3' WHEN adim.TARGET_DIMENSION_CLASS_NAME = 'Currency' THEN 'Z4' WHEN adim.BALANCE_COLUMN_NAME LIKE 'UD_' THEN REPLACE(adim.BALANCE_COLUMN_NAME, 'UD', 'UD0') ELSE adim.BALANCE_COLUMN_NAME END 2022-09-30 14:38:33,848 DEBUG [AIF]: Comm.updateProcessDetail - START 2022-09-30 14:38:33,848 DEBUG [AIF]: UPDATE AIF_PROCESS_DETAILS SET STATUS = 'FAILED' ,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 ('bsenesombath' IS NULL) THEN LAST_UPDATED_BY ELSE 'bsenesombath' END ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP WHERE PROCESS_ID = 15780 AND ENTITY_TYPE = 'PROCESS_BAL_EXP_CUSTOM' AND ENTITY_NAME = 'BelcanExtract' 2022-09-30 14:38:33,855 DEBUG [AIF]: Comm.updateProcessDetail - END 2022-09-30 14:38:33,856 FATAL [AIF]: Error in CommData.exportCustomAppData Traceback (most recent call last): File "", line 1284, in exportCustomAppData TypeError: cannot concatenate 'unicode' and 'NoneType' objects 2022-09-30 14:38:33,856 FATAL [AIF]: Error in CommData.exportData Traceback (most recent call last): File "", line 2306, in exportData File "", line 1284, in exportCustomAppData TypeError: cannot concatenate 'unicode' and 'NoneType' objects 2022-09-30 14:38:33,983 DEBUG [AIF]: Comm.finalizeProcess - START 2022-09-30 14:38:33,983 DEBUG [AIF]: CommData.updateRuleStatus - START 2022-09-30 14:38:33,983 DEBUG [AIF]: UPDATE AIF_BALANCE_RULES SET STATUS = CASE 'FAILED' WHEN 'SUCCESS' THEN CASE ( SELECT COUNT(*) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 15780 AND pd.STATUS IN ('FAILED','WARNING') ) WHEN 0 THEN 'SUCCESS' ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 15780 AND pd.STATUS IN ('FAILED','WARNING') ) END ELSE 'FAILED' END WHERE RULE_ID = 131 2022-09-30 14:38:33,989 DEBUG [AIF]: CommData.updateRuleStatus - END 2022-09-30 14:38:33,989 FATAL [AIF]: Error in COMM Export Data 2022-09-30 14:38:33,989 DEBUG [AIF]: Comm.updateProcess - START 2022-09-30 14:38:33,994 DEBUG [AIF]: Comm.updateProcess - END 2022-09-30 14:38:33,997 DEBUG [AIF]: The fdmAPI connection has been closed. 2022-09-30 14:38:33,997 DEBUG [AIF]: Comm.finalizeProcess - END 2022-09-30 14:38:33,997 INFO [AIF]: FDMEE Process End, Process ID: 15780