3 Replies Latest reply on Nov 7, 2014 9:57 AM by Francisco Amores

    Error when import data in Hyperion FDM

    e6b3c44f-74e8-4d5e-9779-ecda21c5c3c0

      Hello,

       

      I want to upload data.csv for serverals entities with differents months in Hyperion FDM. It worked for july, august and september but it failed for octobre and all others following months. I have checked in the log file but the error message didn't help a lot as I'am totally a FDM beginner.

       

      Could you help me out with this log file ?

       

      Thanks a lot! Waiting online!

       

      2014-11-05 17:43:30,876 INFO  [AIF]: FDMEE Process Start, Process ID: 174

      2014-11-05 17:43:30,876 INFO  [AIF]: FDMEE Logging Level: 4

      2014-11-05 17:43:30,876 INFO  [AIF]: FDMEE Log File: C:\Oracle\EPM_data\FDM\HN_OPEX\outbox\logs\HN_OPEX_174.log

      2014-11-05 17:43:30,876 INFO  [AIF]: User:admin

      2014-11-05 17:43:30,876 INFO  [AIF]: Location:103 (Partitionkey:11)

      2014-11-05 17:43:30,876 INFO  [AIF]: Period Name:Oct - 2013 (Period Key:31/10/13 00:00)

      2014-11-05 17:43:30,876 INFO  [AIF]: Category Name:ACTUAL (Category key:1)

      2014-11-05 17:43:30,876 INFO  [AIF]: Rule Name:HN_103 (Rule ID:20)

      2014-11-05 17:43:32,233 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2014-11-05 17:43:32,233 INFO  [AIF]: Java Platform: java1.6.0_37

      2014-11-05 17:43:32,233 INFO  [AIF]: Log File Encoding: UTF-8

      2014-11-05 17:43:33,933 INFO  [AIF]: -------START IMPORT STEP-------

      2014-11-05 17:43:37,381 INFO  [AIF]: File Name: Turkey_Actual_2013-14_Multiload_OCT.csv

      2014-11-05 17:43:37,552 INFO  [AIF]: ERPI-105011:EPMERPI- Log File Name :C:\Oracle\EPM_data\FDM\HN_OPEX\outbox\logs\HN_OPEX_174.log

      2014-11-05 17:43:37,552 INFO  [AIF]: ERPI-105011:EPMERPI- LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::174;11:1:20:[NONE]:C:\Oracle\EPM_data\FDM\HN_OPEX/

      2014-11-05 17:43:37,552 INFO  [AIF]: ERPI-105011:EPMERPI- File CharEncoding as per settings: UTF-8

      2014-11-05 17:43:37,552 INFO  [AIF]: ERPI-105011:EPMERPI- ImportTextData - Start

      2014-11-05 17:43:37,568 INFO  [AIF]: ERPI-105011:EPMERPI- Log File Name :C:\Oracle\EPM_data\FDM\HN_OPEX\outbox\logs\HN_OPEX_174.log

      2014-11-05 17:43:37,568 INFO  [AIF]: ERPI-105011:EPMERPI- Instantiating JythonInterpreter

      2014-11-05 17:43:37,693 INFO  [AIF]: 105039:EPMERPI - Log File Name :C:\Oracle\EPM_data\FDM\HN_OPEX\outbox\logs\HN_OPEX_174.log

      2014-11-05 17:43:37,693 INFO  [AIF]: 105039:EPMERPI - Execute File: C:\Oracle\EPM_data\FDM\HN_OPEX/data/scripts/import/HNI_Import_Transac.py

      2014-11-05 17:43:37,708 INFO  [AIF]: ERPI-105011:EPMERPI- File Name Turkey_Actual_2013-14_Multiload_OCT.csv

      periodKey2013-10-31

      2014-11-05 17:43:37,724 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,724 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,724 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,724 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,740 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,740 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,740 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,740 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,740 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,755 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,755 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,755 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,755 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,755 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,771 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,771 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,771 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,771 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,771 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,786 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,786 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,786 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,786 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,786 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,802 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,802 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,802 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,802 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,802 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,818 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,818 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,818 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,818 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,833 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,833 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,833 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,833 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,833 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,849 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,849 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,849 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,849 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,849 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,864 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,864 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,864 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,896 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,896 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,911 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,911 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,911 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,911 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,911 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,927 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,927 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,927 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.

      null

      2014-11-05 17:43:37,927 INFO  [AIF]: ERPI-105011:EPMERPI-  PROCESS ID: 174

      PARTITIONKEY: 11

      IMPORT GROUP: HN_LOAD_OPEX

      FILE TYPE: DELIMITED

      DELIMITER: ;

      SOURCE FILE: Turkey_Actual_2013-14_Multiload_OCT.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

       

       

      2014-11-05 17:43:37,927 INFO  [AIF]: ERPI-105011:EPMERPI- ARCHIVE MODE: null

      2014-11-05 17:43:37,927 INFO  [AIF]: ERPI-105011:EPMERPI- Start archiving file:

      2014-11-05 17:43:37,927 INFO  [AIF]: ERPI-105011:EPMERPI- Archive file name: 17420131031.csv

      2014-11-05 17:43:37,927 INFO  [AIF]: ERPI-105011:EPMERPI- Deleting the source file: Turkey_Actual_2013-14_Multiload_OCT.csv

      2014-11-05 17:43:37,927 INFO  [AIF]: ERPI-105011:EPMERPI- File not deleted: C:\Oracle\EPM_data\FDM\HN_OPEX\Turkey_Actual_2013-14_Multiload_OCT.csv

      2014-11-05 17:43:37,942 INFO  [AIF]: ERPI-105011:EPMERPI- ImportTextData - End

      2014-11-05 17:43:37,942 INFO  [AIF]: ERPI-105011:EPMERPI- Total time taken for the import in ms = 390

      2014-11-05 17:43:37,942 INFO  [AIF]: ERPI-105011:EPMERPI- Releasing JythonInterpreter

      2014-11-05 17:43:38,052 INFO  [AIF]:

      Import Data from Source for Period 'Oct - 2013'

      2014-11-05 17:43:38,067 INFO  [AIF]: Generic Data Rows Imported from Source: 0

      2014-11-05 17:43:38,067 INFO  [AIF]: Total Data Rows Imported from Source: 0

      2014-11-05 17:43:38,598 INFO  [AIF]:

      Map Data for Period 'Oct - 2013'

      2014-11-05 17:43:38,598 ERROR [AIF]: Error: No records exist for Period 'Oct - 2013'