Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 533.9K On-Premises Infrastructure
- 137.5K Analytics Software
- 38.5K Application Development Software
- 5.2K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105K Integration
- 41.5K Security Software
FDM export Issue
Hello FDM expertise,
I follow all the steps to upload the data into FCCS it imported successfully but failed in export
please check the log file and advise
Thank you,
2020-02-19 12:48:34,808 INFO [AIF]: FDMEE Process: 395, Log Level: 5
2020-02-19 12:48:34,808 INFO [AIF]: Location : LRL_LOC (Partitionkey:42)
2020-02-19 12:48:34,808 INFO [AIF]: Period Name : Dec-19 (Period Key:12/31/19 12:00 AM)
2020-02-19 12:48:34,808 INFO [AIF]: Category Name: Actual (Category key:1)
2020-02-19 12:48:34,808 INFO [AIF]: Rule Name : LRL_TB (Rule ID:17)
2020-02-19 12:48:36,106 DEBUG [AIF]: FDMEE Version: 11.1.2.4.000, p1_2002_008.drv
2020-02-19 12:48:36,106 INFO [AIF]: Log File Encoding: UTF-8
2020-02-19 12:48:37,111 INFO [AIF]: -------START IMPORT STEP-------
2020-02-19 12:48:37,234 DEBUG [AIF]: FileData.extractDataFromSource - START
2020-02-19 12:48:37,234 DEBUG [AIF]: CommData.getRuleInfo - START
2020-02-19 12:48:37,236 DEBUG [AIF]:
SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, adim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR
,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1
FROM TPOVPARTITION tpp
INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim
ON adim.APPLICATION_ID = 7
LEFT OUTER JOIN TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 42
AND adim.BALANCE_COLUMN_NAME IS NOT NULL
AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'
AND (adim.VALID_FOR_PLAN1 = 1 OR adim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')
ORDER BY adim.BALANCE_COLUMN_NAME
2020-02-19 12:48:37,237 DEBUG [AIF]: SELECT property_value FROM aif_target_appl_properties WHERE application_id = 7 and property_type = 'WORKFLOW_MODE'
2020-02-19 12:48:37,238 DEBUG [AIF]: {'PLAN_NUMBER': 1L, 'EXPORT_TO_TARGET_FLAG': u'Y', 'SRC_TARGET_APP_NAME': 'NA', 'JOURNAL_FLAG': None, 'DIMNAME_MAP': {u'UD2': {'DIMNAME': u'UD2', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD4': {'DIMNAME': u'UD4', 'TARGET_DIMENSION_CLASS_NAME': u'Data Source'}, u'UD3': {'DIMNAME': u'UD3', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD5': {'DIMNAME': u'UD5', 'TARGET_DIMENSION_CLASS_NAME': u'Movement'}, u'ACCOUNT': {'DIMNAME': u'ACCOUNT', 'TARGET_DIMENSION_CLASS_NAME': u'Account'}, u'ENTITY': {'DIMNAME': u'ENTITY', 'TARGET_DIMENSION_CLASS_NAME': u'Entity'}, u'ICP': {'DIMNAME': u'ICP', 'TARGET_DIMENSION_CLASS_NAME': u'ICP'}}, 'CATKEY': 1L, 'TGT_APP_SUB_TYPE': u'FCCS', 'TGT_APP_ID': 7L, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD2', u'UD3', u'UD4', u'UD5'], 'SRC_SOURCE_SYSTEM_ID': 1L, 'TGT_SOURCE_SYSTEM_TYPE': None, 'TGT_APP_TYPE': u'HPL', 'CALENDAR_ID': None, 'TGT_TARGET_APP_NAME': u'RL_CONS', 'PARTITIONKEY': 42L, 'EXECUTION_MODE': u'REPLACE', 'LEDGER_GROUP_CODE': u'NONE', 'PS_LEDGER': None, 'SRC_DATA_LOAD_METHOD': 'NA', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://nladpbcsr914033.nldc1.oraclecloud.com:9000/aif', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'IS_INCREMENTAL_LOAD': False, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'SRC_APP_NAME': 'NA', 'FCI_FLAG': 'N', 'KK_FLAG': u'N', 'LAST_UPDATED_BY': u'[email protected]', 'CHECK_FLAG': u'Y', 'RULE_ID': 17L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SRC_APP_ID': None, 'INCLUDE_ZERO_BALANCE_FLAG': None, 'IMPGROUPKEY': u'RL_TB', 'WORKFLOW_MODE': u'FULL', 'TGT_SOURCE_SYSTEM_ID': 0L, 'SRC_APP_TYPE': 'NA', 'TGT_APP_NAME': u'RL_CONS', 'IMPGROUPFILETYPE': u'DELIMITED', 'LEDGER_GROUP': None, 'TGT_COA_ID': 0L, 'SOURCE_ADAPTER_FLAG': u'N', 'RECALCULATE_FLAG': u'Y', 'TGT_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'SRC_SOURCE_SYSTEM_TYPE': u'FILE', 'PLAN_TYPE': u'PLAN1', 'TGT_METADATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}
2020-02-19 12:48:37,239 DEBUG [AIF]: {u'Intercompany': {'BCN': u'ICP', 'DCN': u'ICP'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Business Segment': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Movement': {'BCN': u'UD5', 'DCN': u'Movement'}, u'Years': {'BCN': None, 'DCN': u'Year'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'View': {'BCN': None, 'DCN': u'View'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Commodity': {'BCN': u'UD3', 'DCN': u'Generic'}, u'Consolidation': {'BCN': None, 'DCN': u'Consolidation'}, u'Data Source': {'BCN': u'UD4', 'DCN': u'Data Source'}, u'Currency': {'BCN': None, 'DCN': u'Currency'}}
2020-02-19 12:48:37,239 DEBUG [AIF]: {u'UD2': {'IMPFLDSOURCECOLNAME': u'Class'}, u'UD3': {'IMPFLDSOURCECOLNAME': u'Location'}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': u'AccountNumber'}, u'ENTITY': {'IMPFLDSOURCECOLNAME': u'Company'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Amount_homebase'}, u'ICP': {'IMPFLDSOURCECOLNAME': u'Dealer'}, u'DESC1': {'IMPFLDSOURCECOLNAME': u'Account Name Long'}}
2020-02-19 12:48:37,239 DEBUG [AIF]: CommData.getRuleInfo - END
2020-02-19 12:48:37,240 DEBUG [AIF]: FileData.extractDataFromSource - END
2020-02-19 12:48:37,259 DEBUG [AIF]: FileData.preProcessDataFile - START
2020-02-19 12:48:37,290 DEBUG [AIF]: FileData.preProcessDataFile - END
2020-02-19 12:48:37,311 DEBUG [AIF]: CommData.preImportData - START
2020-02-19 12:48:37,311 DEBUG [AIF]: CommData.insertFilePeriods - START
2020-02-19 12:48:37,313 DEBUG [AIF]: doAppPeriodMappingsExist - RL_CONS: N
2020-02-19 12:48:37,313 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 395 AND PARAMETER_TYPE = 'SOURCE_PERIODS'
2020-02-19 12:48:37,313 DEBUG [AIF]: Period mapping section: SINGLE-COLUMN/DEFAULT
2020-02-19 12:48:37,314 DEBUG [AIF]:
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, 0 GL_PERIOD_NUM, '0' GL_PERIOD_NAME, 0 GL_PERIOD_YEAR
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN TPOVCATEGORY pc
ON pc.CATKEY = brl.CATKEY
INNER JOIN TPOVPERIOD_FLAT_V pp
ON pp.PERIODFREQ = pc.CATFREQ AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY
WHERE brl.LOADID = 395
ORDER BY PERIODKEY
2020-02-19 12:48:37,314 INFO [AIF]: File Name: LRL YTD TB Dec-19.csv
2020-02-19 12:48:37,314 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, GL_PERIOD_YEAR_CHAR)
VALUES (395,'2019-12-31','N',0,'0' ,'0',0,1,'FY19','Dec', 'PROCESS_BAL_IMP_FILE','LRL YTD TB Dec-19.csv','PROCESS_BAL_TRANS','Dec-19','N', 0)
2020-02-19 12:48:37,315 DEBUG [AIF]: insertRowCount: 1
2020-02-19 12:48:37,317 DEBUG [AIF]: CommData.insertFilePeriods - END
2020-02-19 12:48:37,317 DEBUG [AIF]: CommData.getPovList - START
2020-02-19 12:48:37,317 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC
,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG
FROM AIF_BAL_RULE_LOADS brl
INNER JOIN AIF_BALANCE_RULES br
ON br.RULE_ID = brl.RULE_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF_PROCESS_PERIODS pprd
ON pprd.PROCESS_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIOD pp
ON pp.PERIODKEY = pprd.PERIODKEY
LEFT OUTER JOIN TLOGPROCESS tlp
ON tlp.PARTITIONKEY = brl.PARTITIONKEY AND tlp.CATKEY = brl.CATKEY AND tlp.PERIODKEY = pprd.PERIODKEY AND tlp.RULE_ID = brl.RULE_ID
WHERE brl.LOADID = 395
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID
2020-02-19 12:48:37,318 DEBUG [AIF]: CommData.getPovList - END
2020-02-19 12:48:37,318 DEBUG [AIF]: CommData.preImportData - END
2020-02-19 12:48:37,338 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2020-02-19 12:48:37,338 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, '[email protected]' 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 = 395
) q
ORDER BY ENTITY_NAME_ORDER
2020-02-19 12:48:37,340 DEBUG [AIF]: Comm.doScriptInit - START
2020-02-19 12:48:37,391 DEBUG [AIF]: fdmContext: {PERIODKEY=2019-12-31, CATKEY=1, APPNAME=RL_CONS, EXPORTFLAG=Y, SOURCEID=1, TARGETAPPNAME=RL_CONS, USERLOCALE=en, IMPORTFLAG=Y, SOURCENAME=File, PERIODNAME=Dec-19, LOCNAME=LRL_LOC, [email protected], FILENAME=LRL YTD TB Dec-19.csv, TARGETAPPTYPE=HPL, TARGETAPPDB=PLAN1, FILEDIR=inbox/Group.LRL, APPID=7, MULTIPERIODLOAD=N, LOADID=395, RULEID=17, IMPORTMODE=REPLACE, SOURCETYPE=FILE, CATNAME=Actual, RULENAME=LRL_TB, LOCKEY=42, EXPORTMODE=Merge, IMPORTFORMAT=RL_TB}
2020-02-19 12:48:37,392 DEBUG [AIF]: Comm.doScriptInit - END
2020-02-19 12:48:37,392 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2020-02-19 12:48:37,412 DEBUG [AIF]: FileData.importData - START
2020-02-19 12:48:37,412 DEBUG [AIF]: Importing data for load id: 395
2020-02-19 12:48:37,413 DEBUG [AIF]:
SELECT a.partitionkey, a.catkey, a.start_periodkey, b.perioddesc, coalesce(a.journal_flag,'N') JOURNAL_FLAG, c.last_updated_by,
coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC, a.FILE_PATH, a.RULE_ID, a.application_id
FROM aif_bal_rule_loads a,
aif_balance_rules br,
tpovperiod b,
aif_processes c
WHERE a.loadid = 395
AND a.start_periodkey=b.periodkey
AND a.loadid =c.process_id
AND br.rule_id = a.rule_id
2020-02-19 12:48:37,414 DEBUG [AIF]: FileData.py: Importing Text data for load id: 395
2020-02-19 12:48:37,468 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:IMPGROUPFILETYPE::395;42:1:17:Entity Currency::DELIMITED
2020-02-19 12:48:37,472 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2020-02-19 12:48:37,472 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2020-02-19 12:48:37,472 DEBUG [AIF]: EPMFDM-140274:Message - SELECT pp.PERIODKEY,
pp.PERIODTARGET,
pp.GL_PERIOD_NAME,
en.FILE_ENTITY_NAME,
en.ENTITY_NAME_ORDER,
br.MULTI_PERIOD_FILE_FLAG,
pp.TRANS_ENTITY_NAME,
pp.GL_PERIOD_YEAR_CHAR,
pp.GL_PERIOD_NUM ,
pp.YEARTARGET
FROM AIF_PROCESS_PERIODS pp,
AIF_BALANCE_RULES br,
AIF_PROCESSES p,
(SELECT DISTINCT entity_name FILE_ENTITY_NAME,
pd.process_id,
pd.entity_name_order
FROM aif_process_details pd
WHERE pd.entity_type = 'PROCESS_BAL_IMP_FILE'
AND pd.target_table_name = 'TDATASEG'
AND pd.status = 'PENDING'
) en
WHERE pp.PROCESS_ID = ?
AND p.process_id = pp.process_id
AND en.process_id = pp.process_id
AND pp.IMP_ENTITY_NAME = en.file_entity_name
AND br.rule_id = p.rule_id
AND en.entity_name_order = pp.GL_EFFECTIVE_PERIOD_NUM
ORDER BY en.entity_name_order
2020-02-19 12:48:37,505 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=9:SourceClName=Amount_homebase:ImpFldTargetExp=null
2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=3:SourceClName=Account Name Long:ImpFldTargetExp=null
2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=AccountNumber:ImpFldTargetExp=null
2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=4:SourceClName=Class:ImpFldTargetExp=null
2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=5:SourceClName=Location:ImpFldTargetExp=null
2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Company:ImpFldTargetExp=null
2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=6:SourceClName=Dealer:ImpFldTargetExp=null
2020-02-19 12:48:37,506 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2020-02-19 12:48:37,506 INFO [AIF]: EPMFDM-140274:Message - File Name LRL YTD TB Dec-19.csv
periodKey2019-12-31
2020-02-19 12:48:37,514 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 395
PARTITIONKEY: 42
IMPORT GROUP: RL_TB
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: LRL YTD TB Dec-19.csv
PROCESSING CODES:
-----------------------------------------------------------------------------------
- BLANK............. Line is blank or empty.
- NN................ Non-Numeric, Amount field contains non numeric characters.
- TC................ Type Conversion, Amount field could not be converted to a number.
- ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.
SKIP FIELD.............. SKIP field value was found
NULL ACCOUNT VALUE.............. Account Field is null
SKIP FROM SCRIPT.............. Skipped through Script
HEADER ROW.............. Header Row
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.
[TC] - [Amount=NN] company,AccountNumber,AccountNameLong,Class,Location,Dealer,OriginalDealerName,ICT, Amount_homebase ,Year1,Month1, Currency , Rate to USD , Amount_USD , Comment
Rows Loaded: 56
Rows Rejected: 1
2020-02-19 12:48:37,514 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start
2020-02-19 12:48:37,514 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy
2020-02-19 12:48:37,514 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:
2020-02-19 12:48:37,514 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 39520191231
2020-02-19 12:48:37,514 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: LRL YTD TB Dec-19
Extension: csv
2020-02-19 12:48:37,515 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 39520191231.csv
2020-02-19 12:48:37,516 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: LRL YTD TB Dec-19.csv
2020-02-19 12:48:37,516 INFO [AIF]: EPMFDM-140274:Message - File not deleted: LRL YTD TB Dec-19.csv
2020-02-19 12:48:37,518 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:LRL YTD TB [email protected]-20200219_124837-1
2020-02-19 12:48:37,520 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End
2020-02-19 12:48:37,522 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End
2020-02-19 12:48:37,522 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 50
2020-02-19 12:48:37,525 DEBUG [AIF]: FileData.importData - END
2020-02-19 12:48:37,582 DEBUG [AIF]: CommData.postImportData - START
2020-02-19 12:48:37,582 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2020-02-19 12:48:37,583 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 = 395
AND en.process_id = pp.process_id
AND pp.IMP_ENTITY_NAME = en.file_entity_name
order by en.entity_name_order
2020-02-19 12:48:37,583 INFO [AIF]:
Import Data from Source for Period 'Dec-19'
2020-02-19 12:48:37,584 DEBUG [AIF]: CommData.updateWorkflow - START
2020-02-19 12:48:37,584 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 = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2020-02-19 12:48:37,584 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=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17
2020-02-19 12:48:37,586 DEBUG [AIF]: CommData.updateWorkflow - END
2020-02-19 12:48:37,586 DEBUG [AIF]: CommData.updateTDATASEG_T - END
2020-02-19 12:48:37,586 DEBUG [AIF]: CommData.postImportData - END
2020-02-19 12:48:37,603 DEBUG [AIF]: LogicGroup.createLogicAccounts - START
2020-02-19 12:48:37,603 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START
2020-02-19 12:48:37,603 DEBUG [AIF]:
select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE
from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp
where prs.PROCESS_ID=395 and prs.PARTITIONKEY=part.PARTITIONKEY
and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY
2020-02-19 12:48:37,604 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END
2020-02-19 12:48:37,604 DEBUG [AIF]: LogicGroup.createLogicAccounts - END
2020-02-19 12:48:37,622 DEBUG [AIF]: CommData.mapData - START
2020-02-19 12:48:37,622 DEBUG [AIF]: CommData.insertTransProcessDetails - START
2020-02-19 12:48:37,622 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, '[email protected]' 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 = 395
AND PRIOR_PERIOD_FLAG = 'N'
GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME
) q
ORDER BY ENTITY_NAME_ORDER
2020-02-19 12:48:37,624 DEBUG [AIF]: CommData.insertTransProcessDetails - END
2020-02-19 12:48:37,624 DEBUG [AIF]:
DELETE FROM TDATAMAP_T
WHERE LOADID < 395
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = TDATAMAP_T.LOADID )
2020-02-19 12:48:37,625 DEBUG [AIF]:
SELECT COUNT(*) FROM TDATASEG_T
WHERE LOADID < 395
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = TDATASEG_T.LOADID )
2020-02-19 12:48:37,626 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False
2020-02-19 12:48:37,626 INFO [AIF]: Executing delete statement:
2020-02-19 12:48:37,626 DEBUG [AIF]:
DELETE FROM TDATASEG_T
WHERE LOADID < 395
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = TDATASEG_T.LOADID )
2020-02-19 12:48:37,627 INFO [AIF]: Successfully executed delete statement
2020-02-19 12:48:37,627 DEBUG [AIF]:
DELETE FROM AIF_PROCESS_PERIODS
WHERE PROCESS_ID < 395
AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID )
2020-02-19 12:48:37,629 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START
2020-02-19 12:48:37,629 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START
2020-02-19 12:48:37,629 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 = 42
2020-02-19 12:48:37,629 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END
2020-02-19 12:48:37,630 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 395, DATAKEY, 42 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '<BLANK>' THEN ' ' ELSE TARGKEY END
,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID
FROM TDATAMAP
WHERE PARTITIONKEY = 42
AND ( RULE_ID IS NULL OR RULE_ID = 17 )
2020-02-19 12:48:37,631 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 21
2020-02-19 12:48:37,632 DEBUG [AIF]: CommMap.loadTDATAMAP_T - END
2020-02-19 12:48:37,632 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START
2020-02-19 12:48:37,632 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 = 395
AND atad.APPLICATION_ID = 7
AND tdm.PARTITIONKEY = 42
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 17)
AND tdm.WHERECLAUSETYPE IS NULL
UNION ALL
SELECT tdm.DIMNAME, tdm.RULE_ID, tdm.SRCKEY, tdm.TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, tdm.CHANGESIGN
,CASE WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2 WHEN (tdm.WHERECLAUSETYPE = 'IN') THEN 3
WHEN (tdm.WHERECLAUSETYPE = 'MULTIDIM') THEN 4 WHEN (tdm.WHERECLAUSETYPE = 'LIKE') THEN 5
ELSE 0 END SEQUENCE
,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG, tdm.DATAKEY
,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING_TYPE, COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ
FROM TDATAMAP_T tdm
INNER JOIN TPOVPARTITION tpp ON tpp.PARTITIONKEY = tdm.PARTITIONKEY
INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME
WHERE tdm.LOADID = 395
AND atad.APPLICATION_ID = 7
AND tdm.PARTITIONKEY = 42
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 17)
AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')
) q
ORDER BY CALC_SEQ, DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY
2020-02-19 12:48:37,634 DEBUG [AIF]: SELECT VBSCRIPT FROM TDATAMAP_T WHERE LOADID = 395 AND PARTITIONKEY = 42 AND DATAKEY = 2461
2020-02-19 12:48:37,635 INFO [AIF]:
Map Data for Period 'Dec-19'
2020-02-19 12:48:37,635 DEBUG [AIF]: Comm.updateProcessDetail - START
2020-02-19 12:48:37,635 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 ('[email protected]' IS NULL) THEN LAST_UPDATED_BY ELSE '[email protected]' END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 395 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Dec-19'
2020-02-19 12:48:37,636 DEBUG [AIF]: Comm.updateProcessDetail - END
2020-02-19 12:48:37,636 DEBUG [AIF]:
SELECT COUNT(*) ROW_COUNT
FROM TDATASEG_T
WHERE LOADID = 395
AND (PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31' AND RULE_ID = 17 AND VALID_FLAG = 'Y')
2020-02-19 12:48:37,637 INFO [AIF]:
Processing Mappings for Column 'ACCOUNT'
2020-02-19 12:48:37,637 DEBUG [AIF]:
UPDATE TDATASEG_T
SET (ACCOUNTX ,ACCOUNTR, AMOUNTX, CHANGESIGN, VALID_FLAG) = (
SELECT tdm.TARGKEY
,tdm.DATAKEY
,AMOUNTX * CASE tdm.CHANGESIGN WHEN 1 THEN -1 ELSE 1 END
,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
,CASE tdm.TARGKEY WHEN 'IGNORE' THEN 'I' ELSE TDATASEG_T.VALID_FLAG 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'
)
,ACCOUNTF = 1
WHERE LOADID = 395
AND PARTITIONKEY = 42
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 = '2019-12-31'
2020-02-19 12:48:37,640 INFO [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 56
2020-02-19 12:48:37,641 INFO [AIF]:
Processing Mappings for Column 'ENTITY'
2020-02-19 12:48:37,641 DEBUG [AIF]:
UPDATE TDATASEG_T
SET ENTITYX = 'Group.LRL'
,ENTITYR = 2459
,ENTITYF = 3
WHERE LOADID = 395
AND PARTITIONKEY = 42
AND CATKEY = 1
AND (ENTITYX IS NULL OR ENTITYX = '')
AND (1=1)
AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,643 INFO [AIF]: Data Rows Updated by Location Mapping 'e1' (LIKE): 56
2020-02-19 12:48:37,643 INFO [AIF]:
Processing Mappings for Column 'ICP'
2020-02-19 12:48:37,644 DEBUG [AIF]:
UPDATE TDATASEG_T
SET ICPX = Case
When ICP = 'Alliance Stream Limited' Then 'ICP_Group.ASZ'
When ICP = 'Reload Logistics Limited' Then 'ICP_Group.RLM'
When ICP = 'Reload Logistics Ltd (Malta) RLM' Then 'ICP_Group.RLM'
When ICP = 'Alliance Stream Limited (ZMB) ASZ' Then 'ICP_Group.ASZ'
When ICP = 'Reload Logistics' Then 'ICP_Group.MAU'
When ICP = 'Reload Logistics Tanzania Limited' Then 'ICP_Group.RLT'
When ICP = 'Solena Property (Pty) Limited SPL ZAR' Then 'ICP_Group.SOP'
When ICP = 'Siana Property (Pty) Ltd SIPL ZAR' Then 'ICP_Group.SIA'
When ICP = 'Cust - Reload Aquarius Shipping International (Pty) Ltd ZAR' Then 'ICP_Group.CWM'
When ICP = 'Reload Logistics Ltd (Malta)' Then 'ICP_Group.RLM'
When ICP = 'Lions Resources Holding Ltd LRHL' Then 'ICP_Group.LRH'
When ICP = 'Solena Enterprises Ltd (ZMB) SESA' Then 'ICP_Group.SOE'
ELSE 'FCCS_No Intercompany'
END
,ICPR = 2461
,ICPF = 3
WHERE LOADID = 395
AND PARTITIONKEY = 42
AND CATKEY = 1
AND (ICPX IS NULL OR ICPX = '')
AND (1=1)
AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,645 INFO [AIF]: Data Rows Updated by Location Mapping 'IN1' (LIKE): 56
2020-02-19 12:48:37,646 INFO [AIF]:
Processing Mappings for Column 'UD2'
2020-02-19 12:48:37,646 DEBUG [AIF]:
UPDATE TDATASEG_T
SET UD2X = 'No Business Segment'
,UD2R = 2456
,UD2F = 3
WHERE LOADID = 395
AND PARTITIONKEY = 42
AND CATKEY = 1
AND (UD2X IS NULL OR UD2X = '')
AND (1=1)
AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,648 INFO [AIF]: Data Rows Updated by Location Mapping 'b1' (LIKE): 56
2020-02-19 12:48:37,649 INFO [AIF]:
Processing Mappings for Column 'UD3'
2020-02-19 12:48:37,649 DEBUG [AIF]:
UPDATE TDATASEG_T
SET UD3X = 'No Commodity'
,UD3R = 2457
,UD3F = 3
WHERE LOADID = 395
AND PARTITIONKEY = 42
AND CATKEY = 1
AND (UD3X IS NULL OR UD3X = '')
AND (1=1)
AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,651 INFO [AIF]: Data Rows Updated by Location Mapping 'c1' (LIKE): 56
2020-02-19 12:48:37,652 INFO [AIF]:
Processing Mappings for Column 'UD4'
2020-02-19 12:48:37,653 DEBUG [AIF]:
UPDATE TDATASEG_T
SET UD4X = 'FCCS_Managed Data'
,UD4R = 1853
,UD4F = 3
WHERE LOADID = 395
AND PARTITIONKEY = 42
AND CATKEY = 1
AND (UD4X IS NULL OR UD4X = '')
AND (1=1)
AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,654 INFO [AIF]: Data Rows Updated by Location Mapping 'System Generated Map' (LIKE): 56
2020-02-19 12:48:37,656 INFO [AIF]:
Processing Mappings for Column 'UD5'
2020-02-19 12:48:37,656 DEBUG [AIF]:
UPDATE TDATASEG_T
SET UD5X = 'FCCS_OpeningBalanceAdjustment'
,UD5R = 1854
,UD5F = 3
WHERE LOADID = 395
AND PARTITIONKEY = 42
AND CATKEY = 1
AND (UD5X IS NULL OR UD5X = '')
AND (1=1)
AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,658 INFO [AIF]: Data Rows Updated by Location Mapping 'System Generated Map' (LIKE): 56
2020-02-19 12:48:37,659 DEBUG [AIF]: Comm.updateProcessDetail - START
2020-02-19 12:48:37,659 DEBUG [AIF]:
UPDATE AIF_PROCESS_DETAILS
SET STATUS = 'SUCCESS'
,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + 56
,EXECUTION_END_TIME = CURRENT_TIMESTAMP
,LAST_UPDATED_BY = CASE WHEN ('[email protected]' IS NULL) THEN LAST_UPDATED_BY ELSE '[email protected]' END
,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
WHERE PROCESS_ID = 395 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Dec-19'
2020-02-19 12:48:37,661 DEBUG [AIF]: Comm.updateProcessDetail - END
2020-02-19 12:48:37,661 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END
2020-02-19 12:48:37,661 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START
2020-02-19 12:48:37,661 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False
2020-02-19 12:48:37,661 INFO [AIF]:
Stage Data for Period 'Dec-19'
2020-02-19 12:48:37,662 DEBUG [AIF]:
DELETE FROM TDATAMAPSEG
WHERE PARTITIONKEY = 42
AND CATKEY = 1
AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,662 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 20
2020-02-19 12:48:37,662 DEBUG [AIF]:
INSERT INTO TDATAMAPSEG (
DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,
WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG
)
SELECT DATAKEY, PARTITIONKEY, 1, '2019-12-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,
WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG
FROM TDATAMAP_T
WHERE LOADID = 395
2020-02-19 12:48:37,676 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 21
2020-02-19 12:48:37,676 DEBUG [AIF]:
DELETE FROM TDATAMAP_T
WHERE LOADID = 395
2020-02-19 12:48:37,677 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 21
2020-02-19 12:48:37,679 INFO [AIF]: Executing delete statement:
2020-02-19 12:48:37,679 DEBUG [AIF]:
DELETE FROM TDATASEG
WHERE LOADID < 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND RULE_ID = 17 AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,686 INFO [AIF]: Successfully executed delete statement
2020-02-19 12:48:37,686 INFO [AIF]: Number of Rows deleted from TDATASEG: 56
2020-02-19 12:48:37,687 DEBUG [AIF]:
DELETE FROM TDATAMEMOITEMS
WHERE PARTITIONKEY = 42 AND PERIODKEY = '2019-12-31' AND CATKEY = 1 AND RULE_ID = 17
AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)
2020-02-19 12:48:37,687 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0
2020-02-19 12:48:37,687 DEBUG [AIF]:
DELETE FROM TDATAARCHIVE
WHERE PARTITIONKEY = 42 AND PERIODKEY = '2019-12-31' AND CATKEY = 1 AND RULE_ID = 17 AND ARCHIVEPROCTYPEID = 1
AND NOT EXISTS ( SELECT 1
FROM TDATAMEMOITEMS
WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )
2020-02-19 12:48:37,688 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0
2020-02-19 12:48:37,688 INFO [AIF]: Executing insert statement:
2020-02-19 12:48:37,688 DEBUG [AIF]:
INSERT INTO TDATASEG (
DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID
,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2
,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF
,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F
,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F
,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F
,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F
,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F
,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14
,ATTR15, ATTR16, ATTR17, ATTR18, ATTR19, ATTR20, ATTR21, ATTR22, ATTR23, ATTR24, ATTR25, ATTR26, ATTR27
,ATTR28, ATTR29, ATTR30, ATTR31, ATTR32, ATTR33, ATTR34, ATTR35, ATTR36, ATTR37, ATTR38, ATTR39, ATTR40
,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG )
SELECT
DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID
,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2
,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF
,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F
,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F
,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F
,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F
,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F
,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14
,ATTR15, ATTR16, ATTR17, ATTR18, ATTR19, ATTR20, ATTR21, ATTR22, ATTR23, ATTR24, ATTR25, ATTR26, ATTR27
,ATTR28, ATTR29, ATTR30, ATTR31, ATTR32, ATTR33, ATTR34, ATTR35, ATTR36, ATTR37, ATTR38, ATTR39, ATTR40
,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG
FROM TDATASEG_T
WHERE LOADID = 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,697 INFO [AIF]: Successfully executed insert statement
2020-02-19 12:48:37,697 INFO [AIF]: Number of Rows inserted into TDATASEG: 56
2020-02-19 12:48:37,697 INFO [AIF]: Executing delete statement:
2020-02-19 12:48:37,697 DEBUG [AIF]:
DELETE FROM TDATASEG_T
WHERE LOADID = 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31'
2020-02-19 12:48:37,700 INFO [AIF]: Successfully executed delete statement
2020-02-19 12:48:37,700 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 56
2020-02-19 12:48:37,700 DEBUG [AIF]: CommData.updateWorkflow - START
2020-02-19 12:48:37,700 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=1,PROCESSIMP=1,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0
,PROCESSIMPNOTE='AIF_WF_IMP_IMPORT_OK_TXT'
WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17
2020-02-19 12:48:37,702 DEBUG [AIF]: CommData.updateWorkflow - END
2020-02-19 12:48:37,702 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END
2020-02-19 12:48:37,702 DEBUG [AIF]: CommData.mapData - END
2020-02-19 12:48:37,721 INFO [AIF]: -------END IMPORT STEP-------
2020-02-19 12:48:37,740 INFO [AIF]: -------START VALIDATE STEP-------
2020-02-19 12:48:37,760 DEBUG [AIF]: CommData.validateData - START
2020-02-19 12:48:37,760 DEBUG [AIF]: CommMap.validateData - START
2020-02-19 12:48:37,761 INFO [AIF]:
Validate Data Mappings for Period 'Dec-19'
2020-02-19 12:48:37,761 DEBUG [AIF]:
SELECT COUNT(*) ROW_COUNT
FROM TDATASEG
WHERE LOADID = 395
AND (PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31' AND RULE_ID = 17 AND VALID_FLAG = 'Y')
2020-02-19 12:48:37,761 DEBUG [AIF]: CommData.updateWorkflow - START
2020-02-19 12:48:37,762 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 = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2020-02-19 12:48:37,762 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=10,PROCESSVAL=0,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0,BLNVALDIRTY=0
,PROCESSVALNOTE=NULL,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL
WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17
2020-02-19 12:48:37,764 DEBUG [AIF]: CommData.updateWorkflow - END
2020-02-19 12:48:37,764 DEBUG [AIF]:
UPDATE TDATASEG
SET VALID_FLAG = 'N'
WHERE 1=1
AND ( (1=0)
OR (TDATASEG.ACCOUNTX IS NULL OR TDATASEG.ACCOUNTX = '')
OR (TDATASEG.ENTITYX IS NULL OR TDATASEG.ENTITYX = '')
OR (TDATASEG.ICPX IS NULL OR TDATASEG.ICPX = '')
OR (TDATASEG.UD2X IS NULL OR TDATASEG.UD2X = '')
OR (TDATASEG.UD3X IS NULL OR TDATASEG.UD3X = '')
OR (TDATASEG.UD4X IS NULL OR TDATASEG.UD4X = '')
OR (TDATASEG.UD5X IS NULL OR TDATASEG.UD5X = '')
)
AND LOADID = 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31'
AND VALID_FLAG = 'Y'
AND CALCACCTTYPE > 0
2020-02-19 12:48:37,765 DEBUG [AIF]: CommData.updateWorkflow - START
2020-02-19 12:48:37,765 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=11,PROCESSVAL=1,BLNVALDIRTY=0
,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_OK_TXT'
WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17
2020-02-19 12:48:37,766 DEBUG [AIF]: CommData.updateWorkflow - END
2020-02-19 12:48:37,766 INFO [AIF]: Total Data Rows available for Export to Target: 56
2020-02-19 12:48:37,766 DEBUG [AIF]: CommMap.validateData - END
2020-02-19 12:48:37,767 INFO [AIF]:
Validate Data Members for Period 'Dec-19'
2020-02-19 12:48:37,767 DEBUG [AIF]:
SELECT COUNT(*) ROW_COUNT
FROM TDATASEG
WHERE LOADID = 395
AND (PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31' AND RULE_ID = 17 AND VALID_FLAG = 'Y')
2020-02-19 12:48:37,767 INFO [AIF]: Total Data Rows available for Export to Target: 56
2020-02-19 12:48:37,767 DEBUG [AIF]: CommData.validateData - END
2020-02-19 12:48:37,785 INFO [AIF]: -------END VALIDATE STEP-------
2020-02-19 12:48:37,832 INFO [AIF]: -------START EXPORT STEP-------
2020-02-19 12:48:37,851 DEBUG [AIF]: CommData.exportData - START
2020-02-19 12:48:37,852 DEBUG [AIF]: CommData.updateWorkflow - START
2020-02-19 12:48:37,852 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 = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2020-02-19 12:48:37,853 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=20,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0
,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL
WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17
2020-02-19 12:48:37,854 DEBUG [AIF]: CommData.updateWorkflow - END
2020-02-19 12:48:37,855 DEBUG [AIF]:
UPDATE TDATASEG
SET LOADID = 395
WHERE PARTITIONKEY = 42
AND PERIODKEY = '2019-12-31'
AND CATKEY = 1
AND RULE_ID = 17
AND LOADID < 395
2020-02-19 12:48:37,855 DEBUG [AIF]: Number of Rows updated on TDATASEG: 0
2020-02-19 12:48:37,855 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START
2020-02-19 12:48:37,855 DEBUG [AIF]:
DELETE FROM TDATASEG
WHERE LOADID = 395
AND (
PARTITIONKEY = 42
AND CATKEY = 1
AND PERIODKEY = '2019-12-31'
AND RULE_ID = 17
AND VALID_FLAG = 'N'
)
2020-02-19 12:48:37,856 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0
2020-02-19 12:48:37,856 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END
2020-02-19 12:48:37,856 DEBUG [AIF]: AIFUtil.callOdiServlet - START
2020-02-19 12:48:37,870 INFO [AIF]: EssbaseService.exportData - START
2020-02-19 12:48:37,902 DEBUG [AIF]: appId:7, appType:HPL, mcFlag:false, workflowMode:FULL, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:true, isJournalLoad:false
2020-02-19 12:48:37,903 DEBUG [AIF]: LOAD_METHOD:HPL, LOAD_TYPE:Data, EXPORT_MODE:Merge, CREATE_DRILL_REGION:true, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000
2020-02-19 12:48:37,989 INFO [AIF]: cloudServiceType: FCCS, Resolved user: [email protected], planningUserName: [email protected]
2020-02-19 12:48:38,041 DEBUG [AIF]: Overrode info.loadMethod for the admin user: OLU
2020-02-19 12:48:38,043 DEBUG [AIF]: No need to connect to Essbase server.
2020-02-19 12:48:38,046 DEBUG [AIF]: enableZeroLoad: 1
2020-02-19 12:48:38,046 DEBUG [AIF]: SELECT '"'||ACCOUNT||'"', '"'||ENTITY||','||ICP||','||UD2||','||UD3||','||UD4||','||UD5||','||DATAVALUE||','||
CASE DATAVIEW WHEN 'YTD' THEN 'FCCS_YTD_Input' WHEN 'Periodic' THEN 'FCCS_Periodic' ELSE DATAVIEW END||','||SCENARIO||','||YEAR||','||PERIOD||','||
CASE WHEN (DATAVALUE = 'FCCS_Entity Input') THEN 'Entity Currency' ELSE CURRENCY END||'"', 'Consol',AMOUNT
FROM AIF_HS_BALANCES
WHERE LOADID = 395
2020-02-19 12:48:38,048 INFO [AIF]: Creating data file: RL_CONS_395.dat
2020-02-19 12:48:38,074 INFO [AIF]: Data file creation completed: 14
2020-02-19 12:48:38,074 INFO [AIF]: EssbaseService.exportData - END (true)
2020-02-19 12:48:38,079 DEBUG [AIF]: AIFUtil.callOdiServlet - END
2020-02-19 12:48:38,079 DEBUG [AIF]: CommData.updateWorkflow - START
2020-02-19 12:48:38,079 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=21,PROCESSEXP=1
,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_OK_TXT'
WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17
2020-02-19 12:48:38,081 DEBUG [AIF]: CommData.updateWorkflow - END
2020-02-19 12:48:38,081 DEBUG [AIF]: CommData.exportData - END
2020-02-19 12:48:38,150 DEBUG [AIF]: CommData.loadData - START
2020-02-19 12:48:38,151 DEBUG [AIF]: CommData.updateWorkflow - START
2020-02-19 12:48:38,151 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 = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2020-02-19 12:48:38,152 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=30,PROCESSENTLOAD=0,PROCESSENTVAL=0
,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL
WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17
2020-02-19 12:48:38,154 DEBUG [AIF]: CommData.updateWorkflow - END
2020-02-19 12:48:38,154 DEBUG [AIF]: AIFUtil.callOdiServlet - START
2020-02-19 12:48:38,166 INFO [AIF]: EssbaseService.loadData - START
2020-02-19 12:48:38,194 DEBUG [AIF]: appId:7, appType:HPL, mcFlag:false, workflowMode:FULL, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:true, isJournalLoad:false
2020-02-19 12:48:38,194 DEBUG [AIF]: LOAD_METHOD:HPL, LOAD_TYPE:Data, EXPORT_MODE:Merge, CREATE_DRILL_REGION:true, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000
2020-02-19 12:48:38,270 INFO [AIF]: cloudServiceType: FCCS, Resolved user: [email protected], planningUserName: [email protected]
2020-02-19 12:48:38,319 DEBUG [AIF]: Overrode info.loadMethod for the admin user: OLU
2020-02-19 12:48:38,319 DEBUG [AIF]: No need to connect to Essbase server.
2020-02-19 12:48:39,191 DEBUG [AIF]: CommHpl - performLoadOluFile - START
2020-02-19 12:48:39,195 DEBUG [AIF]: targetApplicationName: RL_CONS
2020-02-19 12:48:39,195 DEBUG [AIF]: metadataLoadMethod: CLASSIC_VIA_EPMI
2020-02-19 12:48:39,196 DEBUG [AIF]: dataFileName: RL_CONS_395.dat
2020-02-19 12:48:39,196 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 395 and parameter_name = 'EXPORT_FILE_DELIMITER'
2020-02-19 12:48:39,197 DEBUG [AIF]: fileDelimiter: comma
2020-02-19 12:48:39,197 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 395 and parameter_name = 'DATE_FORMAT'
2020-02-19 12:48:39,197 DEBUG [AIF]: dateFormat: MM-DD-YYYY
2020-02-19 12:48:39,198 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 395 and parameter_name = 'LOAD_METHOD'
2020-02-19 12:48:39,198 DEBUG [AIF]: Data Load: exportMode=Merge, loadMethod=HPL
[Wed Feb 19 12:48:39 UTC 2020]Batch Mode (/B) turned off (/-B) for strict data loads or save of metadata specified as false (/-IMD).
[Wed Feb 19 12:48:39 UTC 2020]Saving metadata on data loads (/IMD)
Property file arguments: /DF:MM-DD-YYYY /DL:comma /I:***RL_CONS_395.dat /TR
No arguments were derived from the command line.Submitted (merged) command line:
/DF:MM-DD-YYYY /DL:comma /I:***RL_CONS_395.dat /TR
[Wed Feb 19 12:48:39 UTC 2020]Successfully located and opened input file.
[Wed Feb 19 12:48:39 UTC 2020]Input file being read with UTF-8 encoding.
[Wed Feb 19 12:48:39 UTC 2020]Date format pattern "MM-DD-YYYY" specified for date data type loading.
[Wed Feb 19 12:48:39 UTC 2020]Header record fields: Driver Member, Point-of-View, Data Load Cube Name, Value
[Wed Feb 19 12:48:39 UTC 2020]Located and using "OFADataLoadDimension" dimension for loading data in "RL_CONS" application.
[Wed Feb 19 12:48:39 UTC 2020]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.
[Wed Feb 19 12:48:39 UTC 2020]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.
[Wed Feb 19 12:48:39 UTC 2020]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: M/d/yy, sessionId: 357530019
[Wed Feb 19 12:48:39 UTC 2020]Unable to obtain dimension information and/or perform a data load: com.hyperion.planning.HspCallbackInvocationException: Business rule failed to execute. See the job console page for error details.
Outline data store load process finished. 14 data records were read, 15 data records were processed, 15 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.
[Wed Feb 19 12:48:39 UTC 2020]Outline data store load process finished. 14 data records were read, 15 data records were processed, 15 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.
2020-02-19 12:48:39,314 DEBUG [AIF]: loadStatus.errorsWereLogged: True, loadStatus.warningsWereLogged: True
2020-02-19 12:48:39,425 DEBUG [AIF]: Session ID: 369501, Status: ERROR, Status Message: Session Failed :369501 : ODI-1217: Session COMM_EXECUTE_GENERIC_PROCESS (369501) fails with return code 7000.
ODI-1226: Step Execute Data Load - OLU fails after 1 attempt(s).
ODI-1232: Procedure COMM Execute Data Load - OLU execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 8, in <module>
File "<string>", line 255, in performLoadOluFile
RuntimeError: CommHpl - performLoadOluFile did not complete successfully
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)
at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:564)
at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(
Best Answer
-
From the log:
"Business rule failed to execute. See the job console page for error details."
Check jobs in the FCCS application for more details on the business rule failure.
Cheers
John
Answers
-
From the log:
"Business rule failed to execute. See the job console page for error details."
Check jobs in the FCCS application for more details on the business rule failure.
Cheers
John
-
Thank you John, @JohnGoodwin
It said you cannot load data to parent member in entity dimension, but need to load data to holding company so it should be parent to put the ownership percentage
any advise ?