Hi,
I am testing data load using open interface in FDMEE and the import fails at Transform and stage balance data to export with the message 'No records exist for Period'. I have checked the period mapping, batch name etc.@ and everything seems to be correct. Can you please help me to solve this issue.
Thanks in advance,
AK
Log file:
2017-02-22 08:40:37,284 INFO [AIF]: FDMEE Process: 1309, Log Level: 5, Log File: D:\FDMEEApps\TestHFM5\outbox\logs\TestHFM1_1309.log
2017-02-22 08:40:37,284 INFO [AIF]: Location : FINREP_OI (Partitionkey:120)
2017-02-22 08:40:37,284 INFO [AIF]: Period Name : Jan-2017 (Period Key:1/31/17 12:00 AM)
2017-02-22 08:40:37,284 INFO [AIF]: Category Name: Actual (Category key:1)
2017-02-22 08:40:37,285 INFO [AIF]: Rule Name : FinRep_Load (Rule ID:86)
2017-02-22 08:40:39,315 INFO [AIF]: FDM Version: 11.1.2.4.200
2017-02-22 08:40:39,315 INFO [AIF]: Log File Encoding: UTF-8
2017-02-22 08:40:41,984 INFO [AIF]: -------START IMPORT STEP-------
2017-02-22 08:40:42,057 DEBUG [AIF]: CommData.preImportData - START
2017-02-22 08:40:42,063 DEBUG [AIF]: CommData.getRuleInfo - START
2017-02-22 08:40:42,069 DEBUG [AIF]:
SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1
FROM TPOVPARTITION tpp
INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim
ON adim.APPLICATION_ID = 22
INNER JOIN AIF_DIMENSIONS dim
ON dim.DIMENSION_ID = adim.DIMENSION_ID
LEFT OUTER JOIN TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 120
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2017-02-22 08:40:42,071 DEBUG [AIF]: {'APPLICATION_ID': 22L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'FinRep_Load', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epm_all', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'TestHFM1', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 25L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 123L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 127L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 122L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 124L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 126L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 120L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 125L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 120L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'IMPGROUPFILETYPE': u'ODI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 86L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://DON-HYCPW01.don.s365.us:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 22L, 'IMPTARGETSOURCESYSTEMID': 0L}
2017-02-22 08:40:42,072 DEBUG [AIF]: CommData.getRuleInfo - END
2017-02-22 08:40:42,092 DEBUG [AIF]: CommData.insertPeriods - START
2017-02-22 08:40:42,096 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2017-02-22 08:40:42,096 DEBUG [AIF]: CommData.getLedgerSQL - START
2017-02-22 08:40:42,097 DEBUG [AIF]: CommData.getLedgerSQL - END
2017-02-22 08:40:42,097 DEBUG [AIF]:
SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID, NULL SOURCE_LEDGER_NAME, NULL SOURCE_COA_ID
,br.CALENDAR_ID, NULL SETID, NULL PERIOD_TYPE, NULL LEDGER_TABLE_NAME
FROM AIF_BALANCE_RULES br
WHERE br.RULE_ID = 86
2017-02-22 08:40:42,098 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2017-02-22 08:40:42,101 DEBUG [AIF]: doAppPeriodMappingsExist - TestHFM1: N
2017-02-22 08:40:42,101 DEBUG [AIF]: Period mapping section: ERPI/EXPLICIT/BUDGET/APFY
2017-02-22 08:40:42,101 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_PERIODS (
PROCESS_ID
,PERIODKEY
,PERIOD_ID
,ADJUSTMENT_PERIOD_FLAG
,GL_PERIOD_YEAR
,GL_PERIOD_NUM
,GL_PERIOD_NAME
,GL_PERIOD_CODE
,GL_EFFECTIVE_PERIOD_NUM
,YEARTARGET
,PERIODTARGET
,IMP_ENTITY_TYPE
,IMP_ENTITY_ID
,IMP_ENTITY_NAME
,TRANS_ENTITY_TYPE
,TRANS_ENTITY_ID
,TRANS_ENTITY_NAME
,PRIOR_PERIOD_FLAG
,SOURCE_LEDGER_ID
)
SELECT DISTINCT brl.LOADID PROCESS_ID
,pp.PERIODKEY PERIODKEY
,prd.PERIOD_ID
,COALESCE(prd.ADJUSTMENT_PERIOD_FLAG, 'N') ADJUSTMENT_PERIOD_FLAG
,COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) GL_PERIOD_YEAR
,COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) GL_PERIOD_NUM
,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0') GL_PERIOD_NAME
,COALESCE(prd.PERIOD_CODE, CAST(COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0) AS VARCHAR(38)),'0') GL_PERIOD_CODE
,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) GL_EFFECTIVE_PERIOD_NUM
,pp.YEARTARGET YEARTARGET
,pp.PERIODTARGET PERIODTARGET
,'PROCESS_BAL_IMP' IMP_ENTITY_TYPE
,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) IMP_ENTITY_ID
,COALESCE(prd.PERIOD_NAME, ppsrc.GL_PERIOD_NAME,'0')||' ('||pp.PERIODDESC||')' IMP_ENTITY_NAME
,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE
,(COALESCE(prd.YEAR, ppsrc.GL_PERIOD_YEAR,0) * 10000 + COALESCE(prd.PERIOD_NUM, ppsrc.GL_PERIOD_NUM,0)) TRANS_ENTITY_ID
,pp.PERIODDESC TRANS_ENTITY_NAME
,'N' PRIOR_PERIOD_FLAG
,0 SOURCE_LEDGER_ID
FROM (
AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIOD_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ
AND pp.PERIODKEY >= brl.START_PERIODKEY
AND pp.PERIODKEY <= brl.END_PERIODKEY
)
INNER JOIN TPOVPERIODSOURCE ppsrc
ON ppsrc.PERIODKEY = pp.PERIODKEY
AND ppsrc.MAPPING_TYPE = 'EXPLICIT'
AND ppsrc.SOURCE_SYSTEM_ID = 25
AND ppsrc.CALENDAR_ID IN ('FINCAL')
LEFT OUTER JOIN AIF_GL_PERIODS_STG prd
ON prd.PERIOD_ID = ppsrc.PERIOD_ID
AND prd.SOURCE_SYSTEM_ID = ppsrc.SOURCE_SYSTEM_ID
AND prd.CALENDAR_ID = ppsrc.CALENDAR_ID
AND prd.ADJUSTMENT_PERIOD_FLAG = 'N'
WHERE brl.LOADID = 1309
ORDER BY pp.PERIODKEY
,GL_EFFECTIVE_PERIOD_NUM
2017-02-22 08:40:42,101 DEBUG [AIF]: periodSQL - periodParams: ['N', 'PROCESS_BAL_IMP', 'PROCESS_BAL_TRANS', 0L, u'EXPLICIT', 25L, u'FINCAL', 'N', 1309]
2017-02-22 08:40:42,103 DEBUG [AIF]: insertRowCount: 1
2017-02-22 08:40:42,105 DEBUG [AIF]: CommData.insertPeriods - END
2017-02-22 08:40:42,108 DEBUG [AIF]: CommData.getPovList - START
2017-02-22 08:40:42,108 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 TPOVPERIOD pp
ON pp.PERIODKEY = pprd.PERIODKEY
LEFT OUTER JOIN TLOGPROCESS tlp
ON tlp.PARTITIONKEY = brl.PARTITIONKEY AND tlp.CATKEY = brl.CATKEY AND tlp.PERIODKEY = pprd.PERIODKEY AND tlp.RULE_ID = brl.RULE_ID
WHERE brl.LOADID = 1309
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2017-02-22 08:40:42,110 DEBUG [AIF]: CommData.getPovList - END
2017-02-22 08:40:42,111 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2017-02-22 08:40:42,112 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_DETAILS (
PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, TARGET_TABLE_NAME, EXECUTION_START_TIME
,EXECUTION_END_TIME, RECORDS_PROCESSED, STATUS, LAST_UPDATED_BY, LAST_UPDATE_DATE
)
SELECT PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, 'TDATASEG' TARGET_TABLE_NAME, CURRENT_TIMESTAMP EXECUTION_START_TIME
,NULL EXECUTION_END_TIME, 0 RECORDS_PROCESSED, 'PENDING' STATUS, 'admin' LAST_UPDATED_BY, CURRENT_TIMESTAMP LAST_UPDATE_DATE
FROM (
SELECT DISTINCT PROCESS_ID, IMP_ENTITY_TYPE ENTITY_TYPE, IMP_ENTITY_ID ENTITY_ID, IMP_ENTITY_NAME ENTITY_NAME
,(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER
FROM AIF_PROCESS_PERIODS
WHERE PROCESS_ID = 1309
) q
ORDER BY ENTITY_NAME_ORDER
2017-02-22 08:40:42,124 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2017-02-22 08:40:42,130 DEBUG [AIF]: Comm.doScriptInit - START
2017-02-22 08:40:42,235 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epm_all\FinancialDataQuality, INBOXDIR=D:\FDMEEApps\TestHFM5\inbox, LOCNAME=FINREP_OI, SOURCENAME=FIN_REP_OPEN_INTERFACE, APPID=22, SOURCEID=25, APPROOTDIR=D:\FDMEEApps\TestHFM5, IMPORTFORMAT=FinRep_OpenInterface, SCRIPTSDIR=D:\FDMEEApps\TestHFM5\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=86, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epm_all, LOADID=1309, PERIODNAME=Jan-2017, IMPORTMODE=null, SOURCETYPE=OTHERS, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=TestHFM1, LOCKEY=120, RULENAME=FinRep_Load, OUTBOXDIR=D:\FDMEEApps\TestHFM5\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=1, USERNAME=admin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=null}
2017-02-22 08:40:42,240 DEBUG [AIF]: The executeEventScript is set to: YES
2017-02-22 08:40:42,240 DEBUG [AIF]: The AppRootFolder is set to: D:\FDMEEApps\TestHFM5
2017-02-22 08:40:42,240 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2017-02-22 08:40:42,240 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE
2017-02-22 08:40:42,240 DEBUG [AIF]: Comm.doScriptInit - END
2017-02-22 08:40:42,240 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:42,241 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/BefImport.py
2017-02-22 08:40:42,244 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:42,244 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp
2017-02-22 08:40:42,244 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\BefImport.vbs
2017-02-22 08:40:42,244 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:42,244 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:42,245 DEBUG [AIF]: CommData.preImportData - END
2017-02-22 08:40:47,890 DEBUG [AIF]:
ERP GL Balances Print Variables
===============================
p_sql_db_type: ORACLE
p_adp_project_code: AIF_OI
p_adp_scenario_name: FinRep_OpenInterface
p_prd_entity_name: Jan (Jan-2017)
p_prd_periodkey: 2017-01-31 00:00:00
2017-02-22 08:40:48,841 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-02-22 08:40:48,844 DEBUG [AIF]:
UPDATE AIF_PROCESS_DETAILS
SET STATUS = 'SUCCESS'
,RECORDS_PROCESSED = CASE
WHEN RECORDS_PROCESSED IS NULL THEN 0
ELSE RECORDS_PROCESSED
END + 0
,EXECUTION_END_TIME = CURRENT_TIMESTAMP
,LAST_UPDATED_BY = CASE
WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY
ELSE 'admin'
END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 1309
AND ENTITY_TYPE = 'PROCESS_BAL_IMP'
AND ENTITY_NAME = 'Jan (Jan-2017)'
2017-02-22 08:40:48,846 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-02-22 08:40:48,964 DEBUG [AIF]: CommData.postImportData - START
2017-02-22 08:40:48,970 DEBUG [AIF]: CommData.getRuleInfo - START
2017-02-22 08:40:48,970 DEBUG [AIF]:
SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE
,CASE
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'EBS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'PS%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE LIKE 'FUSION%' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE = 'FILE' THEN 'N'
WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'N'
ELSE 'Y'
END SOURCE_ADAPTER_FLAG
,app.APPLICATION_ID, app.TARGET_APPLICATION_NAME, app.TARGET_APPLICATION_TYPE, app.DATA_LOAD_METHOD, brl.PLAN_TYPE
,CASE brl.PLAN_TYPE
WHEN 'PLAN1' THEN 1 WHEN 'PLAN2' THEN 2 WHEN 'PLAN3' THEN 3 WHEN 'PLAN4' THEN 4 WHEN 'PLAN5' THEN 5 WHEN 'PLAN6' THEN 6 ELSE 0
END PLAN_NUMBER
,br.INCL_ZERO_BALANCE_FLAG, br.PERIOD_MAPPING_TYPE, br.INCLUDE_ADJ_PERIODS_FLAG, br.BALANCE_TYPE ACTUAL_FLAG
,br.AMOUNT_TYPE, br.BALANCE_SELECTION, br.BALANCE_METHOD_CODE
,COALESCE(br.SIGNAGE_METHOD, 'ABSOLUTE') SIGNAGE_METHOD
,br.CURRENCY_CODE, br.BAL_SEG_VALUE_OPTION_CODE, brl.EXECUTION_MODE
,COALESCE(brl.IMPORT_FROM_SOURCE_FLAG, 'Y') IMPORT_FROM_SOURCE_FLAG
,COALESCE(brl.RECALCULATE_FLAG, 'N') RECALCULATE_FLAG
,COALESCE(brl.EXPORT_TO_TARGET_FLAG, 'N') EXPORT_TO_TARGET_FLAG
,COALESCE(brl.CHECK_FLAG, 'N') CHECK_FLAG
,CASE
WHEN ss.SOURCE_SYSTEM_TYPE = 'EPM' THEN 'NONE'
WHEN (br.LEDGER_GROUP_ID IS NOT NULL) THEN 'MULTI'
WHEN (br.SOURCE_LEDGER_ID IS NOT NULL) THEN 'SINGLE'
ELSE 'NONE'
END LEDGER_GROUP_CODE
,COALESCE(br.BALANCE_AMOUNT_BS, 'YTD') BALANCE_AMOUNT_BS
,COALESCE(br.BALANCE_AMOUNT_IS, 'PERIODIC') BALANCE_AMOUNT_IS
,br.LEDGER_GROUP
,(SELECT brd.DETAIL_CODE FROM AIF_BAL_RULE_DETAILS brd WHERE brd.RULE_ID = br.RULE_ID AND brd.DETAIL_TYPE = 'LEDGER') PS_LEDGER
,CASE lg.LEDGER_TEMPLATE WHEN 'COMMITMENT' THEN 'Y' ELSE 'N' END KK_FLAG
,p.LAST_UPDATED_BY, p.AIF_WEB_SERVICE_URL WEB_SERVICE_URL, p.EPM_ORACLE_INSTANCE
,brl.JOURNAL_FLAG, br.MULTI_PERIOD_FILE_FLAG, br.IMPGROUPKEY, imp.IMPSOURCELEDGERID
,imp.IMPGROUPFILETYPE, imp.IMPTARGETSOURCESYSTEMID, imp.IMPSOURCECOAID, part.PARTTARGETAPPLICATIONID
FROM AIF_PROCESSES p
INNER JOIN AIF_BAL_RULE_LOADS brl
ON brl.LOADID = p.PROCESS_ID
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN AIF_SOURCE_SYSTEMS ss
ON ss.SOURCE_SYSTEM_ID = br.SOURCE_SYSTEM_ID
INNER JOIN AIF_TARGET_APPLICATIONS app
ON app.APPLICATION_ID = brl.APPLICATION_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = br.PARTITIONKEY
INNER JOIN TBHVIMPGROUP imp
ON imp.IMPGROUPKEY = part.PARTIMPGROUP
LEFT OUTER JOIN AIF_COA_LEDGERS l
ON l.SOURCE_SYSTEM_ID = p.SOURCE_SYSTEM_ID
AND l.SOURCE_LEDGER_ID = COALESCE(br.SOURCE_LEDGER_ID,imp.IMPSOURCELEDGERID)
LEFT OUTER JOIN AIF_PS_SET_CNTRL_REC_STG scr
ON scr.SOURCE_SYSTEM_ID = l.SOURCE_SYSTEM_ID
AND scr.SETCNTRLVALUE = l.SOURCE_LEDGER_NAME
AND scr.RECNAME = 'LED_GRP_TBL'
LEFT OUTER JOIN AIF_PS_LED_GRP_TBL_STG lg
ON lg.SOURCE_SYSTEM_ID = scr.SOURCE_SYSTEM_ID
AND lg.SETID = scr.SETID
AND lg.LEDGER_GROUP = br.LEDGER_GROUP
WHERE p.PROCESS_ID = 1309
2017-02-22 08:40:48,975 DEBUG [AIF]:
SELECT adim.BALANCE_COLUMN_NAME DIMNAME
,adim.DIMENSION_ID
,dim.TARGET_DIMENSION_CLASS_NAME
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID2) COA_SEGMENT_NAME2
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID3) COA_SEGMENT_NAME3
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID4) COA_SEGMENT_NAME4
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID5) COA_SEGMENT_NAME5
,(SELECT DISTINCT CASE mdd.ORPHAN_OPTION_CODE
WHEN 'CHILD' THEN 'N'
WHEN 'ROOT' THEN 'N'
ELSE 'Y'
END DIMENSION_FILTER_FLAG
FROM AIF_MAP_DIM_DETAILS_V mdd
,AIF_MAPPING_RULES mr
WHERE mr.PARTITIONKEY = tpp.PARTITIONKEY
AND mdd.RULE_ID = mr.RULE_ID
AND mdd.DIMENSION_ID = adim.DIMENSION_ID
) DIMENSION_FILTER_FLAG
,tiie.IMPCONCATCHAR
FROM TPOVPARTITION tpp
INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim
ON adim.APPLICATION_ID = 22
INNER JOIN AIF_DIMENSIONS dim
ON dim.DIMENSION_ID = adim.DIMENSION_ID
LEFT OUTER JOIN TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP
AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME
AND tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 120
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2017-02-22 08:40:48,977 DEBUG [AIF]: {'APPLICATION_ID': 22L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'FinRep_Load', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epm_all', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'OTHERS', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'TestHFM1', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 25L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': None, 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 123L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'ICP', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 127L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 122L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 124L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 126L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 120L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME5': None, 'COA_SEGMENT_NAME1': None, 'COA_SEGMENT_NAME2': None, 'COA_SEGMENT_NAME3': None, 'DIMENSION_FILTER_FLAG': None, 'COA_SEGMENT_NAME4': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 125L}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 120L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': None, 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': None, 'IMPGROUPFILETYPE': u'ODI', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 86L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'Y', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://DON-HYCPW01.don.s365.us:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 22L, 'IMPTARGETSOURCESYSTEMID': 0L}
2017-02-22 08:40:48,977 DEBUG [AIF]: CommData.getRuleInfo - END
2017-02-22 08:40:48,984 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2017-02-22 08:40:48,986 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2017-02-22 08:40:48,987 DEBUG [AIF]: CommData.getLedgerSQL - START
2017-02-22 08:40:48,987 DEBUG [AIF]: CommData.getLedgerSQL - END
2017-02-22 08:40:48,987 DEBUG [AIF]:
SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID
,NULL SOURCE_LEDGER_NAME
,NULL SOURCE_COA_ID
,br.CALENDAR_ID
,NULL SETID
,NULL PERIOD_TYPE
,NULL LEDGER_TABLE_NAME
FROM AIF_BALANCE_RULES br
WHERE br.RULE_ID = 86
2017-02-22 08:40:48,988 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2017-02-22 08:40:48,991 DEBUG [AIF]: CommData.getPovList - START
2017-02-22 08:40:48,993 DEBUG [AIF]: doAppPeriodMappingsExist - TestHFM1: N
2017-02-22 08:40:48,993 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 TPOVPERIOD pp
ON pp.PERIODKEY = pprd.PERIODKEY
LEFT OUTER JOIN TLOGPROCESS tlp
ON tlp.PARTITIONKEY = brl.PARTITIONKEY
AND tlp.CATKEY = brl.CATKEY
AND tlp.PERIODKEY = pprd.PERIODKEY
AND tlp.RULE_ID = brl.RULE_ID
WHERE brl.LOADID = 1309
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2017-02-22 08:40:48,995 DEBUG [AIF]: CommData.getPovList - END
2017-02-22 08:40:48,997 INFO [AIF]:
Import Data from Source for Period 'Jan-2017'
2017-02-22 08:40:49,003 DEBUG [AIF]: CommData.updateWorkflow - START
2017-02-22 08:40:49,003 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 = 120
AND tlp.CATKEY = 1
AND tlp.PERIODKEY = '2017-01-31'
AND tlp.RULE_ID = 86
AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2017-02-22 08:40:49,004 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 = 120 AND CATKEY = 1 AND PERIODKEY = '2017-01-31' AND RULE_ID = 86
2017-02-22 08:40:49,005 DEBUG [AIF]:
INSERT INTO TLOGPROCESS (
PROCESSENDTIME
,PROCESSSTATUS
,PROCESSIMP
,PROCESSVAL
,PROCESSEXP
,PROCESSENTLOAD
,PROCESSENTVAL
,BLNWCDIRTY
,BLNLOGICDIRTY
,BLNVALDIRTY
,PROCESSIMPNOTE
,PROCESSVALNOTE
,PROCESSEXPNOTE
,PROCESSENTLOADNOTE
,PROCESSENTVALNOTE
,PARTITIONKEY
,CATKEY
,PERIODKEY
,RULE_ID
) VALUES (
CURRENT_TIMESTAMP
,0
,0
,0
,0
,0
,0
,0
,0
,0
,NULL
,NULL
,NULL
,NULL
,NULL
,120
,1
,'2017-01-31'
,86
)
2017-02-22 08:40:49,016 DEBUG [AIF]: CommData.updateWorkflow - END
2017-02-22 08:40:49,016 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 = 120
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2017-02-22 08:40:49,018 DEBUG [AIF]:
UPDATE TDATASEG_T
SET AMOUNTX = AMOUNT
,ACCOUNTX = NULL
,ENTITYX = NULL
,ICPX = NULL
,UD1X = NULL
,UD2X = NULL
,UD3X = NULL
,UD4X = NULL
WHERE TDATASEG_T.LOADID = 1309
AND TDATASEG_T.PARTITIONKEY = 120
AND TDATASEG_T.CATKEY = 1
AND TDATASEG_T.PERIODKEY = '2017-01-31'
2017-02-22 08:40:49,018 INFO [AIF]: Generic Data Rows Imported from Source: 0
2017-02-22 08:40:49,019 INFO [AIF]: Total Data Rows Imported from Source: 0
2017-02-22 08:40:49,019 DEBUG [AIF]: CommData.updateTDATASEG_T - END
2017-02-22 08:40:49,026 DEBUG [AIF]: Comm.doScriptInit - START
2017-02-22 08:40:49,231 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epm_all\FinancialDataQuality, INBOXDIR=D:\FDMEEApps\TestHFM5\inbox, LOCNAME=FINREP_OI, SOURCENAME=FIN_REP_OPEN_INTERFACE, APPID=22, SOURCEID=25, APPROOTDIR=D:\FDMEEApps\TestHFM5, IMPORTFORMAT=FinRep_OpenInterface, SCRIPTSDIR=D:\FDMEEApps\TestHFM5\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=86, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epm_all, LOADID=1309, PERIODNAME=Jan-2017, IMPORTMODE=null, SOURCETYPE=OTHERS, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=TestHFM1, LOCKEY=120, RULENAME=FinRep_Load, OUTBOXDIR=D:\FDMEEApps\TestHFM5\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=1, USERNAME=admin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=null}
2017-02-22 08:40:49,231 DEBUG [AIF]: The EpmOracleHome is set to: D:\Oracle\Middleware\EPMSystem11R1
2017-02-22 08:40:49,231 DEBUG [AIF]: The EpmOracleInstance is set to: D:\Oracle\Middleware\user_projects\epm_all
2017-02-22 08:40:49,231 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2017-02-22 08:40:49,231 DEBUG [AIF]: The executeEventScript is set to: YES
2017-02-22 08:40:49,231 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE
2017-02-22 08:40:49,231 DEBUG [AIF]: The AppRootFolder is set to: D:\FDMEEApps\TestHFM5
2017-02-22 08:40:49,231 DEBUG [AIF]: Comm.doScriptInit - END
2017-02-22 08:40:49,231 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:49,231 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/AftImport.py
2017-02-22 08:40:49,235 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:49,235 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp
2017-02-22 08:40:49,235 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\AftImport.vbs
2017-02-22 08:40:49,235 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:49,235 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:49,235 DEBUG [AIF]: CommData.postImportData - END
2017-02-22 08:40:49,442 DEBUG [AIF]: LogicGroup.createLogicAccounts - START
2017-02-22 08:40:49,442 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:49,443 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/BefProcLogicGrp.py
2017-02-22 08:40:49,443 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:49,443 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\BefProcLogicGrp.vbs
2017-02-22 08:40:49,443 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:49,443 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:49,445 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START
2017-02-22 08:40:49,445 DEBUG [AIF]:
select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE
from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp
where prs.PROCESS_ID=1309 and prs.PARTITIONKEY=part.PARTITIONKEY
and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY
2017-02-22 08:40:49,446 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END
2017-02-22 08:40:49,446 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:49,447 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/AftProcLogicGrp.py
2017-02-22 08:40:49,447 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:49,447 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\AftProcLogicGrp.vbs
2017-02-22 08:40:49,447 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:49,447 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:49,447 DEBUG [AIF]: LogicGroup.createLogicAccounts - END
2017-02-22 08:40:49,481 DEBUG [AIF]: CommData.mapData - START
2017-02-22 08:40:49,482 DEBUG [AIF]: CommData.insertTransProcessDetails - START
2017-02-22 08:40:49,483 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_DETAILS (
PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, TARGET_TABLE_NAME, EXECUTION_START_TIME
,EXECUTION_END_TIME, RECORDS_PROCESSED, STATUS, LAST_UPDATED_BY, LAST_UPDATE_DATE
)
SELECT PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, 'TDATASEG' TARGET_TABLE_NAME, CURRENT_TIMESTAMP EXECUTION_START_TIME
,NULL EXECUTION_END_TIME, 0 RECORDS_PROCESSED, 'PENDING' STATUS, 'admin' LAST_UPDATED_BY, CURRENT_TIMESTAMP LAST_UPDATE_DATE
FROM (
SELECT PROCESS_ID, TRANS_ENTITY_TYPE ENTITY_TYPE, MIN(TRANS_ENTITY_ID) ENTITY_ID, TRANS_ENTITY_NAME ENTITY_NAME
,MIN(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER
FROM AIF_PROCESS_PERIODS
WHERE PROCESS_ID = 1309
AND PRIOR_PERIOD_FLAG = 'N'
GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME
) q
ORDER BY ENTITY_NAME_ORDER
2017-02-22 08:40:49,485 DEBUG [AIF]: CommData.insertTransProcessDetails - END
2017-02-22 08:40:49,489 DEBUG [AIF]:
DELETE FROM TDATAMAP_T
WHERE LOADID < 1309
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 86 AND p.PROCESS_ID = TDATAMAP_T.LOADID )
2017-02-22 08:40:49,491 DEBUG [AIF]:
DELETE FROM TDATASEG_T
WHERE LOADID < 1309
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 86 AND p.PROCESS_ID = TDATASEG_T.LOADID )
2017-02-22 08:40:49,492 DEBUG [AIF]:
DELETE FROM AIF_PROCESS_PERIODS
WHERE PROCESS_ID < 1309
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 86 AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID )
2017-02-22 08:40:49,495 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START
2017-02-22 08:40:49,496 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START
2017-02-22 08:40:49,497 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 = 120
2017-02-22 08:40:49,497 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END
2017-02-22 08:40:49,498 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 1309, DATAKEY, 120 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '<BLANK>' THEN ' ' ELSE TARGKEY END
,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID
FROM TDATAMAP tdm
WHERE PARTITIONKEY = 120
AND ( RULE_ID IS NULL OR RULE_ID = 86 )
AND ( TDATAMAPTYPE = 'ERP'
OR
( TDATAMAPTYPE = 'MULTIDIM'
AND EXISTS ( SELECT 1
FROM TDATAMAP multidim
WHERE multidim.PARTITIONKEY = tdm.PARTITIONKEY
AND multidim.TDATAMAPTYPE = 'ERP'
AND multidim.DATAKEY = tdm.TARGKEY )
)
)
2017-02-22 08:40:49,500 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 0
2017-02-22 08:40:49,539 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START
2017-02-22 08:40:49,539 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:49,540 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/BefProcMap.py
2017-02-22 08:40:49,540 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:49,540 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\BefProcMap.vbs
2017-02-22 08:40:49,540 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:49,540 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:49,541 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 = 1309
AND atad.APPLICATION_ID = 22
AND tdm.PARTITIONKEY = 120
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 86)
AND tdm.WHERECLAUSETYPE IS NULL
UNION ALL
SELECT tdm.DIMNAME, tdm.RULE_ID, tdm.SRCKEY, tdm.TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, tdm.CHANGESIGN
,CASE tpp.PARTSEQMAP
WHEN 0 THEN CASE WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2
WHEN (tdm.WHERECLAUSETYPE = 'IN') THEN 3
WHEN (tdm.WHERECLAUSETYPE = 'MULTIDIM') THEN 4
WHEN (tdm.WHERECLAUSETYPE = 'LIKE') THEN 5
ELSE 0 END
ELSE tdm.SEQUENCE
END SEQUENCE
,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG, tdm.DATAKEY
,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING_TYPE, COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ
FROM TDATAMAP_T tdm
INNER JOIN TPOVPARTITION tpp ON tpp.PARTITIONKEY = tdm.PARTITIONKEY
INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME
WHERE tdm.LOADID = 1309
AND atad.APPLICATION_ID = 22
AND tdm.PARTITIONKEY = 120
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 86)
AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')
) q
ORDER BY CALC_SEQ, DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY
2017-02-22 08:40:49,542 INFO [AIF]:
Map Data for Period 'Jan-2017'
2017-02-22 08:40:49,543 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-02-22 08:40:49,545 DEBUG [AIF]:
UPDATE AIF_PROCESS_DETAILS
SET STATUS = 'RUNNING'
,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + NULL
,EXECUTION_END_TIME = CURRENT_TIMESTAMP
,LAST_UPDATED_BY = CASE WHEN ('admin' IS NULL) THEN LAST_UPDATED_BY ELSE 'admin' END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 1309 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jan-2017'
2017-02-22 08:40:49,548 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-02-22 08:40:49,550 DEBUG [AIF]:
SELECT COUNT(*) ROW_COUNT
FROM TDATASEG_T
WHERE LOADID = 1309
AND (PARTITIONKEY = 120 AND CATKEY = 1 AND PERIODKEY = '2017-01-31' AND RULE_ID = 86 AND VALID_FLAG = 'Y')
2017-02-22 08:40:49,551 WARN [AIF]: Warning: No records exist for Period 'Jan-2017'
2017-02-22 08:40:49,551 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-02-22 08:40:49,552 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 ('admin' IS NULL) THEN LAST_UPDATED_BY ELSE 'admin' END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 1309 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Jan-2017'
2017-02-22 08:40:49,556 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-02-22 08:40:49,562 DEBUG [AIF]: CommData.updateWorkflow - START
2017-02-22 08:40:49,562 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=120 AND CATKEY=1 AND PERIODKEY='2017-01-31' AND RULE_ID=86
2017-02-22 08:40:49,565 DEBUG [AIF]: CommData.updateWorkflow - END
2017-02-22 08:40:49,565 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END
2017-02-22 08:40:49,566 DEBUG [AIF]:
UPDATE TDATASEG_T
SET ATTR14 = DATAKEY
WHERE LOADID = 1309 AND PARTITIONKEY = 120 AND CATKEY = 1 AND PERIODKEY = '2017-01-31'
2017-02-22 08:40:49,576 DEBUG [AIF]: CommData.updateYtdAmounts - START
2017-02-22 08:40:49,576 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2017-02-22 08:40:49,576 DEBUG [AIF]: CommData.getLedgerSQL - START
2017-02-22 08:40:49,576 DEBUG [AIF]: CommData.getLedgerSQL - END
2017-02-22 08:40:49,576 DEBUG [AIF]:
SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID, NULL SOURCE_LEDGER_NAME, NULL SOURCE_COA_ID
,br.CALENDAR_ID, NULL SETID, NULL PERIOD_TYPE, NULL LEDGER_TABLE_NAME
FROM AIF_BALANCE_RULES br
WHERE br.RULE_ID = 86
2017-02-22 08:40:49,577 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2017-02-22 08:40:49,577 DEBUG [AIF]:
SELECT brl.PARTITIONKEY, brl.CATKEY, pprd.YEARTARGET, pprd.PERIODTARGET, pprd.SOURCE_LEDGER_ID
FROM AIF_BAL_RULE_LOADS brl
,AIF_PROCESS_PERIODS pprd
WHERE brl.LOADID = 1309
AND pprd.PROCESS_ID = brl.LOADID
AND pprd.PRIOR_PERIOD_FLAG = 'N'
GROUP BY brl.PARTITIONKEY, brl.CATKEY, pprd.YEARTARGET, pprd.PERIODTARGET, pprd.SOURCE_LEDGER_ID
HAVING COUNT(*) > 1
2017-02-22 08:40:49,580 DEBUG [AIF]: CommData.updateYtdAmounts - END
2017-02-22 08:40:49,590 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START
2017-02-22 08:40:49,590 INFO [AIF]:
Stage Data for Period 'Jan-2017'
2017-02-22 08:40:49,590 DEBUG [AIF]:
DELETE FROM TDATAMAPSEG
WHERE PARTITIONKEY = 120
AND CATKEY = 1
AND PERIODKEY = '2017-01-31'
AND ( TDATAMAPTYPE = 'ERP'
OR
( TDATAMAPTYPE = 'MULTIDIM'
AND EXISTS ( SELECT 1
FROM TDATAMAPSEG parent
WHERE parent.PARTITIONKEY = TDATAMAPSEG.PARTITIONKEY
AND parent.DATAKEY = TDATAMAPSEG.TARGKEY
AND parent.CATKEY = TDATAMAPSEG.CATKEY
AND parent.PERIODKEY = TDATAMAPSEG.PERIODKEY
AND parent.TDATAMAPTYPE = 'ERP' )
)
)
2017-02-22 08:40:49,591 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 0
2017-02-22 08:40:49,591 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, '2017-01-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,
WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG
FROM TDATAMAP_T
WHERE LOADID = 1309
2017-02-22 08:40:49,592 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 0
2017-02-22 08:40:49,592 DEBUG [AIF]:
DELETE FROM TDATAMAP_T
WHERE LOADID = 1309
2017-02-22 08:40:49,593 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 0
2017-02-22 08:40:49,593 DEBUG [AIF]:
DELETE FROM TDATASEG
WHERE LOADID < 1309 AND PARTITIONKEY = 120 AND CATKEY = 1 AND RULE_ID = 86 AND PERIODKEY = '2017-01-31'
2017-02-22 08:40:49,594 INFO [AIF]: Number of Rows deleted from TDATASEG: 0
2017-02-22 08:40:49,594 DEBUG [AIF]:
DELETE FROM TDATAMEMOITEMS
WHERE PARTITIONKEY = 120 AND PERIODKEY = '2017-01-31' AND CATKEY = 1 AND RULE_ID = 86
AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)
2017-02-22 08:40:49,595 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0
2017-02-22 08:40:49,595 DEBUG [AIF]:
DELETE FROM TDATAARCHIVE
WHERE PARTITIONKEY = 120 AND PERIODKEY = '2017-01-31' AND CATKEY = 1 AND RULE_ID = 86
AND ARCHIVEPROCTYPEID = 1
AND NOT EXISTS ( SELECT 1
FROM TDATAMEMOITEMS
WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )
2017-02-22 08:40:49,596 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0
2017-02-22 08:40:49,596 DEBUG [AIF]:
INSERT INTO TDATASEG (
DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID
,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DESC1, DESC2
,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF
,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F
,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F
,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F
,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F
,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F
,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14
,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG )
SELECT
DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID
,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DESC1, DESC2
,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF
,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F
,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F
,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F
,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F
,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F
,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14
,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG
FROM TDATASEG_T
WHERE LOADID = 1309 AND PARTITIONKEY = 120 AND CATKEY = 1 AND PERIODKEY = '2017-01-31'
2017-02-22 08:40:49,597 INFO [AIF]: Number of Rows inserted into TDATASEG: 0
2017-02-22 08:40:49,597 DEBUG [AIF]:
DELETE FROM TDATASEG_T
WHERE LOADID = 1309 AND PARTITIONKEY = 120 AND CATKEY = 1 AND PERIODKEY = '2017-01-31'
2017-02-22 08:40:49,598 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 0
2017-02-22 08:40:49,598 DEBUG [AIF]: CommData.updateWorkflow - START
2017-02-22 08:40:49,598 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=2,PROCESSIMP=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0
,PROCESSIMPNOTE='Import Error'
WHERE PARTITIONKEY=120 AND CATKEY=1 AND PERIODKEY='2017-01-31' AND RULE_ID=86
2017-02-22 08:40:49,600 DEBUG [AIF]: CommData.updateWorkflow - END
2017-02-22 08:40:49,601 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END
2017-02-22 08:40:49,601 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:49,601 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/AftProcMap.py
2017-02-22 08:40:49,601 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:49,601 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\AftProcMap.vbs
2017-02-22 08:40:49,602 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:49,602 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:49,602 DEBUG [AIF]: CommData.mapData - END
2017-02-22 08:40:49,630 INFO [AIF]: -------END IMPORT STEP-------
2017-02-22 08:40:49,671 INFO [AIF]: -------START VALIDATE STEP-------
2017-02-22 08:40:49,715 DEBUG [AIF]: CommData.validateData - START
2017-02-22 08:40:49,715 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:49,715 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/BefValidate.py
2017-02-22 08:40:49,715 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:49,716 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\BefValidate.vbs
2017-02-22 08:40:49,716 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:49,716 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:49,721 DEBUG [AIF]: CommMap.validateData - START
2017-02-22 08:40:49,723 WARN [AIF]: Warning: The Import step has not been completed for period Jan-2017
2017-02-22 08:40:49,723 DEBUG [AIF]: CommMap.validateData - END
2017-02-22 08:40:49,724 WARN [AIF]: Warning: The Import step has not been completed for period Jan-2017
2017-02-22 08:40:49,724 DEBUG [AIF]: Comm.executeScript - START
2017-02-22 08:40:49,725 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5/data/scripts/event/AftValidate.py
2017-02-22 08:40:49,725 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-22 08:40:49,725 DEBUG [AIF]: The following script does not exist: D:\FDMEEApps\TestHFM5\data\scripts\event\AftValidate.vbs
2017-02-22 08:40:49,725 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-22 08:40:49,725 DEBUG [AIF]: Comm.executeScript - END
2017-02-22 08:40:49,725 DEBUG [AIF]: CommData.validateData - END
2017-02-22 08:40:49,749 INFO [AIF]: -------END VALIDATE STEP-------
2017-02-22 08:40:49,913 DEBUG [AIF]: Comm.finalizeProcess - START
2017-02-22 08:40:49,914 DEBUG [AIF]: CommData.updateRuleStatus - START
2017-02-22 08:40:49,914 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 = 1309 AND pd.STATUS IN ('FAILED','WARNING') )
WHEN 0 THEN 'SUCCESS'
ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 1309 AND pd.STATUS IN ('FAILED','WARNING') ) END
ELSE 'SUCCESS' END
WHERE RULE_ID = 86
2017-02-22 08:40:49,916 DEBUG [AIF]: CommData.updateRuleStatus - END
2017-02-22 08:40:49,917 DEBUG [AIF]: Comm.updateProcess - START
2017-02-22 08:40:49,920 DEBUG [AIF]: Comm.updateProcess - END
2017-02-22 08:40:49,921 DEBUG [AIF]: The fdmAPI connection has been closed.
2017-02-22 08:40:49,922 INFO [AIF]: FDMEE Process End, Process ID: 1309