I am having an issue. I am currently using John Goodwin's blog to test out some functionality. More to life...: FDMEE/Data Management - loading data by multiple periods and years
I am using this data set:
LoadView,"no view",2016,Actual,Final,"no legal entity","No_CustType","no site",Markets,Products,"no account",Dec,10
LoadView,"no view",2017,Actual,Final,"no legal entity","No_CustType","no site",Markets,Products,"no account",Dec,20
each column is using the Like mappings with * since it's all 1 to 1.
I also setup a Period Mapping > Source Mapping > File using the below parameters:
Period Key: Period Name: Calendar: GL Year: GL Period: GL Period Number:
12/31/2016 Dec-16 LOAD 2016 Dec 12
12/31/2017 Dec-17 LOAD 2017 Dec 12
I get the below errors in my error log.
2017-05-12 15:52:16,049 INFO [AIF]: FDMEE Process: 30, Log Level: 4
2017-05-12 15:52:16,049 INFO [AIF]: Location : APP (Partitionkey:8)
2017-05-12 15:52:16,049 INFO [AIF]: Period Name : Dec-16 (Period Key:12/31/16 12:00 AM)
2017-05-12 15:52:16,049 INFO [AIF]: Category Name: Actual (Category key:1)
2017-05-12 15:52:16,050 INFO [AIF]: Rule Name : APP_LOAD (Rule ID:4)
2017-05-12 15:52:17,812 INFO [AIF]: FDM Version: 11.1.2.4.220
2017-05-12 15:52:17,812 INFO [AIF]: Log File Encoding: UTF-8
2017-05-12 15:52:18,862 INFO [AIF]: -------START IMPORT STEP-------
2017-05-12 15:52:18,950 INFO [AIF]: File Name: LOAD_ACT_20170511.csv
2017-05-12 15:52:22,166 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::30;8:1:4:[NONE]:/u03/inbox/inbox:MULTIPER
2017-05-12 15:52:22,170 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2017-05-12 15:52:22,170 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2017-05-12 15:52:22,310 ERROR [AIF]: EPMFDM-140274:Message - null
2017-05-12 15:52:22,314 ERROR [AIF]: EPMFDM-140274:Message - EPMFDM-140274:Message - {0}
2017-05-12 15:52:22,317 FATAL [AIF]: Error in FileData.importData
Traceback (most recent call last):
File "<string>", line 113, in importData
RuntimeException: java.lang.RuntimeException: EPMFDM-140274:Message - {0}
2017-05-12 15:52:22,444 INFO [AIF]:
Import Data from Source for Period 'Dec-16'
2017-05-12 15:52:22,451 FATAL [AIF]: Error in CommData.updateTDATASEG_T
Traceback (most recent call last):
File "<string>", line 908, in updateTDATASEG_T
Import Error
2017-05-12 15:52:22,562 FATAL [AIF]: Error in COMM Post Import Data
2017-05-12 15:52:22,649 INFO [AIF]: FDMEE Process End, Process ID: 30
Anyone have ideas what I am missing?