2 Replies Latest reply on May 12, 2017 5:17 PM by DjSmeadly

    Cloud Data Management - Multi Column - Numeric Data

    DjSmeadly

      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?