Upon launch of the data load rule, I'm getting the following error in the Process Detail Log.
2019-01-05 15:07:58,738 INFO [AIF]: Data Rows Marked as Invalid: 1
2019-01-05 15:07:58,738 ERROR [AIF]: Error: Data rows with unmapped dimensions exist for Period 'Nov-18'
Here is the Profile setup in ARCS...
Here is the Period setup in ARCS...
Here is the setup of Data Management...
Full Log:
2019-01-05 15:07:54,896 INFO [AIF]: FDMEE Process: 26, Log Level: 5
2019-01-05 15:07:54,896 INFO [AIF]: Location : ARCS (Partitionkey:2)
2019-01-05 15:07:54,897 INFO [AIF]: Period Name : Nov-18 (Period Key:11/30/18 12:00 AM)
2019-01-05 15:07:54,897 INFO [AIF]: Category Name: Entered (Category key:1)
2019-01-05 15:07:54,897 INFO [AIF]: Rule Name : ARCS Data Load (Rule ID:2)
2019-01-05 15:07:56,790 INFO [AIF]: FDM Version: 11.1.2.4.230
2019-01-05 15:07:56,790 INFO [AIF]: Log File Encoding: UTF-8
2019-01-05 15:07:57,842 INFO [AIF]: -------START IMPORT STEP-------
2019-01-05 15:07:57,987 DEBUG [AIF]: FileData.extractDataFromSource - START
2019-01-05 15:07:57,988 DEBUG [AIF]: CommData.getRuleInfo - START
2019-01-05 15:07:57,990 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 = 2
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 adim.TARGET\_DIMENSION\_CLASS\_NAME \<> 'ICPTRANS'
ORDER BY adim.BALANCE\_COLUMN\_NAME
2019-01-05 15:07:57,991 DEBUG [AIF]: {'PLAN_NUMBER': 0L, 'EXPORT_TO_TARGET_FLAG': u'N', 'SRC_TARGET_APP_NAME': 'NA', 'JOURNAL_FLAG': None, 'DIMNAME_MAP': {u'UD1': {'DIMNAME': u'UD1', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'ACCOUNT': {'DIMNAME': u'ACCOUNT', 'TARGET_DIMENSION_CLASS_NAME': u'Account'}}, 'CATKEY': 1L, 'TGT_APP_SUB_TYPE': None, 'TGT_APP_ID': 2L, 'DIMNAME_LIST': [u'ACCOUNT', u'UD1'], 'SRC_SOURCE_SYSTEM_ID': 1L, 'TGT_SOURCE_SYSTEM_TYPE': None, 'TGT_APP_TYPE': u'ARM', 'CALENDAR_ID': None, 'TGT_TARGET_APP_NAME': u'Account Reconciliation Manager', 'PARTITIONKEY': 2L, '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://us6pbcsr1002197.usdc6.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'hypadmin', 'CHECK_FLAG': u'N', 'RULE_ID': 2L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SRC_APP_ID': None, 'INCLUDE_ZERO_BALANCE_FLAG': None, 'IMPGROUPKEY': u'ARCS File', 'TGT_SOURCE_SYSTEM_ID': 0L, 'SRC_APP_TYPE': 'NA', 'TGT_APP_NAME': u'Account Reconciliation Manager', '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': None, 'TGT_METADATA_LOAD_METHOD': u'NA'}
2019-01-05 15:07:57,992 DEBUG [AIF]: {u'Source Type': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Currency Bucket': {'BCN': None, 'DCN': u'Scenario'}, u'Profile': {'BCN': u'ACCOUNT', 'DCN': u'Account'}}
2019-01-05 15:07:57,993 DEBUG [AIF]: {u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}}
2019-01-05 15:07:57,993 DEBUG [AIF]: CommData.getRuleInfo - END
2019-01-05 15:07:57,994 DEBUG [AIF]: FileData.extractDataFromSource - END
2019-01-05 15:07:58,014 DEBUG [AIF]: FileData.preProcessDataFile - START
2019-01-05 15:07:58,092 DEBUG [AIF]: FileData.preProcessDataFile - END
2019-01-05 15:07:58,115 DEBUG [AIF]: CommData.preImportData - START
2019-01-05 15:07:58,115 DEBUG [AIF]: CommData.insertFilePeriods - START
2019-01-05 15:07:58,117 DEBUG [AIF]: doAppPeriodMappingsExist - Account Reconciliation Manager: Y
2019-01-05 15:07:58,117 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 26 AND PARAMETER_TYPE = 'SOURCE_PERIODS'
2019-01-05 15:07:58,118 DEBUG [AIF]: Period mapping section: SINGLE-COLUMN/DEFAULT
2019-01-05 15:07:58,120 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 TPOVPERIODADAPTOR\_FLAT\_V pp
ON pp.PERIODFREQ = pc.CATFREQ AND pp.INTSYSTEMKEY = 'Account Reconciliation Manager' AND pp.PERIODKEY >= brl.START\_PERIODKEY AND pp.PERIODKEY \<= brl.END\_PERIODKEY
WHERE brl.LOADID = 26
ORDER BY PERIODKEY
2019-01-05 15:07:58,121 INFO [AIF]: File Name: ARCS_Test_File.txt
2019-01-05 15:07:58,122 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 (26,'2018-11-30','N',0,'0' ,'0',0,1,'2018','November 2018', 'PROCESS\_BAL\_IMP\_FILE','ARCS\_Test\_File.txt','PROCESS\_BAL\_TRANS','Nov-18','N', 0)
2019-01-05 15:07:58,123 DEBUG [AIF]: insertRowCount: 1
2019-01-05 15:07:58,124 DEBUG [AIF]: CommData.insertFilePeriods - END
2019-01-05 15:07:58,124 DEBUG [AIF]: CommData.getPovList - START
2019-01-05 15:07:58,124 DEBUG [AIF]:
SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY
,COALESCE(pp.PERIODDESC, TO\_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC
,brl.RULE\_ID, br.RULE\_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK\_FLAG
FROM AIF\_BAL\_RULE\_LOADS brl
INNER JOIN AIF\_BALANCE\_RULES br
ON br.RULE\_ID = brl.RULE\_ID
INNER JOIN TPOVPARTITION part
ON part.PARTITIONKEY = brl.PARTITIONKEY
INNER JOIN TPOVCATEGORY cat
ON cat.CATKEY = brl.CATKEY
INNER JOIN AIF\_PROCESS\_PERIODS pprd
ON pprd.PROCESS\_ID = brl.LOADID
LEFT OUTER JOIN TPOVPERIODADAPTOR pp
ON pp.PERIODKEY = pprd.PERIODKEY AND pp.INTSYSTEMKEY = 'Account Reconciliation Manager'
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 = 26
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE\_ID
2019-01-05 15:07:58,126 DEBUG [AIF]: CommData.getPovList - END
2019-01-05 15:07:58,126 DEBUG [AIF]: CommData.preImportData - END
2019-01-05 15:07:58,148 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2019-01-05 15:07:58,148 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, 'hypadmin' 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 = 26
) q
ORDER BY ENTITY\_NAME\_ORDER
2019-01-05 15:07:58,151 DEBUG [AIF]: Comm.doScriptInit - START
2019-01-05 15:07:58,209 DEBUG [AIF]: fdmContext: {PERIODKEY=2018-11-30, CATKEY=1, APPNAME=Account Reconciliation Manager, EXPORTFLAG=N, SOURCEID=1, TARGETAPPNAME=Account Reconciliation Manager, USERLOCALE=en, IMPORTFLAG=Y, SCRIPTSDIR=/u03/inbox/data/scripts, SOURCENAME=File, PERIODNAME=Nov-18, BATCHSCRIPTDIR=/u02/user_projects/instance0/FinancialDataQuality, LOCNAME=ARCS, USERNAME=hypadmin, FILENAME=ARCS_Test_File.txt, APPROOTDIR=/u03/inbox, EPMORACLEHOME=/u02/Oracle/Middleware/EPMSystem11R1, TARGETAPPTYPE=ARM, OUTBOXDIR=/u03/inbox/outbox, TARGETAPPDB=null, FILEDIR=null, APPID=2, MULTIPERIODLOAD=N, LOADID=26, RULEID=2, IMPORTMODE=REPLACE, SOURCETYPE=FILE, CATNAME=Entered, RULENAME=ARCS Data Load, LOCKEY=2, EXPORTMODE=null, INBOXDIR=/u03/inbox/inbox, EPMORACLEINSTANCEHOME=/u02/user_projects/instance0, IMPORTFORMAT=ARCS File}
2019-01-05 15:07:58,212 DEBUG [AIF]: The executeEventScript is set to: NO
2019-01-05 15:07:58,212 DEBUG [AIF]: The AppRootFolder is set to: /u03/inbox
2019-01-05 15:07:58,212 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2019-01-05 15:07:58,212 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE
2019-01-05 15:07:58,212 DEBUG [AIF]: Comm.doScriptInit - END
2019-01-05 15:07:58,212 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2019-01-05 15:07:58,236 DEBUG [AIF]: FileData.importData - START
2019-01-05 15:07:58,237 DEBUG [AIF]: Importing data for load id: 26
2019-01-05 15:07:58,237 DEBUG [AIF]:
SELECT a.partitionkey, a.catkey, a.start\_periodkey, b.perioddesc, coalesce(a.journal\_flag,'N') JOURNAL\_FLAG, c.last\_updated\_by,
coalesce(a.FILE\_NAME\_STATIC,'') FILE\_NAME\_STATIC, a.FILE\_PATH, a.RULE\_ID, a.application\_id
FROM aif\_bal\_rule\_loads a,
aif\_balance\_rules br,
tpovperiodadaptor b,
aif\_processes c
WHERE a.loadid = 26
AND a.start\_periodkey=b.periodkey
AND a.loadid =c.process\_id
AND br.rule\_id = a.rule\_id
AND b.INTSYSTEMKEY = 'Account Reconciliation Manager'
2019-01-05 15:07:58,239 DEBUG [AIF]: FileData.py: Importing Text data for load id: 26
2019-01-05 15:07:58,345 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::26;2:1:2:[NONE]:/u03/inbox/:DELIMITED
2019-01-05 15:07:58,352 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2019-01-05 15:07:58,352 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2019-01-05 15:07:58,352 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
2019-01-05 15:07:58,414 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=3:SourceClName=null:ImpFldTargetExp=null
2019-01-05 15:07:58,414 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=null:ImpFldTargetExp=null
2019-01-05 15:07:58,415 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2019-01-05 15:07:58,415 INFO [AIF]: EPMFDM-140274:Message - File Name ARCS_Test_File.txt
periodKey2018-11-30
2019-01-05 15:07:58,442 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 26
PARTITIONKEY: 2
IMPORT GROUP: ARCS File
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: ARCS_Test_File.txt
PROCESSING CODES:
-----------------------------------------------------------------------------------
BLANK............. Line is blank or empty.
NN................ Non-Numeric, Amount field contains non numeric characters.
TC................ Type Conversion, Amount field could not be converted to a number.
ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.
SKIP FIELD.............. SKIP field value was found
NULL ACCOUNT VALUE.............. Account Field is null
SKIP FROM SCRIPT.............. Skipped through Script
HEADER ROW.............. Header Row
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.
Rows Loaded: 1
Rows Rejected: 0
2019-01-05 15:07:58,442 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start
2019-01-05 15:07:58,443 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy
2019-01-05 15:07:58,443 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:
2019-01-05 15:07:58,443 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 2620181130
2019-01-05 15:07:58,443 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: ARCS_Test_File
Extension: txt
2019-01-05 15:07:58,444 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 2620181130.txt
2019-01-05 15:07:58,445 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: ARCS_Test_File.txt
2019-01-05 15:07:58,445 INFO [AIF]: EPMFDM-140274:Message - File not deleted: /u03/inbox/ARCS_Test_File.txt
2019-01-05 15:07:58,448 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:ARCS_Test_File-hypadmin-20190105_150758-1
2019-01-05 15:07:58,451 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End
2019-01-05 15:07:58,454 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End
2019-01-05 15:07:58,454 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 102
2019-01-05 15:07:58,458 DEBUG [AIF]: FileData.importData - END
2019-01-05 15:07:58,528 DEBUG [AIF]: CommData.postImportData - START
2019-01-05 15:07:58,528 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2019-01-05 15:07:58,528 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 = 26
AND en.process\_id = pp.process\_id
AND pp.IMP\_ENTITY\_NAME = en.file\_entity\_name
order by en.entity\_name\_order
2019-01-05 15:07:58,529 INFO [AIF]:
Import Data from Source for Period 'Nov-18'
2019-01-05 15:07:58,529 DEBUG [AIF]: CommData.updateWorkflow - START
2019-01-05 15:07:58,529 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 = '2018-11-30' AND tlp.RULE\_ID = 2 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2019-01-05 15:07:58,531 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='2018-11-30' AND RULE\_ID=2
2019-01-05 15:07:58,533 DEBUG [AIF]: CommData.updateWorkflow - END
2019-01-05 15:07:58,533 DEBUG [AIF]: CommData.updateTDATASEG_T - END
2019-01-05 15:07:58,533 DEBUG [AIF]: CommData.postImportData - END
2019-01-05 15:07:58,553 DEBUG [AIF]: LogicGroup.createLogicAccounts - START
2019-01-05 15:07:58,553 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START
2019-01-05 15:07:58,553 DEBUG [AIF]:
select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE
from AIF\_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp
where prs.PROCESS\_ID=26 and prs.PARTITIONKEY=part.PARTITIONKEY
and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY
2019-01-05 15:07:58,554 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END
2019-01-05 15:07:58,555 DEBUG [AIF]: LogicGroup.createLogicAccounts - END
2019-01-05 15:07:58,576 DEBUG [AIF]: CommData.mapData - START
2019-01-05 15:07:58,576 DEBUG [AIF]: CommData.insertTransProcessDetails - START
2019-01-05 15:07:58,576 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, 'hypadmin' 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 = 26
AND PRIOR\_PERIOD\_FLAG = 'N'
GROUP BY PROCESS\_ID, TRANS\_ENTITY\_TYPE, TRANS\_ENTITY\_NAME
) q
ORDER BY ENTITY\_NAME\_ORDER
2019-01-05 15:07:58,578 DEBUG [AIF]: CommData.insertTransProcessDetails - END
2019-01-05 15:07:58,578 DEBUG [AIF]:
DELETE FROM TDATAMAP\_T
WHERE LOADID \< 26
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 2 AND p.PROCESS\_ID = TDATAMAP\_T.LOADID )
2019-01-05 15:07:58,580 DEBUG [AIF]:
SELECT COUNT(\*) FROM TDATASEG\_T
WHERE LOADID \< 26
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 2 AND p.PROCESS\_ID = TDATASEG\_T.LOADID )
2019-01-05 15:07:58,580 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False
2019-01-05 15:07:58,582 INFO [AIF]: Executing delete statement:
2019-01-05 15:07:58,582 DEBUG [AIF]:
DELETE FROM TDATASEG\_T
WHERE LOADID \< 26
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 2 AND p.PROCESS\_ID = TDATASEG\_T.LOADID )
2019-01-05 15:07:58,584 INFO [AIF]: Successfully executed delete statement
2019-01-05 15:07:58,584 DEBUG [AIF]:
DELETE FROM AIF\_PROCESS\_PERIODS
WHERE PROCESS\_ID \< 26
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 2 AND p.PROCESS\_ID = AIF\_PROCESS\_PERIODS.PROCESS\_ID )
2019-01-05 15:07:58,587 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START
2019-01-05 15:07:58,587 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START
2019-01-05 15:07:58,587 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
2019-01-05 15:07:58,588 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END
2019-01-05 15:07:58,588 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 26, 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
WHERE PARTITIONKEY = 2
AND ( RULE\_ID IS NULL OR RULE\_ID = 2 )
2019-01-05 15:07:58,589 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 1
2019-01-05 15:07:58,590 DEBUG [AIF]: CommMap.loadTDATAMAP_T - END
2019-01-05 15:07:58,590 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START
2019-01-05 15:07:58,590 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 = 26
AND atad.APPLICATION\_ID = 2
AND tdm.PARTITIONKEY = 2
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE\_ID IS NULL OR tdm.RULE\_ID = 2)
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 = 26
AND atad.APPLICATION\_ID = 2
AND tdm.PARTITIONKEY = 2
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE\_ID IS NULL OR tdm.RULE\_ID = 2)
AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')
) q
ORDER BY CALC\_SEQ, DIMNAME, SEQUENCE, RULE\_ID, SYSTEM\_GENERATED\_FLAG, SRCKEY
2019-01-05 15:07:58,592 INFO [AIF]:
Map Data for Period 'Nov-18'
2019-01-05 15:07:58,592 DEBUG [AIF]: Comm.updateProcessDetail - START
2019-01-05 15:07:58,592 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 ('hypadmin' IS NULL) THEN LAST\_UPDATED\_BY ELSE 'hypadmin' END
,LAST\_UPDATE\_DATE = CURRENT\_TIMESTAMP
WHERE PROCESS\_ID = 26 AND ENTITY\_TYPE = 'PROCESS\_BAL\_TRANS' AND ENTITY\_NAME = 'Nov-18'
2019-01-05 15:07:58,594 DEBUG [AIF]: Comm.updateProcessDetail - END
2019-01-05 15:07:58,594 DEBUG [AIF]:
SELECT COUNT(\*) ROW\_COUNT
FROM TDATASEG\_T
WHERE LOADID = 26
AND (PARTITIONKEY = 2 AND CATKEY = 1 AND PERIODKEY = '2018-11-30' AND RULE\_ID = 2 AND VALID\_FLAG = 'Y')
2019-01-05 15:07:58,595 INFO [AIF]:
Processing Mappings for Column 'ACCOUNT'
2019-01-05 15:07:58,596 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET ACCOUNTX = ACCOUNT
,ACCOUNTR = 1
,ACCOUNTF = 3
WHERE LOADID = 26
AND PARTITIONKEY = 2
AND CATKEY = 1
AND (ACCOUNTX IS NULL OR ACCOUNTX = '')
AND (1=1)
AND PERIODKEY = '2018-11-30'
2019-01-05 15:07:58,597 INFO [AIF]: Data Rows Updated by Location Mapping 'All' (LIKE): 1
2019-01-05 15:07:58,598 DEBUG [AIF]: Comm.updateProcessDetail - START
2019-01-05 15:07:58,598 DEBUG [AIF]:
UPDATE AIF\_PROCESS\_DETAILS
SET STATUS = 'SUCCESS'
,RECORDS\_PROCESSED = CASE WHEN RECORDS\_PROCESSED IS NULL THEN 0 ELSE RECORDS\_PROCESSED END + 1
,EXECUTION\_END\_TIME = CURRENT\_TIMESTAMP
,LAST\_UPDATED\_BY = CASE WHEN ('hypadmin' IS NULL) THEN LAST\_UPDATED\_BY ELSE 'hypadmin' END
,LAST\_UPDATE\_DATE = CURRENT\_TIMESTAMP
WHERE PROCESS\_ID = 26 AND ENTITY\_TYPE = 'PROCESS\_BAL\_TRANS' AND ENTITY\_NAME = 'Nov-18'
2019-01-05 15:07:58,600 DEBUG [AIF]: Comm.updateProcessDetail - END
2019-01-05 15:07:58,600 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END
2019-01-05 15:07:58,600 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START
2019-01-05 15:07:58,601 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False
2019-01-05 15:07:58,601 INFO [AIF]:
Stage Data for Period 'Nov-18'
2019-01-05 15:07:58,602 DEBUG [AIF]:
DELETE FROM TDATAMAPSEG
WHERE PARTITIONKEY = 2
AND CATKEY = 1
AND PERIODKEY = '2018-11-30'
2019-01-05 15:07:58,603 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 1
2019-01-05 15:07:58,603 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, '2018-11-30', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,
WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM\_GENERATED\_FLAG
FROM TDATAMAP\_T
WHERE LOADID = 26
2019-01-05 15:07:58,604 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 1
2019-01-05 15:07:58,604 DEBUG [AIF]:
DELETE FROM TDATAMAP\_T
WHERE LOADID = 26
2019-01-05 15:07:58,605 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 1
2019-01-05 15:07:58,606 INFO [AIF]: Executing delete statement:
2019-01-05 15:07:58,606 DEBUG [AIF]:
DELETE FROM TDATASEG
WHERE LOADID \< 26 AND PARTITIONKEY = 2 AND CATKEY = 1 AND RULE\_ID = 2 AND PERIODKEY = '2018-11-30'
2019-01-05 15:07:58,638 INFO [AIF]: Successfully executed delete statement
2019-01-05 15:07:58,638 INFO [AIF]: Number of Rows deleted from TDATASEG: 1
2019-01-05 15:07:58,639 DEBUG [AIF]:
DELETE FROM TDATAMEMOITEMS
WHERE PARTITIONKEY = 2 AND PERIODKEY = '2018-11-30' AND CATKEY = 1 AND RULE\_ID = 2
AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)
2019-01-05 15:07:58,640 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0
2019-01-05 15:07:58,640 DEBUG [AIF]:
DELETE FROM TDATAARCHIVE
WHERE PARTITIONKEY = 2 AND PERIODKEY = '2018-11-30' AND CATKEY = 1 AND RULE\_ID = 2 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 )
2019-01-05 15:07:58,641 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0
2019-01-05 15:07:58,642 INFO [AIF]: Executing insert statement:
2019-01-05 15:07:58,643 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 = 26 AND PARTITIONKEY = 2 AND CATKEY = 1 AND PERIODKEY = '2018-11-30'
2019-01-05 15:07:58,645 INFO [AIF]: Successfully executed insert statement
2019-01-05 15:07:58,645 INFO [AIF]: Number of Rows inserted into TDATASEG: 1
2019-01-05 15:07:58,646 INFO [AIF]: Executing delete statement:
2019-01-05 15:07:58,646 DEBUG [AIF]:
DELETE FROM TDATASEG\_T
WHERE LOADID = 26 AND PARTITIONKEY = 2 AND CATKEY = 1 AND PERIODKEY = '2018-11-30'
2019-01-05 15:07:58,648 INFO [AIF]: Successfully executed delete statement
2019-01-05 15:07:58,648 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 1
2019-01-05 15:07:58,649 DEBUG [AIF]: CommData.updateWorkflow - START
2019-01-05 15:07:58,649 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=2 AND CATKEY=1 AND PERIODKEY='2018-11-30' AND RULE\_ID=2
2019-01-05 15:07:58,651 DEBUG [AIF]: CommData.updateWorkflow - END
2019-01-05 15:07:58,651 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END
2019-01-05 15:07:58,651 DEBUG [AIF]: CommData.mapData - END
2019-01-05 15:07:58,675 INFO [AIF]: -------END IMPORT STEP-------
2019-01-05 15:07:58,694 INFO [AIF]: -------START VALIDATE STEP-------
2019-01-05 15:07:58,717 DEBUG [AIF]: CommData.validateData - START
2019-01-05 15:07:58,717 DEBUG [AIF]: CommMap.validateData - START
2019-01-05 15:07:58,718 INFO [AIF]:
Validate Data Mappings for Period 'Nov-18'
2019-01-05 15:07:58,718 DEBUG [AIF]:
SELECT COUNT(\*) ROW\_COUNT
FROM TDATASEG
WHERE LOADID = 26
AND (PARTITIONKEY = 2 AND CATKEY = 1 AND PERIODKEY = '2018-11-30' AND RULE\_ID = 2 AND VALID\_FLAG = 'Y')
2019-01-05 15:07:58,719 DEBUG [AIF]: CommData.updateWorkflow - START
2019-01-05 15:07:58,719 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 = '2018-11-30' AND tlp.RULE\_ID = 2 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2019-01-05 15:07:58,720 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=2 AND CATKEY=1 AND PERIODKEY='2018-11-30' AND RULE\_ID=2
2019-01-05 15:07:58,735 DEBUG [AIF]: CommData.updateWorkflow - END
2019-01-05 15:07:58,735 DEBUG [AIF]:
UPDATE TDATASEG
SET VALID\_FLAG = 'N'
WHERE 1=1
AND ( (1=0)
OR (TDATASEG.ACCOUNTX IS NULL OR TDATASEG.ACCOUNTX = '')
OR (TDATASEG.UD1X IS NULL OR TDATASEG.UD1X = '')
)
AND LOADID = 26 AND PARTITIONKEY = 2 AND CATKEY = 1 AND PERIODKEY = '2018-11-30'
AND VALID\_FLAG = 'Y'
AND CALCACCTTYPE > 0
2019-01-05 15:07:58,738 INFO [AIF]: Data Rows Marked as Invalid: 1
2019-01-05 15:07:58,738 ERROR [AIF]: Error: Data rows with unmapped dimensions exist for Period 'Nov-18'
2019-01-05 15:07:58,738 DEBUG [AIF]: CommData.updateWorkflow - START
2019-01-05 15:07:58,738 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT\_TIMESTAMP
,PROCESSSTATUS=11,PROCESSVAL=1,BLNVALDIRTY=0
,PROCESSVALNOTE='AIF\_WF\_VAL\_VALIDATE\_OK\_TXT'
WHERE PARTITIONKEY=2 AND CATKEY=1 AND PERIODKEY='2018-11-30' AND RULE\_ID=2
2019-01-05 15:07:58,741 DEBUG [AIF]: CommData.updateWorkflow - END
2019-01-05 15:07:58,741 INFO [AIF]: Total Data Rows available for Export to Target: 0
2019-01-05 15:07:58,741 DEBUG [AIF]: CommMap.validateData - END
2019-01-05 15:07:58,741 DEBUG [AIF]: CommData.validateData - END
2019-01-05 15:07:58,762 INFO [AIF]: -------END VALIDATE STEP-------
2019-01-05 15:07:58,905 DEBUG [AIF]: Comm.finalizeProcess - START
2019-01-05 15:07:58,905 DEBUG [AIF]: CommData.updateRuleStatus - START
2019-01-05 15:07:58,905 DEBUG [AIF]:
UPDATE AIF\_BALANCE\_RULES
SET STATUS = CASE 'SUCCESS'
WHEN 'SUCCESS' THEN
CASE ( SELECT COUNT(\*) FROM AIF\_PROCESS\_DETAILS pd WHERE pd.PROCESS\_ID = 26 AND pd.STATUS IN ('FAILED','WARNING') )
WHEN 0 THEN 'SUCCESS'
ELSE ( SELECT MIN(pd.STATUS) FROM AIF\_PROCESS\_DETAILS pd WHERE pd.PROCESS\_ID = 26 AND pd.STATUS IN ('FAILED','WARNING') ) END
ELSE 'SUCCESS' END
WHERE RULE\_ID = 2
2019-01-05 15:07:58,907 DEBUG [AIF]: CommData.updateRuleStatus - END
2019-01-05 15:07:58,907 DEBUG [AIF]: Comm.updateProcess - START
2019-01-05 15:07:58,909 DEBUG [AIF]: Comm.updateProcess - END
2019-01-05 15:07:58,911 DEBUG [AIF]: The fdmAPI connection has been closed.
2019-01-05 15:07:58,911 DEBUG [AIF]: Comm.finalizeProcess - END
2019-01-05 15:07:58,911 INFO [AIF]: FDMEE Process End, Process ID: 26