Hello,
I am trying to import non numeric data but not able to get it to work in FDMEE in EPBCS. I've set everything up to Delimited - All Data Types but the only error i get when importing is EPMFDM-140274:Message - Initialize error maps. Not sure what could be causing it.
2020-03-11 17:22:42,776 DEBUG [AIF]: Script- getRuleInfo
2020-03-11 17:22:42,783 DEBUG [AIF]: header row for text data: COST_CENTER, CURRENCY, HCR_NUMBER, ENTITY, PENDING
2020-03-11 17:22:42,783 DEBUG [AIF]: Header:COST_CENTER, CURRENCY, HCR_NUMBER, ENTITY, PENDING
2020-03-11 17:22:42,787 DEBUG [AIF]: HeaderRow:COST_CENTER, CURRENCY, HCR_NUMBER, ENTITY, PENDING
2020-03-11 17:22:42,787 DEBUG [AIF]: HEADER_ROW_NUM:1
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: PENDING -> 5
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=5:SourceClName=PENDING:ImpFldTargetExp=null
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: PENDING -> 5
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DATA:ImpFieldText=null:StartPos=5:SourceClName=PENDING:ImpFldTargetExp=null
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: ENTITY -> 4
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=4:SourceClName=ENTITY:ImpFldTargetExp=null
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: COST_CENTER -> 1
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=1:SourceClName=COST_CENTER:ImpFldTargetExp=null
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: CURRENCY -> 2
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD6:ImpFieldText=null:StartPos=2:SourceClName=CURRENCY:ImpFldTargetExp=null
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: HCR_NUMBER -> 3
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD8:ImpFieldText=null:StartPos=3:SourceClName=HCR_NUMBER:ImpFldTargetExp=null
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: ACCOUNT -> 1
2020-03-11 17:22:42,826 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=ACCOUNT:ImpFldTargetExp=null
2020-03-11 17:22:42,827 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2020-03-11 17:22:42,827 INFO [AIF]: EPMFDM-140274:Message - File Name Snowflake_876.dat
periodKey2019-01-31
2020-03-11 17:22:42,828 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 876
PARTITIONKEY: 73
IMPORT GROUP: IMP_WFP_OPEN_PEND
FILE TYPE: FIXED
SOURCE FILE: Snowflake_876.dat
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.
[HEADER_ROW] COST_CENTER, CURRENCY, HCR_NUMBER, ENTITY, PENDING
Rows Loaded: 0
Rows Rejected: 0
