4 Replies Latest reply on Oct 1, 2015 1:12 PM by Chuggans-Oracle

    DATA LOAD FROM FILE TO FDMEE FAILED

    1047190

      Hi Experts,

       

      I am facing below issue when i  am loading data from file to essbase using FDMEE 11.1.2.4

       

      its not even importing data . Can anyone help me in fixing it.

       

      2015-09-30 04:05:27,158 INFO  [AIF]: FDMEE Process Start, Process ID: 65

      2015-09-30 04:05:27,158 INFO  [AIF]: FDMEE Logging Level: 4

      2015-09-30 04:05:27,158 INFO  [AIF]: FDMEE Log File: C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\outbox\logs\praveen-praveen1_65.log

      2015-09-30 04:05:27,158 INFO  [AIF]: User:admin

      2015-09-30 04:05:27,158 INFO  [AIF]: Location:100US (Partitionkey:2)

      2015-09-30 04:05:27,158 INFO  [AIF]: Period Name:Sep (Period Key:9/30/09 12:00 AM)

      2015-09-30 04:05:27,158 INFO  [AIF]: Category Name:Actual (Category key:1)

      2015-09-30 04:05:27,158 INFO  [AIF]: Rule Name:PRAVEENDATALOADRULE (Rule ID:2)

      2015-09-30 04:05:30,169 INFO  [AIF]: FDM Version: 11.1.2.4.000

      2015-09-30 04:05:30,169 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2015-09-30 04:05:30,169 INFO  [AIF]: Java Platform: java1.6.0_37

      2015-09-30 04:05:30,169 INFO  [AIF]: Log File Encoding: UTF-8

      2015-09-30 04:05:35,364 INFO  [AIF]: -------START IMPORT STEP-------

      2015-09-30 04:05:35,567 INFO  [AIF]: File Name: PravenappdataSep.txt

      2015-09-30 04:05:36,534 INFO  [AIF]: The execution of event scripts has been disabled.

      2015-09-30 04:05:45,909 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\outbox\logs\praveen-praveen1_65.log

      2015-09-30 04:05:45,956 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::65;2:1:2:[NONE]:C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP/inbox\100US

      2015-09-30 04:05:45,972 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

      2015-09-30 04:05:46,065 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

      2015-09-30 04:05:46,143 ERROR [AIF]: EPMFDM-140274:Message - C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\inbox\100US\PravenappdataSep.txt (The system cannot find the path specified)

      2015-09-30 04:05:46,159 FATAL [AIF]: Error in FileData.importData

      Traceback (most recent call last):

        File "<string>", line 84, in importData

      RuntimeException: java.lang.RuntimeException: EPMFDM-140274:Message - {0}

       

      2015-09-30 04:05:46,362 INFO  [AIF]:

      Import Data from Source for Period 'Sep'

      2015-09-30 04:05:46,393 FATAL [AIF]: Error in CommData.updateTDATASEG_T

      Traceback (most recent call last):

        File "<string>", line 1010, in updateTDATASEG_T

      Import Error

       

      2015-09-30 04:05:47,579 INFO  [AIF]: The execution of event scripts has been disabled.

      2015-09-30 04:05:47,625 FATAL [AIF]: Error in COMM Post Import Data

      2015-09-30 04:05:47,719 INFO  [AIF]: FDMEE Process End, Process ID: 65

       

      Thanks,

        • 1. Re: DATA LOAD FROM FILE TO FDMEE FAILED
          Chuggans-Oracle

          I think that the clue could be in your error:

           

          2015-09-30 04:05:46,143 ERROR [AIF]: EPMFDM-140274:Message - C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\inbox\100US\PravenappdataSep.txt (The system cannot find the path specified)

           

          It looks to me like your source file isn't where it's expected to be

          1 person found this helpful
          • 2. Re: DATA LOAD FROM FILE TO FDMEE FAILED
            Nishant Fukate

            Hi,

             

            As per the process log, there are 2 possibilities for such error.

             

            1) Either your Source file(PravenappdataSep.txt) is not stored in the desired path.

            OR

            2) (PravenappdataSep.txt) this file is not properly uploaded on the server.

             

            That is the reason your system can not find the specified path.

             

            I would recommend you to check the existence of your file on the Server as well as from there where your are trying to upload.

             

            Thanks

             

            Nishant

            1 person found this helpful
            • 3. Re: DATA LOAD FROM FILE TO FDMEE FAILED
              1047190

              Thanks Chuggans/ Nishant

               

              i have checked the data file and placed in the above location . Now it worked i am able to import and validate data.But its not exporting data

              i am getting below error can u pls advice

              2015-10-01 03:35:15,408 INFO  [AIF]: FDMEE Process Start, Process ID: 71

              2015-10-01 03:35:15,408 INFO  [AIF]: FDMEE Logging Level: 4

              2015-10-01 03:35:15,408 INFO  [AIF]: FDMEE Log File: C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\outbox\logs\praveen-praveen1_71.log

              2015-10-01 03:35:15,408 INFO  [AIF]: User:admin

              2015-10-01 03:35:15,408 INFO  [AIF]: Location:100US (Partitionkey:2)

              2015-10-01 03:35:15,408 INFO  [AIF]: Period Name:Sep (Period Key:9/30/09 12:00 AM)

              2015-10-01 03:35:15,408 INFO  [AIF]: Category Name:Actual (Category key:1)

              2015-10-01 03:35:15,408 INFO  [AIF]: Rule Name:PRAVEENDATALOADRULE (Rule ID:2)

              2015-10-01 03:35:17,967 INFO  [AIF]: FDM Version: 11.1.2.4.000

              2015-10-01 03:35:17,967 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

              [Oracle JRockit(R) (Oracle Corporation)]

              2015-10-01 03:35:17,967 INFO  [AIF]: Java Platform: java1.6.0_37

              2015-10-01 03:35:17,967 INFO  [AIF]: Log File Encoding: UTF-8

              2015-10-01 03:35:22,647 INFO  [AIF]: -------START IMPORT STEP-------

              2015-10-01 03:35:23,286 INFO  [AIF]: File Name: PravenappdataSep.txt

              2015-10-01 03:35:24,519 INFO  [AIF]: The execution of event scripts has been disabled.

              2015-10-01 03:35:32,334 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\outbox\logs\praveen-praveen1_71.log

              2015-10-01 03:35:32,381 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::71;2:1:2:[NONE]:C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP/inbox\100US

              2015-10-01 03:35:32,397 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

              2015-10-01 03:35:32,397 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

              2015-10-01 03:35:32,459 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\outbox\logs\praveen-praveen1_71.log

              2015-10-01 03:35:32,537 INFO  [AIF]: EPMFDM-140274:Message - File Name PravenappdataSep.txt

              periodKey2009-09-30

              2015-10-01 03:35:32,584 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 71

              PARTITIONKEY: 2

              IMPORT GROUP: prappimportformat

              FILE TYPE: DELIMITED

              DELIMITER: ,

              SOURCE FILE: PravenappdataSep.txt

              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

               

               

              Rows Loaded: 1

              Rows Rejected: 0

               

              2015-10-01 03:35:32,584 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy

              2015-10-01 03:35:32,584 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

              2015-10-01 03:35:32,600 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 7120090930.txt

              2015-10-01 03:35:32,600 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: PravenappdataSep.txt

              2015-10-01 03:35:32,600 INFO  [AIF]: EPMFDM-140274:Message - File not deleted: C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP\inbox\100US\PravenappdataSep.txt

              2015-10-01 03:35:32,615 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

              2015-10-01 03:35:32,615 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 218

              2015-10-01 03:35:32,771 INFO  [AIF]:

              Import Data from Source for Period 'Sep'

              2015-10-01 03:35:32,818 INFO  [AIF]:     Generic Data Rows Imported from Source: 1

              2015-10-01 03:35:32,818 INFO  [AIF]: Total Data Rows Imported from Source: 1

              2015-10-01 03:35:33,411 INFO  [AIF]: The execution of event scripts has been disabled.

              2015-10-01 03:35:33,801 INFO  [AIF]:

              Map Data for Period 'Sep'

              2015-10-01 03:35:33,816 INFO  [AIF]:

              Processing Mappings for Column 'ACCOUNT'

              2015-10-01 03:35:33,863 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:33,863 INFO  [AIF]:

              Processing Mappings for Column 'ENTITY'

              2015-10-01 03:35:33,894 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:33,894 INFO  [AIF]:

              Processing Mappings for Column 'UD1'

              2015-10-01 03:35:33,957 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:33,957 INFO  [AIF]:

              Processing Mappings for Column 'UD10'

              2015-10-01 03:35:34,004 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,004 INFO  [AIF]:

              Processing Mappings for Column 'UD11'

              2015-10-01 03:35:34,050 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,050 INFO  [AIF]:

              Processing Mappings for Column 'UD2'

              2015-10-01 03:35:34,082 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,082 INFO  [AIF]:

              Processing Mappings for Column 'UD3'

              2015-10-01 03:35:34,128 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,128 INFO  [AIF]:

              Processing Mappings for Column 'UD4'

              2015-10-01 03:35:34,160 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,160 INFO  [AIF]:

              Processing Mappings for Column 'UD5'

              2015-10-01 03:35:34,206 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,206 INFO  [AIF]:

              Processing Mappings for Column 'UD6'

              2015-10-01 03:35:34,238 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,238 INFO  [AIF]:

              Processing Mappings for Column 'UD7'

              2015-10-01 03:35:34,269 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,269 INFO  [AIF]:

              Processing Mappings for Column 'UD8'

              2015-10-01 03:35:34,316 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,316 INFO  [AIF]:

              Processing Mappings for Column 'UD9'

              2015-10-01 03:35:34,347 INFO  [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 1

              2015-10-01 03:35:34,409 INFO  [AIF]:

              Stage Data for Period 'Sep'

              2015-10-01 03:35:34,425 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 13

              2015-10-01 03:35:34,425 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 13

              2015-10-01 03:35:34,425 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 13

              2015-10-01 03:35:34,440 INFO  [AIF]: Number of Rows deleted from TDATASEG: 1

              2015-10-01 03:35:34,440 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

              2015-10-01 03:35:34,503 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

              2015-10-01 03:35:34,518 INFO  [AIF]: Number of Rows inserted into TDATASEG: 1

              2015-10-01 03:35:34,518 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 1

              2015-10-01 03:35:34,550 INFO  [AIF]: -------END IMPORT STEP-------

              2015-10-01 03:35:34,565 INFO  [AIF]: -------START VALIDATE STEP-------

              2015-10-01 03:35:34,596 INFO  [AIF]:

              Validate Data Mappings for Period 'Sep'

              2015-10-01 03:35:34,628 INFO  [AIF]: Total Data Rows available for Export to Target: 1

              2015-10-01 03:35:34,628 INFO  [AIF]:

              Validate Data Members for Period 'Sep'

              2015-10-01 03:35:34,628 INFO  [AIF]: Total Data Rows available for Export to Target: 1

              2015-10-01 03:35:34,643 INFO  [AIF]: -------END VALIDATE STEP-------

              2015-10-01 03:35:34,674 INFO  [AIF]: -------START EXPORT STEP-------

              2015-10-01 03:35:34,737 INFO  [AIF]: LOAD_METHOD:ESSFILE, BATCH_SIZE:10000, PURGE_DATA_FILE:false

              2015-10-01 03:35:34,737 INFO  [AIF]: Resolved user name for application access: admin

              2015-10-01 03:35:35,080 INFO  [AIF]: The default rule file will not be used as a custom rule file has been specified: essrule

              2015-10-01 03:35:35,080 INFO  [AIF]: [EssbaseService] Export Mode: STORE_DATA

              2015-10-01 03:35:37,420 INFO  [AIF]: [EssbaseService] Creating data file: C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP/outbox/praveen_71.dat

              2015-10-01 03:35:37,467 INFO  [AIF]: [EssbaseService] Data file creation complete

              2015-10-01 03:35:37,482 INFO  [AIF]: [EssbaseService] [exportData:71] END (true)

              2015-10-01 03:35:37,701 INFO  [AIF]: LOAD_METHOD:ESSFILE, BATCH_SIZE:10000, PURGE_DATA_FILE:false

              2015-10-01 03:35:37,701 INFO  [AIF]: Resolved user name for application access: admin

              2015-10-01 03:35:38,481 INFO  [AIF]: [EssbaseService] Export Mode: STORE_DATA

              2015-10-01 03:35:38,528 INFO  [AIF]: The default rule file will not be used as a custom rule file has been specified: essrule

              2015-10-01 03:35:38,528 INFO  [AIF]: Resolved essbase rule file name for loading: essrule

              2015-10-01 03:35:38,684 INFO  [AIF]: [EssbaseService] Data file name: C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\PRAVEENAPP/outbox/praveen_71.dat

              2015-10-01 03:35:38,684 INFO  [AIF]: Starting executeDataRuleFile...

              2015-10-01 03:35:38,730 INFO  [AIF]: Getting load buffer for ASO data load...

              2015-10-01 03:35:38,871 INFO  [AIF]: Initializing load buffer [1]

              2015-10-01 03:35:38,918 INFO  [AIF]: Loading data into cube using data file...

              2015-10-01 03:35:39,058 INFO  [AIF]: The load buffer [1] has been closed.

              2015-10-01 03:35:39,058 INFO  [AIF]: Load data encountered the following errors:

              | Error: 3303 | AC_10100,Sep,No Service,2009,No Project,Final,Base,USD,No Customer,No Company,Actual,No Area,No Vessel,999.000000000000 | AC_10100,Sep,No Service,2009,No Project,Final,Base,USD,No Customer,No Company,Actual,No Area,No Vessel,999.000000000000 |

              2015-10-01 03:35:39,058 INFO  [AIF]: Load data failed.

              2015-10-01 03:35:39,074 ERROR [AIF]: Error encountered

              2015-10-01 03:35:39,074 INFO  [AIF]: [EssbaseService] [loadData:71] END (java.lang.Exception: Load data failed.)

              2015-10-01 03:35:39,089 FATAL [AIF]: Error in CommData.loadData

              Traceback (most recent call last):

                File "<string>", line 5163, in loadData

              RuntimeError: java.lang.Exception: Load data failed.

               

              2015-10-01 03:35:39,308 FATAL [AIF]: Error in COMM Load Data

              2015-10-01 03:35:39,339 INFO  [AIF]: FDMEE Process End, Process ID: 71

              • 4. Re: DATA LOAD FROM FILE TO FDMEE FAILED
                Chuggans-Oracle

                Error 3303 is a missing member error being returned from Essbase so you probably need to make sure that your metadata has been refreshed in your target application