Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDMEE error loading on import

Hello_KittyNov 8 2017 — edited Nov 9 2017

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') )

(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'

( 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

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

This post has been answered by DayalanP on Nov 8 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2017

Added on Nov 8 2017

#business-intelligence-applications, #financial-data-management, #performance-management-applications

5 comments

2,073 views