Thanks in advance for any help!
Does anyone have any idea what the error is?
Hyperion version 11.1.2.4.0.79
2017-11-08 15:58:50,814 INFO [AIF]: FDMEE Process: 770, Log Level: 5, Log File: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\outbox\logs\SFReport_770.log
2017-11-08 15:58:50,815 INFO [AIF]: Location : SFRepDetail (Partitionkey:2)
2017-11-08 15:58:50,816 INFO [AIF]: Period Name : Sep-17 (Period Key:9/30/17 12:00 AM)
2017-11-08 15:58:50,817 INFO [AIF]: Category Name: ACTUAL (Category key:1)
2017-11-08 15:58:50,818 INFO [AIF]: Rule Name : SFDetail_Staging_DLR (Rule ID:6)
2017-11-08 15:58:53,084 INFO [AIF]: FDM Version: 11.1.2.4.100
2017-11-08 15:58:53,084 INFO [AIF]: Log File Encoding: UTF-8
2017-11-08 15:58:55,182 INFO [AIF]: -------START IMPORT STEP-------
2017-11-08 15:58:55,290 DEBUG [AIF]: CommData.preImportData - START
2017-11-08 15:58:55,298 DEBUG [AIF]: CommData.getRuleInfo - START
2017-11-08 15:58:55,308 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 = 2
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 = 2
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')
ORDER BY adim.BALANCE_COLUMN_NAME
2017-11-08 15:58:55,312 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'SFDetail_Staging_DLR', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'SFReport', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'SF_Report_Staging', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'hchong', 'DIMNAME_MAP': {u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 1L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 4L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 2L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 2L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 6L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http//servername.octfcu.org:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}
2017-11-08 15:58:55,313 DEBUG [AIF]: CommData.getRuleInfo - END
2017-11-08 15:58:55,318 DEBUG [AIF]: CommData.insertFilePeriods - START
2017-11-08 15:58:55,323 DEBUG [AIF]: doAppPeriodMappingsExist - SFReport: Y
2017-11-08 15:58:55,324 DEBUG [AIF]:
SELECT PERIODKEY,PERIODDESC,YEARTARGET,PERIODTARGET,FILE_NAME_STATIC,FILE_NAME_SUFFIX_TYPE,FILE_NAME_DATE_FORMAT,GL_EFFECTIVE_PERIOD_NUM
FROM (
SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT
,coalesce(brp.parameter_id,0) GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ AND pp.INTSYSTEMKEY = 'SFReport'
INNER JOIN AIF_BAL_RULE_LOAD_PARAMS brp
ON brp.loadid = brl.loadid AND convert(varchar,brp.parameter_value,111) = pp.periodkey
WHERE brl.LOADID = 770
AND br.rule_id = brl.rule_id
AND br.MULTI_PERIOD_FILE_FLAG in ('T','H')
AND brp.parameter_name like 'AMOUNT%'
UNION
SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT
,0 GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ AND pp.INTSYSTEMKEY = 'SFReport' AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY
WHERE brl.LOADID = 770
AND br.rule_id = brl.rule_id
AND br.MULTI_PERIOD_FILE_FLAG in('Y', 'X','E')
) qrslt
UNION
SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT
,0 GL_EFFECTIVE_PERIOD_NUM
FROM AIF_BALANCE_RULES br, AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIODADAPTOR_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ AND pp.INTSYSTEMKEY = 'SFReport' AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY
WHERE brl.LOADID = 770
AND (br.MULTI_PERIOD_FILE_FLAG is null or br.MULTI_PERIOD_FILE_FLAG = 'N' )
AND br.rule_id = brl.rule_id
ORDER BY PERIODKEY
2017-11-08 15:58:55,327 INFO [AIF]: File Name: Detail_Sep-17.txt
2017-11-08 15:58:55,329 DEBUG [AIF]:
INSERT INTO AIF_PROCESS_PERIODS (
PROCESS_ID, PERIODKEY, ADJUSTMENT_PERIOD_FLAG, GL_PERIOD_YEAR, GL_PERIOD_CODE, GL_PERIOD_NAME, GL_PERIOD_NUM, GL_EFFECTIVE_PERIOD_NUM
,YEARTARGET, PERIODTARGET, IMP_ENTITY_TYPE, IMP_ENTITY_NAME, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME, PRIOR_PERIOD_FLAG)
VALUES (770,'2017-09-30','N',0,'0' ,'0',0,1,'FY17','Sep', 'PROCESS_BAL_IMP_FILE','Detail_Sep-17.txt','PROCESS_BAL_TRANS','Sep-17','N')
2017-11-08 15:58:55,334 DEBUG [AIF]: CommData.insertFilePeriods - END
2017-11-08 15:58:55,338 DEBUG [AIF]: CommData.getPovList - START
2017-11-08 15:58:55,339 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC
,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF_PROCESS_PERIODS pprd
ON pprd.PROCESS_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY AND pp.INTSYSTEMKEY = 'SFReport'
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 = 770
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2017-11-08 15:58:55,342 DEBUG [AIF]: CommData.getPovList - END
2017-11-08 15:58:55,344 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2017-11-08 15:58:55,346 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, 'hchong' 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 = 770
) q
ORDER BY ENTITY_NAME_ORDER
2017-11-08 15:58:55,354 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2017-11-08 15:58:55,360 DEBUG [AIF]: Comm.doScriptInit - START
2017-11-08 15:58:55,517 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\inbox, LOCNAME=SFRepDetail, SOURCENAME=File, APPID=2, SOURCEID=1, APPROOTDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE, IMPORTFORMAT=SF_Report_Detail, SCRIPTSDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HPL, RULEID=6, CATNAME=ACTUAL, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=770, PERIODNAME=Sep-17, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-09-30, EXPORTFLAG=N, TARGETAPPDB=PLAN1, TARGETAPPNAME=SFReport, FILENAME=Detail_Sep-17.txt, LOCKEY=2, RULENAME=SFDetail_Staging_DLR, OUTBOXDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=1, USERNAME=hchong, FILEDIR=inbox, IMPORTFLAG=Y, USERLOCALE=null}
2017-11-08 15:58:55,527 DEBUG [AIF]: The executeEventScript is set to: YES
2017-11-08 15:58:55,529 DEBUG [AIF]: The AppRootFolder is set to: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE
2017-11-08 15:58:55,530 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2017-11-08 15:58:55,530 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2017-11-08 15:58:55,531 DEBUG [AIF]: Comm.doScriptInit - END
2017-11-08 15:58:55,531 DEBUG [AIF]: Comm.executeScript - START
2017-11-08 15:58:55,534 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/data/scripts/event/BefImport.py
2017-11-08 15:58:55,539 DEBUG [AIF]: Comm.executeVBScript - START
2017-11-08 15:58:55,539 DEBUG [AIF]: The WindowsTempFolder is set to: c:\users\hypser~1\appdata\local\temp
2017-11-08 15:58:55,542 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\data\scripts\event\BefImport.vbs
2017-11-08 15:58:55,542 DEBUG [AIF]: Comm.executeVBScript - END
2017-11-08 15:58:55,543 DEBUG [AIF]: Comm.executeScript - END
2017-11-08 15:58:55,543 DEBUG [AIF]: CommData.preImportData - END
2017-11-08 15:59:03,139 DEBUG [AIF]: FileData.importData - START
2017-11-08 15:59:03,140 DEBUG [AIF]: Importing data for load id: 770
2017-11-08 15:59:03,148 DEBUG [AIF]: CommData.getRuleInfo - START
2017-11-08 15:59:03,159 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 = 2
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 = 2
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')
ORDER BY adim.BALANCE_COLUMN_NAME
2017-11-08 15:59:03,163 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'SFDetail_Staging_DLR', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'SFReport', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'SF_Report_Staging', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'hchong', 'DIMNAME_MAP': {u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 1L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 4L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 2L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 2L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 6L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://servername.octfcu.org:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}
2017-11-08 15:59:03,163 DEBUG [AIF]: CommData.getRuleInfo - END
2017-11-08 15:59:03,175 DEBUG [AIF]: doAppPeriodMappingsExist - SFReport: Y
2017-11-08 15:59:03,175 DEBUG [AIF]: SELECT a.partitionkey,
a.catkey,
a.start_periodkey,
b.perioddesc,
coalesce(a.journal_flag,'N') JOURNAL_FLAG,
c.last_updated_by,
coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC,
a.FILE_PATH,
a.RULE_ID,
a.application_id,
coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG
FROM aif_bal_rule_loads a,
aif_balance_rules br,
TPOVPERIODADAPTOR b,
aif_processes c
WHERE a.loadid = 770
AND a.start_periodkey=b.periodkey
AND a.loadid =c.process_id
AND br.rule_id = a.rule_id
AND b.INTSYSTEMKEY = 'SFReport'
2017-11-08 15:59:03,180 DEBUG [AIF]: FileData.py: Importing Text data for load id: 770
2017-11-08 15:59:03,213 INFO [AIF]: EPMFDM-140274:Message - Log File Name :\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\outbox\logs\SFReport_770.log
2017-11-08 15:59:03,215 DEBUG [AIF]: EPMFDM-140274:Message - SELECT COALESCE(p.partitionkey,0) PARTITIONKEY,
COALESCE(brl.catkey,0) CATKEY,
COALESCE(p.rule_id,0) RULE_ID,
part.PARTCURRENCYKEY PARTCURRENCYKEY,
dir.FILE_PATH,
p.CLUSTER_NAME,
p.APPLICATION_ID
FROM aif_processes p,
aif_bal_rule_loads brl,
tpovpartition part,
(SELECT COALESCE(
(SELECT PROFILE_OPTION_VALUE
+ '/'
FROM AIF_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'
AND LEVEL_ID = 1005
AND LEVEL_VALUE = brl.APPLICATION_ID
) ,COALESCE(
(SELECT PROFILE_OPTION_VALUE
+ '/'
FROM AIF_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_NAME = 'PROFILE_APP_ROOT_DIRECTORY'
AND LEVEL_ID = 1000
) ,'' ) ,'' )
+ COALESCE(brl.FILE_PATH, '') FILE_PATH,
brl.LOADID
FROM AIF_BAL_RULE_LOADS brl
) dir
WHERE p.process_id = ?
AND p.process_id = dir.loadid
AND brl.loadid = p.process_id
AND part.partitionkey = p.partitionkey
2017-11-08 15:59:03,217 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::770;2:1:6:[NONE]:\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/inbox
2017-11-08 15:59:03,229 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2017-11-08 15:59:03,231 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2017-11-08 15:59:03,234 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
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
AND ((br.MULTI_PERIOD_FILE_FLAG in ( 'Y','T','X','E','H') )
OR
(br.MULTI_PERIOD_FILE_FLAG is null OR br.MULTI_PERIOD_FILE_FLAG = 'N')
)
ORDER BY en.entity_name_order
2017-11-08 15:59:03,238 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?
2017-11-08 15:59:03,264 INFO [AIF]: EPMFDM-140274:Message - Log File Name :\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\outbox\logs\SFReport_770.log
2017-11-08 15:59:03,268 DEBUG [AIF]: EPMFDM-140274:Message - select 1 from aif_balance_rules br,aif_processes p where p.process_id = ? and p.rule_id = br.rule_id and br.multi_period_file_flag = 'Y'
2017-11-08 15:59:03,276 DEBUG [AIF]: EPMFDM-140274:Message - select ata.TARGET_APPLICATION_TYPE,ata.APPLICATION_NAME from aif_processes p inner join tpovpartition tpov on tpov.partitionkey = p.partitionkey and p.process_id=? left outer join AIF_TARGET_APPLICATIONS ata on ata.APPLICATION_ID = tpov.PARTSOURCEAPPLICATIONID
2017-11-08 15:59:03,284 DEBUG [AIF]: EPMFDM-140274:Message - SELECT impgroupkey,
impfldfieldname,
impfldfixedtext,
impfldstartpos,
impfldlength,
impfldsourcecolname,
impgroupfiletype,
impgroupdelimiter,
impseq,
LOG_SEQUENCE,
calc_seq
FROM
(SELECT fl.impgroupkey,
fl.impfldfieldname,
fl.impfldfixedtext,
fl.impfldstartpos,
fl.impfldlength,
fl.impfldsourcecolname,
ig.impgroupfiletype,
ig.impgroupdelimiter,
fl.impseq,
0 LOG_SEQUENCE,
COALESCE(calc_seq,0) CALC_SEQ
FROM
tbhvimpgroup ig,
tbhvimpitemfile fl,
AIF_TARGET_APPL_DIMENSIONS td,
aif_processes pr,
aif_bal_rule_loads brl
WHERE pr.process_id = ?
and pr.process_id = brl.loadid
and pr.application_id = brl.application_id
and pr.partitionkey = pr.partitionkey
AND ig.impgroupkey = brl.impgroupkey
AND ig.impgroupkey = fl.impgroupkey
AND td.application_id = ig.imptargetapplicationid
AND fl.impfldfieldname = td.balance_column_name
UNION ALL
SELECT fl.impgroupkey,
fl.impfldfieldname,
fl.impfldfixedtext,
fl.impfldstartpos,
fl.impfldlength,
fl.impfldsourcecolname,
ig.impgroupfiletype,
ig.impgroupdelimiter,
fl.impseq,
0 LOG_SEQUENCE,
-1 CALC_SEQ
FROM tbhvimpgroup ig,
tbhvimpitemfile fl,
aif_processes pr,
aif_bal_rule_loads brl
WHERE pr.process_id = ?
and pr.process_id = brl.loadid
and pr.application_id = brl.application_id
AND ig.impgroupkey = brl.impgroupkey
AND ig.impgroupkey = fl.impgroupkey
AND fl.impfldfieldname NOT IN
(SELECT td.balance_column_name
FROM AIF_TARGET_APPL_DIMENSIONS td
WHERE td.application_id = ig.imptargetapplicationid
AND fl.impfldfieldname = td.balance_column_name
)
) qrslt
ORDER BY calc_seq,
impseq
2017-11-08 15:59:03,291 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=16:SourceClName=Value
2017-11-08 15:59:03,294 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR8:ImpFieldText=null:StartPos=14:SourceClName=Credits
2017-11-08 15:59:03,298 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR7:ImpFieldText=null:StartPos=13:SourceClName=Debits
2017-11-08 15:59:03,302 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR6:ImpFieldText=null:StartPos=11:SourceClName=Refernces
2017-11-08 15:59:03,312 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR5:ImpFieldText=null:StartPos=10:SourceClName=Cat
2017-11-08 15:59:03,317 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR4:ImpFieldText=null:StartPos=9:SourceClName=User
2017-11-08 15:59:03,323 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR3:ImpFieldText=null:StartPos=8:SourceClName=Seq No
2017-11-08 15:59:03,328 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR2:ImpFieldText=null:StartPos=7:SourceClName=Post Date
2017-11-08 15:59:03,330 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR1:ImpFieldText=null:StartPos=6:SourceClName=Effective Date
2017-11-08 15:59:03,330 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=Script=ConvertDblQuote.py:StartPos=12:SourceClName=Comments
2017-11-08 15:59:03,331 INFO [AIF]: EPMFDM-140274:Message - Instantiating JythonInterpreter
2017-11-08 15:59:03,451 INFO [AIF]: EPMFDM-140275:Message - Log File Name :\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\outbox\logs\SFReport_770.log
2017-11-08 15:59:03,454 DEBUG [AIF]: EPMFDM-140274:Message - Passing script file for execution to jython interpretor: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/data/scripts/import/ConvertDblQuote.py
2017-11-08 15:59:03,457 INFO [AIF]: EPMFDM-140275:Message - Execute File: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/data/scripts/import/ConvertDblQuote.py
2017-11-08 15:59:03,459 DEBUG [AIF]: EPMFDM-140275:Message - LOG_LEVEL: 5
2017-11-08 15:59:03,460 DEBUG [AIF]: EPMFDM-140275:Message - Script File encoding: UTF-8
2017-11-08 15:59:03,464 DEBUG [AIF]: EPMFDM-140275:Message - def ConvertDblQuote(strfield, strrecord):
return strfield.replace('\"','')
2017-11-08 15:59:03,472 DEBUG [AIF]: EPMFDM-140274:Message - compiling script:ConvertDblQuote(strField,strRecord)
2017-11-08 15:59:03,474 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=5:SourceClName=GL
2017-11-08 15:59:03,475 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=Working:StartPos=1:SourceClName=Version
2017-11-08 15:59:03,475 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=NoProduct:StartPos=2:SourceClName=Product
2017-11-08 15:59:03,476 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=3:SourceClName=Cost Center
2017-11-08 15:59:03,477 INFO [AIF]: EPMFDM-140274:Message - File Name Detail_Sep-17.txt
periodKey2017-09-30
repeat this line many many times:
2017-11-08 16:01:25,764 DEBUG [AIF]: skipBOM-Start: firstRow=true
2017-11-08 16:01:25,764 DEBUG [AIF]: skipBOM-End: firstRow=true
then this:
2017-11-08 16:01:25,800 INFO [AIF]: EPMFDM-140274:Message - Rows Loaded: 100122
Rows Rejected: 3
2017-11-08 16:01:25,847 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy
2017-11-08 16:01:25,848 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:
2017-11-08 16:01:25,849 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 77020170930
2017-11-08 16:01:25,850 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: Detail_Sep-17
Extension: txt
2017-11-08 16:01:25,853 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 77020170930.txt
2017-11-08 16:01:33,490 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: Detail_Sep-17.txt
2017-11-08 16:01:33,491 INFO [AIF]: EPMFDM-140274:Message - File not deleted: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\inbox\Detail_Sep-17.txt
2017-11-08 16:01:33,491 DEBUG [AIF]: EPMFDM-140274:Message - SELECT
CASE
WHEN start_periodkey = end_periodkey
THEN 0
ELSE 1
END,
q.count
FROM aif_bal_rule_loads b,
aif_processes p,
(SELECT COUNT(*) COUNT
FROM tdataarchive
WHERE ARCHIVESETID = ?
AND rule_id = ?
) q
WHERE b.loadid = ?
AND p.process_id = b.loadid
AND p.application_id = b.application_id
2017-11-08 16:01:33,496 DEBUG [AIF]: EPMFDM-140274:Message - insert into tdataarchive(
ARCHIVEDOCKEY,
PARTITIONKEY,
CATKEY,
PERIODKEY,
ARCHIVEID,
ARCHIVESETID,
ARCHIVECREATOR,
ARCHIVEFILENAME,
ARCHIVEEXTENSION,
ARCHIVEDOCTYPEID,
ARCHIVEPROCTYPEID,
ARCHIVETIMESTAMP,
RULE_ID
)
values(?,?,?,?,?, ?,?,?,?,?, ?,current_timestamp,?)
2017-11-08 16:01:33,503 DEBUG [AIF]: EPMFDM-140274:Message - update aif_process_details set status = ? , records_processed = ?, EXECUTION_END_TIME = CURRENT_TIMESTAMP where process_id = ? and entity_type = ? and entity_name = ?
2017-11-08 16:01:33,506 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End
2017-11-08 16:01:33,507 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 150273
2017-11-08 16:01:33,509 INFO [AIF]: EPMFDM-140274:Message - Releasing JythonInterpreter
2017-11-08 16:01:33,511 DEBUG [AIF]: FileData.importData - END
2017-11-08 16:01:34,186 DEBUG [AIF]: CommData.postImportData - START
2017-11-08 16:01:34,187 DEBUG [AIF]: CommData.getRuleInfo - START
2017-11-08 16:01:34,377 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 = 2
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 = 2
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
AND (adim.VALID_FOR_PLAN1 = 1 OR dim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')
ORDER BY adim.BALANCE_COLUMN_NAME
2017-11-08 16:01:34,412 DEBUG [AIF]: {'APPLICATION_ID': 2L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': u'PLAN1', 'RULE_NAME': u'SFDetail_Staging_DLR', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 1L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SOURCE_SYSTEM_TYPE': u'FILE', 'CHECK_FLAG': u'N', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'SFReport', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'KK_FLAG': u'N', 'IMPGROUPKEY': u'SF_Report_Staging', 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'N', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD1', u'UD2'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'hchong', 'DIMNAME_MAP': {u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 1L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 5L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 4L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Version', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 2L}}, 'TARGET_APPLICATION_TYPE': u'HPL', 'PARTITIONKEY': 2L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 1L, 'MULTI_PERIOD_FILE_FLAG': u'N', 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'DELIMITED', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 6L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://servername.octfcu.org:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 2L, 'IMPTARGETSOURCESYSTEMID': 0L}
2017-11-08 16:01:34,413 DEBUG [AIF]: CommData.getRuleInfo - END
2017-11-08 16:01:34,421 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2017-11-08 16:01:34,425 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2017-11-08 16:01:34,426 DEBUG [AIF]: CommData.getLedgerSQL - START
2017-11-08 16:01:34,427 DEBUG [AIF]: CommData.getLedgerSQL - END
2017-11-08 16:01:34,427 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 = 6
2017-11-08 16:01:34,482 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2017-11-08 16:01:34,486 DEBUG [AIF]: CommData.getPovList - START
2017-11-08 16:01:34,489 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, CONVERT(VARCHAR,pprd.PERIODKEY,120)) PERIODDESC
,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF_PROCESS_PERIODS pprd
ON pprd.PROCESS_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY AND pp.INTSYSTEMKEY = 'SFReport'
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 = 770
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2017-11-08 16:01:34,497 DEBUG [AIF]: CommData.getPovList - END
2017-11-08 16:01:34,498 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 = 770
AND en.process_id = pp.process_id
AND pp.IMP_ENTITY_NAME = en.file_entity_name
order by en.entity_name_order
2017-11-08 16:01:34,531 INFO [AIF]:
Import Data from Source for Period 'Sep-17'
2017-11-08 16:01:34,540 DEBUG [AIF]: CommData.updateWorkflow - START
2017-11-08 16:01:34,541 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 = 2 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2017-09-30' AND tlp.RULE_ID = 6 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2017-11-08 16:01:34,549 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=2 AND CATKEY=1 AND PERIODKEY='2017-09-30' AND RULE_ID=6
2017-11-08 16:01:34,561 DEBUG [AIF]: CommData.updateWorkflow - END
2017-11-08 16:01:34,561 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
AND adim.VALID_FOR_PLAN1 = 1
INNER JOIN AIF_DIMENSIONS dim
ON dim.DIMENSION_ID = adim.DIMENSION_ID
WHERE tpp.PARTITIONKEY = 2
AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
ORDER BY adim.BALANCE_COLUMN_NAME
2017-11-08 16:01:34,573 DEBUG [AIF]:
UPDATE TDATASEG_T
SET AMOUNTX = AMOUNT
,ACCOUNTX = NULL
,ENTITYX = NULL
,UD1X = NULL
,UD2X = NULL
WHERE TDATASEG_T.LOADID = 770 AND TDATASEG_T.PARTITIONKEY = 2 AND TDATASEG_T.CATKEY = 1 AND TDATASEG_T.PERIODKEY = '2017-09-30'
2017-11-08 16:01:35,204 INFO [AIF]: Generic Data Rows Imported from Source: 100122
2017-11-08 16:01:35,205 DEBUG [AIF]:
INSERT INTO AIF_APPL_LOAD_AUDIT (
LOADID
,TARGET_APPLICATION_TYPE
,TARGET_APPLICATION_NAME
,PLAN_TYPE
,SOURCE_LEDGER_ID
,EPM_YEAR
,EPM_PERIOD
,SNAPSHOT_FLAG
,PARTITIONKEY
,CATKEY
,RULE_ID
,PERIODKEY
,EXPORT_TO_TARGET_FLAG
)
SELECT DISTINCT PROCESS_ID LOADID
,'HPL' TARGET_APPLICATION_TYPE
,'SFReport' TARGET_APPLICATION_NAME
,'PLAN1' PLAN_TYPE
,0 SOURCE_LEDGER_ID
,YEARTARGET EPM_YEAR
,PERIODTARGET EPM_PERIOD
,'Y' SNAPSHOT_FLAG
,2 PARTITIONKEY
,1 CATKEY
,6 RULE_ID
,PERIODKEY
,'N' EXPORT_TO_TARGET_FLAG
FROM AIF_PROCESS_PERIODS
WHERE PROCESS_ID = 770
AND PERIODKEY = '2017-09-30'
2017-11-08 16:01:35,220 INFO [AIF]: Total Data Rows Imported from Source: 100122
2017-11-08 16:01:35,220 DEBUG [AIF]: CommData.updateTDATASEG_T - END
2017-11-08 16:01:35,227 DEBUG [AIF]: Comm.doScriptInit - START
2017-11-08 16:01:35,414 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\inbox, LOCNAME=SFRepDetail, SOURCENAME=File, APPID=2, SOURCEID=1, APPROOTDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE, IMPORTFORMAT=SF_Report_Detail, SCRIPTSDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HPL, RULEID=6, CATNAME=ACTUAL, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=770, PERIODNAME=Sep-17, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-09-30, EXPORTFLAG=N, TARGETAPPDB=PLAN1, TARGETAPPNAME=SFReport, FILENAME=Detail_Sep-17.txt, LOCKEY=2, RULENAME=SFDetail_Staging_DLR, OUTBOXDIR=\\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=1, USERNAME=hchong, FILEDIR=inbox, IMPORTFLAG=Y, USERLOCALE=null}
2017-11-08 16:01:35,443 DEBUG [AIF]: The executeEventScript is set to: YES
2017-11-08 16:01:35,444 DEBUG [AIF]: The AppRootFolder is set to: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE
2017-11-08 16:01:35,444 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2017-11-08 16:01:35,445 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2017-11-08 16:01:35,445 DEBUG [AIF]: Comm.doScriptInit - END
2017-11-08 16:01:35,446 DEBUG [AIF]: Comm.executeScript - START
2017-11-08 16:01:35,449 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/data/scripts/event/AftImport.py
2017-11-08 16:01:35,453 DEBUG [AIF]: Comm.executeVBScript - START
2017-11-08 16:01:35,454 DEBUG [AIF]: The WindowsTempFolder is set to: c:\users\hypser~1\appdata\local\temp
2017-11-08 16:01:35,457 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\data\scripts\event\AftImport.vbs
2017-11-08 16:01:35,457 DEBUG [AIF]: Comm.executeVBScript - END
2017-11-08 16:01:35,458 DEBUG [AIF]: Comm.executeScript - END
2017-11-08 16:01:35,459 DEBUG [AIF]: CommData.postImportData - END
2017-11-08 16:01:36,984 DEBUG [AIF]: LogicGroup.createLogicAccounts - START
2017-11-08 16:01:36,985 DEBUG [AIF]: Comm.executeScript - START
2017-11-08 16:01:36,988 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/data/scripts/event/BefProcLogicGrp.py
2017-11-08 16:01:36,988 DEBUG [AIF]: Comm.executeVBScript - START
2017-11-08 16:01:36,990 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\data\scripts\event\BefProcLogicGrp.vbs
2017-11-08 16:01:36,991 DEBUG [AIF]: Comm.executeVBScript - END
2017-11-08 16:01:36,992 DEBUG [AIF]: Comm.executeScript - END
2017-11-08 16:01:36,994 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START
2017-11-08 16:01:36,994 DEBUG [AIF]:
select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE
from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp
where prs.PROCESS_ID=770 and prs.PARTITIONKEY=part.PARTITIONKEY
and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY
2017-11-08 16:01:37,001 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END
2017-11-08 16:01:37,002 DEBUG [AIF]: Comm.executeScript - START
2017-11-08 16:01:37,005 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/data/scripts/event/AftProcLogicGrp.py
2017-11-08 16:01:37,005 DEBUG [AIF]: Comm.executeVBScript - START
2017-11-08 16:01:37,008 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\data\scripts\event\AftProcLogicGrp.vbs
2017-11-08 16:01:37,008 DEBUG [AIF]: Comm.executeVBScript - END
2017-11-08 16:01:37,009 DEBUG [AIF]: Comm.executeScript - END
2017-11-08 16:01:37,009 DEBUG [AIF]: LogicGroup.createLogicAccounts - END
2017-11-08 16:01:37,059 DEBUG [AIF]: CommData.mapData - START
2017-11-08 16:01:37,060 DEBUG [AIF]: Comm.executeScript - START
2017-11-08 16:01:37,063 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE/data/scripts/event/BefProcMap.py
2017-11-08 16:01:37,064 DEBUG [AIF]: Comm.executeVBScript - START
2017-11-08 16:01:37,067 DEBUG [AIF]: The following script does not exist: \\octfcu.org\CUData\Hyperion\hyp_prod\FDMEE\data\scripts\event\BefProcMap.vbs
2017-11-08 16:01:37,067 DEBUG [AIF]: Comm.executeVBScript - END
2017-11-08 16:01:37,067 DEBUG [AIF]: Comm.executeScript - END
2017-11-08 16:01:37,069 DEBUG [AIF]: CommData.insertTransProcessDetails - START
2017-11-08 16:01:37,071 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, 'hchong' 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 = 770
AND PRIOR_PERIOD_FLAG = 'N'
GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME
) q
ORDER BY ENTITY_NAME_ORDER
2017-11-08 16:01:37,082 DEBUG [AIF]: CommData.insertTransProcessDetails - END
2017-11-08 16:01:37,089 DEBUG [AIF]:
DELETE FROM TDATAMAP_T
WHERE LOADID < 770
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 6 AND p.PROCESS_ID = TDATAMAP_T.LOADID )
2017-11-08 16:01:37,111 DEBUG [AIF]:
DELETE FROM TDATASEG_T
WHERE LOADID < 770
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 6 AND p.PROCESS_ID = TDATASEG_T.LOADID )
2017-11-08 16:01:37,187 DEBUG [AIF]:
DELETE FROM AIF_PROCESS_PERIODS
WHERE PROCESS_ID < 770
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 6 AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID )
2017-11-08 16:01:37,199 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START
2017-11-08 16:01:37,202 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START
2017-11-08 16:01:37,203 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 = 2
2017-11-08 16:01:37,207 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END
2017-11-08 16:01:37,208 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 770, DATAKEY, 2 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 = 2
AND ( RULE_ID IS NULL OR RULE_ID = 6 )
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-11-08 16:01:37,300 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 2323
2017-11-08 16:01:37,348 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START
2017-11-08 16:01:37,350 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 = 770
AND atad.APPLICATION_ID = 2
AND tdm.PARTITIONKEY = 2
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 6)
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 = 770
AND atad.APPLICATION_ID = 2
AND tdm.PARTITIONKEY = 2
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 6)
AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')
) q
ORDER BY CALC_SEQ, DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY
2017-11-08 16:01:37,399 INFO [AIF]:
Map Data for Period 'Sep-17'
2017-11-08 16:01:37,401 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-11-08 16:01:37,403 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 ('hchong' IS NULL) THEN LAST_UPDATED_BY ELSE 'hchong' END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 770 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Sep-17'
2017-11-08 16:01:37,410 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-11-08 16:01:37,413 DEBUG [AIF]:
SELECT COUNT(*) ROW_COUNT
FROM TDATASEG_T
WHERE LOADID = 770
AND (PARTITIONKEY = 2 AND CATKEY = 1 AND PERIODKEY = '2017-09-30' AND RULE_ID = 6 AND VALID_FLAG = 'Y')
2017-11-08 16:01:37,586 INFO [AIF]:
Processing Mappings for Column 'ACCOUNT'
2017-11-08 16:01:37,587 DEBUG [AIF]:
UPDATE TDATASEG_T SET
ACCOUNTX = (
SELECT tdm.TARGKEY
FROM TDATAMAP_T tdm
WHERE tdm.LOADID = TDATASEG_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG_T.ACCOUNT
AND tdm.RULE_ID IS NULL
AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )
,ACCOUNTR = (
SELECT tdm.DATAKEY
FROM TDATAMAP_T tdm
WHERE tdm.LOADID = TDATASEG_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG_T.ACCOUNT
AND tdm.RULE_ID IS NULL
AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )
,ACCOUNTF = 1
,AMOUNTX = AMOUNTX * (
SELECT CASE tdm.CHANGESIGN WHEN 1 THEN -1 ELSE 1 END
FROM TDATAMAP_T tdm
WHERE tdm.LOADID = TDATASEG_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG_T.ACCOUNT
AND tdm.RULE_ID IS NULL
AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )
,CHANGESIGN=(SELECT CASE tdm.CHANGESIGN
WHEN 1 THEN CASE TDATASEG_T.CHANGESIGN
WHEN 1 THEN 0
WHEN 0 THEN 1
ELSE TDATASEG_T.CHANGESIGN END
ELSE TDATASEG_T.CHANGESIGN END
FROM TDATAMAP_T tdm
WHERE tdm.LOADID = TDATASEG_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG_T.ACCOUNT
AND tdm.RULE_ID IS NULL
AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )
,VALID_FLAG =CASE (
SELECT tdm.TARGKEY
FROM TDATAMAP_T tdm
WHERE tdm.LOADID = TDATASEG_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG_T.ACCOUNT
AND tdm.RULE_ID IS NULL
AND tdm.TDATAMAPTYPE <> 'MULTIDIM' ) WHEN 'IGNORE' THEN 'I' ELSE VALID_FLAG END
WHERE LOADID = 770
AND PARTITIONKEY = 2
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND EXISTS ( SELECT 1
FROM TDATAMAP_T tdm
WHERE tdm.LOADID = TDATASEG_T.LOADID
AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY
AND tdm.DIMNAME = 'ACCOUNT'
AND tdm.WHERECLAUSETYPE IS NULL
AND tdm.SRCKEY = TDATASEG_T.ACCOUNT
AND tdm.RULE_ID IS NULL
AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )
AND PERIODKEY = '2017-09-30'
2017-11-08 16:01:43,928 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-11-08 16:01:43,929 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 ('hchong' IS NULL) THEN LAST_UPDATED_BY ELSE 'hchong' END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 770 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Sep-17'
2017-11-08 16:01:43,948 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-11-08 16:01:43,955 DEBUG [AIF]: CommData.updateWorkflow - START
2017-11-08 16:01:43,966 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,P