Hi all,
I have created an Jython import script for amount which is Debit-Credit as below:
def DRCR_AMOUNT(strField, strRecord):
strField=strRecord.split(";")
strAmountDR=strField\[8\].split()
strAmountCR=strField\[9\].split()
if(strAmountDR is None) or (len(strAmountDR)==0):
strResult=0-strAmountCR
else:
strResult=strAmountDR
return strResult
when I put this script in the Import Format this script in the import format:
It keeps telling me that I have error in Mapping:
All the mapping is Like * to *
That is weird because when I take out the script, and just put field number 9 for example, there is no error in mapping..... Any idea why?
And this is the load file:
This is the log file:
2017-02-13 13:35:21,498 INFO [AIF]: FDMEE Process: 80, Log Level: 5, Log File: C:\FDMEE\outbox\logs\VCONSOL_80.log
2017-02-13 13:35:21,498 INFO [AIF]: Location : TEST (Partitionkey:83)
2017-02-13 13:35:21,498 INFO [AIF]: Period Name : Jan-2017 (Period Key:31.01.17 00:00)
2017-02-13 13:35:21,498 INFO [AIF]: Category Name: ACT (Category key:3)
2017-02-13 13:35:21,498 INFO [AIF]: Rule Name : r_dlr_test (Rule ID:25)
2017-02-13 13:35:23,244 INFO [AIF]: FDM Version: 11.1.2.4.210
2017-02-13 13:35:23,244 INFO [AIF]: Log File Encoding: UTF-8
2017-02-13 13:35:25,920 INFO [AIF]: -------START IMPORT STEP-------
2017-02-13 13:35:26,026 DEBUG [AIF]: CommData.preImportData - START
2017-02-13 13:35:26,036 DEBUG [AIF]: CommData.getRuleInfo - START
2017-02-13 13:35:26,045 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 = 3
LEFT OUTER JOIN TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE\_COLUMN\_NAME AND tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 83
AND adim.BALANCE\_COLUMN\_NAME IS NOT NULL
AND adim.TARGET\_DIMENSION\_CLASS\_NAME \<> 'ICPTRANS'
ORDER BY adim.BALANCE\_COLUMN\_NAME
2017-02-13 13:35:26,049 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'r_dlr_test', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, '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'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'Test', 'EXPORT_TO_TARGET_FLAG': u'N', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 83L, 'IMPGROUPFILETYPE': u'DELIMITED', 'RULE_ID': 25L, 'SOURCE_ADAPTER_FLAG': u'N', 'CALENDAR_ID': None, 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}
2017-02-13 13:35:26,054 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}
2017-02-13 13:35:26,055 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}
2017-02-13 13:35:26,055 DEBUG [AIF]: CommData.getRuleInfo - END
2017-02-13 13:35:26,061 DEBUG [AIF]: CommData.insertFilePeriods - START
2017-02-13 13:35:26,066 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N
2017-02-13 13:35:26,066 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 80 AND PARAMETER_TYPE = 'SOURCE_PERIODS'
2017-02-13 13:35:26,068 DEBUG [AIF]: Period mapping section: SINGLE-COLUMN
2017-02-13 13:35:26,068 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 = 80
ORDER BY PERIODKEY
2017-02-13 13:35:26,078 INFO [AIF]: File Name: ImportFormatTemplate17_5.csv
2017-02-13 13:35:26,079 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 (80,'2017-01-31','N',0,'0' ,'0',0,1,'2017','Jan', 'PROCESS\_BAL\_IMP\_FILE','ImportFormatTemplate17\_5.csv','PROCESS\_BAL\_TRANS','Jan-2017','N', 0)
2017-02-13 13:35:26,081 DEBUG [AIF]: CommData.insertFilePeriods - END
2017-02-13 13:35:26,085 DEBUG [AIF]: CommData.getPovList - START
2017-02-13 13:35:26,085 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 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 = 80
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE\_ID
2017-02-13 13:35:26,091 DEBUG [AIF]: CommData.getPovList - END
2017-02-13 13:35:26,093 DEBUG [AIF]: CommData.insertImportProcessDetails - START
2017-02-13 13:35:26,094 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, 'MBUG' 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 = 80
) q
ORDER BY ENTITY\_NAME\_ORDER
2017-02-13 13:35:26,096 DEBUG [AIF]: CommData.insertImportProcessDetails - END
2017-02-13 13:35:26,102 DEBUG [AIF]: Comm.doScriptInit - START
2017-02-13 13:35:26,178 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\FDMEE\inbox, LOCNAME=TEST, SOURCENAME=File, APPID=3, SOURCEID=1, APPROOTDIR=C:\FDMEE, IMPORTFORMAT=Test, SCRIPTSDIR=C:\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=25, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=80, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate17_5.csv, LOCKEY=83, RULENAME=r_dlr_test, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=MBUG, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}
2017-02-13 13:35:26,185 DEBUG [AIF]: The executeEventScript is set to: YES
2017-02-13 13:35:26,185 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE
2017-02-13 13:35:26,185 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2017-02-13 13:35:26,185 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2017-02-13 13:35:26,185 DEBUG [AIF]: Comm.doScriptInit - END
2017-02-13 13:35:26,185 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:26,186 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefImport.py
2017-02-13 13:35:26,190 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:26,190 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp
2017-02-13 13:35:26,190 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefImport.vbs
2017-02-13 13:35:26,190 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:26,190 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:26,190 DEBUG [AIF]: CommData.preImportData - END
2017-02-13 13:35:30,593 DEBUG [AIF]: FileData.importData - START
2017-02-13 13:35:30,593 DEBUG [AIF]: Importing data for load id: 80
2017-02-13 13:35:30,603 DEBUG [AIF]: CommData.getRuleInfo - START
2017-02-13 13:35:30,611 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 = 3
LEFT OUTER JOIN TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE\_COLUMN\_NAME AND tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 83
AND adim.BALANCE\_COLUMN\_NAME IS NOT NULL
AND adim.TARGET\_DIMENSION\_CLASS\_NAME \<> 'ICPTRANS'
ORDER BY adim.BALANCE\_COLUMN\_NAME
2017-02-13 13:35:30,616 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'r_dlr_test', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, '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'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'Test', 'EXPORT_TO_TARGET_FLAG': u'N', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 83L, 'IMPGROUPFILETYPE': u'DELIMITED', 'RULE_ID': 25L, 'SOURCE_ADAPTER_FLAG': u'N', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}
2017-02-13 13:35:30,620 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}
2017-02-13 13:35:30,623 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}
2017-02-13 13:35:30,623 DEBUG [AIF]: CommData.getRuleInfo - END
2017-02-13 13:35:30,625 DEBUG [AIF]: doAppPeriodMappingsExist - VCONSOL: N
2017-02-13 13:35:30,625 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,
tpovperiod b,
aif\_processes c
WHERE a.loadid = 80
AND a.start\_periodkey=b.periodkey
AND a.loadid =c.process\_id
AND br.rule\_id = a.rule\_id
2017-02-13 13:35:30,629 DEBUG [AIF]: FileData.py: Importing Text data for load id: 80
2017-02-13 13:35:30,648 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::80;83:3:25:[NONE]:C:\FDMEE/:DELIMITED
2017-02-13 13:35:30,653 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2017-02-13 13:35:30,653 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2017-02-13 13:35:30,654 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
2017-02-13 13:35:30,694 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=Script=DRCR_AMOUNT.py;NZP:StartPos=9:SourceClName=null
2017-02-13 13:35:30,694 INFO [AIF]: EPMFDM-140274:Message - Instantiating JythonInterpreter
2017-02-13 13:35:30,800 DEBUG [AIF]: EPMFDM-140274:Message - Passing script file for execution to jython interpretor: C:\FDMEE/data/scripts/import/DRCR_AMOUNT.py
2017-02-13 13:35:30,801 INFO [AIF]: Execute File: C:\FDMEE/data/scripts/import/DRCR_AMOUNT.py
2017-02-13 13:35:30,801 DEBUG [AIF]: LOG_LEVEL: 4
2017-02-13 13:35:30,802 DEBUG [AIF]: Script File encoding: UTF-8
2017-02-13 13:35:30,802 DEBUG [AIF]: def DRCR_AMOUNT(strField, strRecord):
strField=strRecord.split(";")
strAmountDR=strField\[8\].split()
strAmountCR=strField\[9\].split()
if(strAmountDR is None) or (len(strAmountDR)==0):
strResult=0-strAmountCR
else:
strResult=strAmountDR
return strResult
2017-02-13 13:35:30,811 DEBUG [AIF]: EPMFDM-140274:Message - compiling script:DRCR_AMOUNT(strField,strRecord)
2017-02-13 13:35:30,812 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=4:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=7:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=3:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=5:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=6:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=8:SourceClName=null
2017-02-13 13:35:30,813 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=11:SourceClName=null
2017-02-13 13:35:30,813 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2017-02-13 13:35:30,814 INFO [AIF]: EPMFDM-140274:Message - File Name ImportFormatTemplate17_5.csv
periodKey2017-01-31
2017-02-13 13:35:30,815 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 80
PARTITIONKEY: 83
IMPORT GROUP: Test
FILE TYPE: DELIMITED
DELIMITER: ;
SOURCE FILE: ImportFormatTemplate17_5.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] Entity;Account;ICP;Custom1;Custom2;Custom3;Custom4;Custom5;Debit;Credit;Custom1Add
[TC] - [Amount=NN] 130001;FTE;[ICP None];;[None];[None];[None];[None];40;2;CD2_Serv3
Rows Loaded: 0
Rows Rejected: 2
2017-02-13 13:35:30,816 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: null
2017-02-13 13:35:30,816 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:
2017-02-13 13:35:30,816 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 8020170131
2017-02-13 13:35:30,817 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: ImportFormatTemplate17_5
Extension: csv
2017-02-13 13:35:30,817 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 8020170131.csv
2017-02-13 13:35:30,818 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: ImportFormatTemplate17_5.csv
2017-02-13 13:35:30,818 INFO [AIF]: EPMFDM-140274:Message - File not deleted: C:\FDMEE\ImportFormatTemplate17_5.csv
2017-02-13 13:35:30,826 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End
2017-02-13 13:35:30,826 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 173
2017-02-13 13:35:30,826 INFO [AIF]: EPMFDM-140274:Message - Releasing JythonInterpreter
2017-02-13 13:35:30,826 DEBUG [AIF]: FileData.importData - END
2017-02-13 13:35:30,899 DEBUG [AIF]: CommData.postImportData - START
2017-02-13 13:35:30,899 DEBUG [AIF]: CommData.getRuleInfo - START
2017-02-13 13:35:30,902 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 = 3
LEFT OUTER JOIN TBHVIMPITEMERPI tiie
ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE\_COLUMN\_NAME AND tiie.IMPMAPTYPE = 'ERP'
WHERE tpp.PARTITIONKEY = 83
AND adim.BALANCE\_COLUMN\_NAME IS NOT NULL
AND adim.TARGET\_DIMENSION\_CLASS\_NAME \<> 'ICPTRANS'
ORDER BY adim.BALANCE\_COLUMN\_NAME
2017-02-13 13:35:30,906 DEBUG [AIF]: {'APPLICATION_ID': 3L, 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'r_dlr_test', 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 3L, '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'VCONSOL', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 1L, 'KK_FLAG': u'N', 'IMPGROUPKEY': u'Test', 'EXPORT_TO_TARGET_FLAG': u'N', 'TARGET_SOURCE_SYSTEM_TYPE': None, 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': None, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'LAST_UPDATED_BY': u'MBUG', 'DIMNAME_MAP': {u'UD3': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD3'}, u'ICP': {'TARGET_DIMENSION_CLASS_NAME': u'Icp', 'DIMNAME': u'ICP'}, u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD2': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD2'}, u'UD5': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD5'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}, u'UD1': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD1'}}, 'TARGET_APPLICATION_TYPE': u'HFM', 'PARTITIONKEY': 83L, 'IMPGROUPFILETYPE': u'DELIMITED', 'RULE_ID': 25L, 'SOURCE_ADAPTER_FLAG': u'N', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://wvvarz0176bu.t-systems.ch:6550/aif', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'IMPTARGETSOURCESYSTEMID': 0L, 'PS_LEDGER': None}
2017-02-13 13:35:30,909 DEBUG [AIF]: {u'Value': {'BCN': None, 'DCN': u'Value'}, u'ICP': {'BCN': u'ICP', 'DCN': u'Icp'}, u'View': {'BCN': None, 'DCN': u'View'}, u'SameStore': {'BCN': u'UD5', 'DCN': u'Generic'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Nature': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Appendix': {'BCN': u'UD4', 'DCN': u'Generic'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Accountdetails': {'BCN': u'UD1', 'DCN': u'Generic'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Regions': {'BCN': u'UD3', 'DCN': u'Generic'}}
2017-02-13 13:35:30,910 DEBUG [AIF]: {u'UD3': {'IMPFLDSOURCECOLNAME': None}, u'ICP': {'IMPFLDSOURCECOLNAME': None}, u'ENTITY': {'IMPFLDSOURCECOLNAME': None}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD2': {'IMPFLDSOURCECOLNAME': None}, u'UD5': {'IMPFLDSOURCECOLNAME': None}, u'UD4': {'IMPFLDSOURCECOLNAME': None}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': None}, u'UD1': {'IMPFLDSOURCECOLNAME': None}}
2017-02-13 13:35:30,910 DEBUG [AIF]: CommData.getRuleInfo - END
2017-02-13 13:35:30,919 DEBUG [AIF]: CommData.updateTDATASEG_T - START
2017-02-13 13:35:30,921 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2017-02-13 13:35:30,922 DEBUG [AIF]: CommData.getLedgerSQL - START
2017-02-13 13:35:30,922 DEBUG [AIF]: CommData.getLedgerSQL - END
2017-02-13 13:35:30,922 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 = 25
2017-02-13 13:35:30,923 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2017-02-13 13:35:30,926 DEBUG [AIF]: CommData.getPovList - START
2017-02-13 13:35:30,928 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 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 = 80
ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE\_ID
2017-02-13 13:35:30,934 DEBUG [AIF]: CommData.getPovList - END
2017-02-13 13:35:30,934 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 = 80
AND en.process\_id = pp.process\_id
AND pp.IMP\_ENTITY\_NAME = en.file\_entity\_name
order by en.entity\_name\_order
2017-02-13 13:35:30,937 INFO [AIF]:
Import Data from Source for Period 'Jan-2017'
2017-02-13 13:35:30,943 DEBUG [AIF]: CommData.updateWorkflow - START
2017-02-13 13:35:30,943 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 = 83 AND tlp.CATKEY = 3 AND tlp.PERIODKEY = '2017-01-31' AND tlp.RULE\_ID = 25 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS
2017-02-13 13:35:30,944 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=83 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE\_ID=25
2017-02-13 13:35:30,946 DEBUG [AIF]: CommData.updateWorkflow - END
2017-02-13 13:35:30,946 DEBUG [AIF]:
SELECT adim.BALANCE\_COLUMN\_NAME DIMNAME, dim.TARGET\_DIMENSION\_CLASS\_NAME
FROM TPOVPARTITION tpp
INNER JOIN AIF\_TARGET\_APPL\_DIMENSIONS adim
ON adim.APPLICATION\_ID = tpp.PARTTARGETAPPLICATIONID AND adim.BALANCE\_COLUMN\_NAME IS NOT NULL
INNER JOIN AIF\_DIMENSIONS dim
ON dim.DIMENSION\_ID = adim.DIMENSION\_ID
WHERE tpp.PARTITIONKEY = 83
AND dim.TARGET\_DIMENSION\_CLASS\_NAME \<> 'ICPTRANS'
ORDER BY adim.BALANCE\_COLUMN\_NAME
2017-02-13 13:35:30,950 DEBUG [AIF]:
UPDATE TDATASEG\_T
SET AMOUNTX = AMOUNT, DATAX = DATA
,ACCOUNTX = NULL
,ENTITYX = NULL
,ICPX = NULL
,UD1X = NULL
,UD2X = NULL
,UD3X = NULL
,UD4X = NULL
,UD5X = NULL
WHERE TDATASEG\_T.LOADID = 80 AND TDATASEG\_T.PARTITIONKEY = 83 AND TDATASEG\_T.CATKEY = 3 AND TDATASEG\_T.PERIODKEY = '2017-01-31'
2017-02-13 13:35:30,951 INFO [AIF]: Generic Data Rows Imported from Source: 0
2017-02-13 13:35:30,952 INFO [AIF]: Total Data Rows Imported from Source: 0
2017-02-13 13:35:30,952 DEBUG [AIF]: CommData.updateTDATASEG_T - END
2017-02-13 13:35:30,958 DEBUG [AIF]: Comm.doScriptInit - START
2017-02-13 13:35:31,051 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=C:\FDMEE\inbox, LOCNAME=TEST, SOURCENAME=File, APPID=3, SOURCEID=1, APPROOTDIR=C:\FDMEE, IMPORTFORMAT=Test, SCRIPTSDIR=C:\FDMEE\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=HFM, RULEID=25, CATNAME=ACT, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=80, PERIODNAME=Jan-2017, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2017-01-31, EXPORTFLAG=N, TARGETAPPDB=null, TARGETAPPNAME=VCONSOL, FILENAME=ImportFormatTemplate17_5.csv, LOCKEY=83, RULENAME=r_dlr_test, OUTBOXDIR=C:\FDMEE\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=3, USERNAME=MBUG, FILEDIR=, IMPORTFLAG=Y, USERLOCALE=null}
2017-02-13 13:35:31,057 DEBUG [AIF]: The executeEventScript is set to: YES
2017-02-13 13:35:31,057 DEBUG [AIF]: The AppRootFolder is set to: C:\FDMEE
2017-02-13 13:35:31,057 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35
2017-02-13 13:35:31,058 DEBUG [AIF]: The OleDatabaseProvider is set to: SQLOLEDB
2017-02-13 13:35:31,058 DEBUG [AIF]: Comm.doScriptInit - END
2017-02-13 13:35:31,058 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:31,058 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftImport.py
2017-02-13 13:35:31,062 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:31,062 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp
2017-02-13 13:35:31,062 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftImport.vbs
2017-02-13 13:35:31,062 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:31,062 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:31,062 DEBUG [AIF]: CommData.postImportData - END
2017-02-13 13:35:31,245 DEBUG [AIF]: LogicGroup.createLogicAccounts - START
2017-02-13 13:35:31,245 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:31,245 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcLogicGrp.py
2017-02-13 13:35:31,245 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:31,245 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcLogicGrp.vbs
2017-02-13 13:35:31,245 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:31,246 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:31,248 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START
2017-02-13 13:35:31,248 DEBUG [AIF]:
select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE
from AIF\_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp
where prs.PROCESS\_ID=80 and prs.PARTITIONKEY=part.PARTITIONKEY
and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY
2017-02-13 13:35:31,251 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END
2017-02-13 13:35:31,252 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:31,252 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcLogicGrp.py
2017-02-13 13:35:31,252 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:31,253 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcLogicGrp.vbs
2017-02-13 13:35:31,253 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:31,253 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:31,253 DEBUG [AIF]: LogicGroup.createLogicAccounts - END
2017-02-13 13:35:31,308 DEBUG [AIF]: CommData.mapData - START
2017-02-13 13:35:31,309 DEBUG [AIF]: CommData.insertTransProcessDetails - START
2017-02-13 13:35:31,310 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, 'MBUG' 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 = 80
AND PRIOR\_PERIOD\_FLAG = 'N'
GROUP BY PROCESS\_ID, TRANS\_ENTITY\_TYPE, TRANS\_ENTITY\_NAME
) q
ORDER BY ENTITY\_NAME\_ORDER
2017-02-13 13:35:31,312 DEBUG [AIF]: CommData.insertTransProcessDetails - END
2017-02-13 13:35:31,316 DEBUG [AIF]:
DELETE FROM TDATAMAP\_T
WHERE LOADID \< 80
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 25 AND p.PROCESS\_ID = TDATAMAP\_T.LOADID )
2017-02-13 13:35:31,318 DEBUG [AIF]:
DELETE FROM TDATASEG\_T
WHERE LOADID \< 80
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 25 AND p.PROCESS\_ID = TDATASEG\_T.LOADID )
2017-02-13 13:35:31,319 DEBUG [AIF]:
DELETE FROM AIF\_PROCESS\_PERIODS
WHERE PROCESS\_ID \< 80
AND EXISTS ( SELECT 1 FROM AIF\_PROCESSES p WHERE p.RULE\_ID = 25 AND p.PROCESS\_ID = AIF\_PROCESS\_PERIODS.PROCESS\_ID )
2017-02-13 13:35:31,324 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START
2017-02-13 13:35:31,325 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START
2017-02-13 13:35:31,325 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 = 83
2017-02-13 13:35:31,326 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END
2017-02-13 13:35:31,328 INFO [AIF]: Processing Mappings from Parent Location: VALORAGROUP
2017-02-13 13:35:31,328 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 80, DATAKEY, 83 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 = 82
AND ( RULE\_ID IS NULL OR RULE\_ID = 25 )
2017-02-13 13:35:31,329 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 8
2017-02-13 13:35:31,377 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START
2017-02-13 13:35:31,377 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:31,378 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefProcMap.py
2017-02-13 13:35:31,378 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:31,378 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefProcMap.vbs
2017-02-13 13:35:31,378 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:31,378 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:31,379 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 = 80
AND atad.APPLICATION\_ID = 3
AND tdm.PARTITIONKEY = 83
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE\_ID IS NULL OR tdm.RULE\_ID = 25)
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 = 80
AND atad.APPLICATION\_ID = 3
AND tdm.PARTITIONKEY = 83
AND tdm.TDATAMAPTYPE = 'ERP'
AND (tdm.RULE\_ID IS NULL OR tdm.RULE\_ID = 25)
AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')
) q
ORDER BY CALC\_SEQ, DIMNAME, SEQUENCE, RULE\_ID, SYSTEM\_GENERATED\_FLAG, SRCKEY
2017-02-13 13:35:31,420 INFO [AIF]:
Map Data for Period 'Jan-2017'
2017-02-13 13:35:31,421 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-02-13 13:35:31,422 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 ('MBUG' IS NULL) THEN LAST\_UPDATED\_BY ELSE 'MBUG' END
,LAST\_UPDATE\_DATE = CURRENT\_TIMESTAMP
WHERE PROCESS\_ID = 80 AND ENTITY\_TYPE = 'PROCESS\_BAL\_TRANS' AND ENTITY\_NAME = 'Jan-2017'
2017-02-13 13:35:31,424 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-02-13 13:35:31,427 DEBUG [AIF]:
SELECT COUNT(\*) ROW\_COUNT
FROM TDATASEG\_T
WHERE LOADID = 80
AND (PARTITIONKEY = 83 AND CATKEY = 3 AND PERIODKEY = '2017-01-31' AND RULE\_ID = 25 AND VALID\_FLAG = 'Y')
2017-02-13 13:35:31,428 WARN [AIF]: Warning: No records exist for Period 'Jan-2017'
2017-02-13 13:35:31,428 DEBUG [AIF]: Comm.updateProcessDetail - START
2017-02-13 13:35:31,428 DEBUG [AIF]:
UPDATE AIF\_PROCESS\_DETAILS
SET STATUS = 'WARNING'
,RECORDS\_PROCESSED = CASE WHEN RECORDS\_PROCESSED IS NULL THEN 0 ELSE RECORDS\_PROCESSED END + NULL
,EXECUTION\_END\_TIME = CURRENT\_TIMESTAMP
,LAST\_UPDATED\_BY = CASE WHEN ('MBUG' IS NULL) THEN LAST\_UPDATED\_BY ELSE 'MBUG' END
,LAST\_UPDATE\_DATE = CURRENT\_TIMESTAMP
WHERE PROCESS\_ID = 80 AND ENTITY\_TYPE = 'PROCESS\_BAL\_TRANS' AND ENTITY\_NAME = 'Jan-2017'
2017-02-13 13:35:31,430 DEBUG [AIF]: Comm.updateProcessDetail - END
2017-02-13 13:35:31,438 DEBUG [AIF]: CommData.updateWorkflow - START
2017-02-13 13:35:31,438 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT\_TIMESTAMP
,PROCESSSTATUS=2,PROCESSIMP=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0
,PROCESSIMPNOTE='AIF\_WF\_IMP\_IMPORT\_ERR'
WHERE PARTITIONKEY=83 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE\_ID=25
2017-02-13 13:35:31,441 DEBUG [AIF]: CommData.updateWorkflow - END
2017-02-13 13:35:31,441 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END
2017-02-13 13:35:31,455 DEBUG [AIF]: CommData.updateYtdAmounts - START
2017-02-13 13:35:31,457 DEBUG [AIF]: CommData.getLedgerListAndMap - START
2017-02-13 13:35:31,458 DEBUG [AIF]: CommData.getLedgerSQL - START
2017-02-13 13:35:31,458 DEBUG [AIF]: CommData.getLedgerSQL - END
2017-02-13 13:35:31,458 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 = 25
2017-02-13 13:35:31,459 DEBUG [AIF]: CommData.getLedgerListAndMap - END
2017-02-13 13:35:31,459 DEBUG [AIF]: CommData.updateYtdAmounts - END
2017-02-13 13:35:31,470 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START
2017-02-13 13:35:31,470 INFO [AIF]:
Stage Data for Period 'Jan-2017'
2017-02-13 13:35:31,470 DEBUG [AIF]:
DELETE FROM TDATAMAPSEG
WHERE PARTITIONKEY = 83
AND CATKEY = 3
AND PERIODKEY = '2017-01-31'
2017-02-13 13:35:31,474 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 8
2017-02-13 13:35:31,475 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, 3, '2017-01-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,
WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM\_GENERATED\_FLAG
FROM TDATAMAP\_T
WHERE LOADID = 80
2017-02-13 13:35:31,476 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 8
2017-02-13 13:35:31,476 DEBUG [AIF]:
DELETE FROM TDATAMAP\_T
WHERE LOADID = 80
2017-02-13 13:35:31,477 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 8
2017-02-13 13:35:31,477 DEBUG [AIF]:
DELETE FROM TDATASEG
WHERE LOADID \< 80 AND PARTITIONKEY = 83 AND CATKEY = 3 AND RULE\_ID = 25 AND PERIODKEY = '2017-01-31'
2017-02-13 13:35:31,478 INFO [AIF]: Number of Rows deleted from TDATASEG: 0
2017-02-13 13:35:31,478 DEBUG [AIF]:
DELETE FROM TDATAMEMOITEMS
WHERE PARTITIONKEY = 83 AND PERIODKEY = '2017-01-31' AND CATKEY = 3 AND RULE\_ID = 25
AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)
2017-02-13 13:35:31,479 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0
2017-02-13 13:35:31,479 DEBUG [AIF]:
DELETE FROM TDATAARCHIVE
WHERE PARTITIONKEY = 83 AND PERIODKEY = '2017-01-31' AND CATKEY = 3 AND RULE\_ID = 25
AND ARCHIVEPROCTYPEID = 1
AND NOT EXISTS ( SELECT 1
FROM TDATAMEMOITEMS
WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID
OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )
2017-02-13 13:35:31,480 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0
2017-02-13 13:35:31,480 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
,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
,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE\_ID, CODE\_COMBINATION\_ID,STAT\_BALANCE\_FLAG, VALID\_FLAG
FROM TDATASEG\_T
WHERE LOADID = 80 AND PARTITIONKEY = 83 AND CATKEY = 3 AND PERIODKEY = '2017-01-31'
2017-02-13 13:35:31,482 INFO [AIF]: Number of Rows inserted into TDATASEG: 0
2017-02-13 13:35:31,482 DEBUG [AIF]:
DELETE FROM TDATASEG\_T
WHERE LOADID = 80 AND PARTITIONKEY = 83 AND CATKEY = 3 AND PERIODKEY = '2017-01-31'
2017-02-13 13:35:31,483 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 0
2017-02-13 13:35:31,483 DEBUG [AIF]: CommData.updateWorkflow - START
2017-02-13 13:35:31,483 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT\_TIMESTAMP
,PROCESSSTATUS=2,PROCESSIMP=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0
,PROCESSIMPNOTE='Import Error'
WHERE PARTITIONKEY=83 AND CATKEY=3 AND PERIODKEY='2017-01-31' AND RULE\_ID=25
2017-02-13 13:35:31,485 DEBUG [AIF]: CommData.updateWorkflow - END
2017-02-13 13:35:31,485 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END
2017-02-13 13:35:31,486 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:31,486 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftProcMap.py
2017-02-13 13:35:31,486 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:31,486 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftProcMap.vbs
2017-02-13 13:35:31,486 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:31,486 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:31,486 DEBUG [AIF]: CommData.mapData - END
2017-02-13 13:35:31,510 INFO [AIF]: -------END IMPORT STEP-------
2017-02-13 13:35:31,536 INFO [AIF]: -------START VALIDATE STEP-------
2017-02-13 13:35:31,569 DEBUG [AIF]: CommData.validateData - START
2017-02-13 13:35:31,569 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:31,570 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/BefValidate.py
2017-02-13 13:35:31,570 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:31,570 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\BefValidate.vbs
2017-02-13 13:35:31,570 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:31,570 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:31,577 DEBUG [AIF]: CommMap.validateData - START
2017-02-13 13:35:31,579 WARN [AIF]: Warning: The Import step has not been completed for period Jan-2017
2017-02-13 13:35:31,579 DEBUG [AIF]: CommMap.validateData - END
2017-02-13 13:35:31,580 WARN [AIF]: Warning: The Import step has not been completed for period Jan-2017
2017-02-13 13:35:31,580 DEBUG [AIF]: Comm.executeScript - START
2017-02-13 13:35:31,580 DEBUG [AIF]: The following script does not exist: C:\FDMEE/data/scripts/event/AftValidate.py
2017-02-13 13:35:31,580 DEBUG [AIF]: Comm.executeVBScript - START
2017-02-13 13:35:31,580 DEBUG [AIF]: The following script does not exist: C:\FDMEE\data\scripts\event\AftValidate.vbs
2017-02-13 13:35:31,580 DEBUG [AIF]: Comm.executeVBScript - END
2017-02-13 13:35:31,580 DEBUG [AIF]: Comm.executeScript - END
2017-02-13 13:35:31,580 DEBUG [AIF]: CommData.validateData - END
2017-02-13 13:35:31,602 INFO [AIF]: -------END VALIDATE STEP-------
2017-02-13 13:35:31,763 DEBUG [AIF]: Comm.finalizeProcess - START
2017-02-13 13:35:31,764 DEBUG [AIF]: CommData.updateRuleStatus - START
2017-02-13 13:35:31,764 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 = 80 AND pd.STATUS IN ('FAILED','WARNING') )
WHEN 0 THEN 'SUCCESS'
ELSE ( SELECT MIN(pd.STATUS) FROM AIF\_PROCESS\_DETAILS pd WHERE pd.PROCESS\_ID = 80 AND pd.STATUS IN ('FAILED','WARNING') ) END
ELSE 'SUCCESS' END
WHERE RULE\_ID = 25
2017-02-13 13:35:31,767 DEBUG [AIF]: CommData.updateRuleStatus - END
2017-02-13 13:35:31,768 DEBUG [AIF]: Comm.updateProcess - START
2017-02-13 13:35:31,771 DEBUG [AIF]: Comm.updateProcess - END
2017-02-13 13:35:31,771 DEBUG [AIF]: The fdmAPI connection has been closed.
2017-02-13 13:35:31,772 INFO [AIF]: FDMEE Process End, Process ID: 80