Hi,
When attempting to import csv file, business rule execution failed and I found that "Transform and stage balane data to export for period yyyymm" didn't work at all as below.
And log :
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
2020-02-03 05:08:01,417 INFO [AIF]: FDMEE Process: 2923, Log Level: 4, Log File: /u03/inbox/outbox/logs/PBCS4PPS_2923.log
2020-02-03 05:08:01,417 INFO [AIF]: Location : PBCS4PPS (Partitionkey:7)
2020-02-03 05:08:01,417 INFO [AIF]: Period Name : 201911 (Period Key:11/30/19 12:00 AM)
2020-02-03 05:08:01,417 INFO [AIF]: Category Name: Actual (Category key:2)
2020-02-03 05:08:01,417 INFO [AIF]: Rule Name : PL (Rule ID:9)
2020-02-03 05:08:02,998 INFO [AIF]: Log File Encoding: Shift_JIS
2020-02-03 05:08:04,067 INFO [AIF]: -------START IMPORT STEP-------
2020-02-03 05:08:04,316 INFO [AIF]: File Name: PL201911.csv
2020-02-03 05:08:04,502 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:IMPGROUPFILETYPE::2923;7:2:9:Local::DELIMITED
2020-02-03 05:08:04,508 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: Shift_JIS
2020-02-03 05:08:04,508 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2020-02-03 05:08:04,552 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2020-02-03 05:08:04,552 INFO [AIF]: EPMFDM-140274:Message - File Name PL201911.csv
periodKey2019-11-30
2020-02-03 05:08:04,725 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 2923
PARTITIONKEY: 7
IMPORT GROUP: PL(Actual)
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: PL201911.csv
PROCESSING CODES:
Rows Loaded: 2240
Rows Rejected: 93
2020-02-03 05:08:04,963 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Move
2020-02-03 05:08:04,963 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:
2020-02-03 05:08:04,964 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 292320191130.csv
2020-02-03 05:08:04,976 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: PL201911.csv
2020-02-03 05:08:04,977 INFO [AIF]: EPMFDM-140274:Message - Source File deleted: PL201911.csv
2020-02-03 05:08:04,994 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End
2020-02-03 05:08:04,994 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 486
2020-02-03 05:08:05,063 INFO [AIF]:
Import Data from Source for Period '201911'
2020-02-03 05:08:05,121 INFO [AIF]: Executing delete statement:
2020-02-03 05:08:05,122 INFO [AIF]: Successfully executed delete statement
2020-02-03 05:08:05,248 FATAL [AIF]: Error in COMM Map Data
2020-02-03 05:08:05,254 INFO [AIF]: FDMEE Process End, Process ID: 2923
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
According to this log, this failure seemed to result from Error in COMM Map Data, but I don't know what it is and how to solve this problem.
Could you tell me them?