3 Replies Latest reply on Nov 28, 2016 10:10 PM by Francisco Amores

    Zero Kb export file is getting created when trying to load data into planning via FDMEE

    3254686

      Hi,

       

      When trying to load data via FDMEE, import, validate and export steps are successful. But the file generated in outbox has no rows.

      Thanks in advance.

       

      Thanks,

      Pravallika

        • 1. Re: Zero Kb export file is getting created when trying to load data into planning via FDMEE
          SH_INT

          Are there valid records in the dataset i.e. there is at least one record without IGNORE in the intersection? Does anything get loaded to Planning? What does the log say?

          • 2. Re: Zero Kb export file is getting created when trying to load data into planning via FDMEE
            3254686

            Yes, there are valid records in dataset.

             

            Log file -

             

             

            2016-11-28 00:14:58,762 INFO  [AIF]: Total Data Rows available for Export to Target: 7779

            ..........

            2016-11-28 00:14:58,934 DEBUG [AIF]: app id:27, app type:HPL, multiCurrencyFlag:true, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL

            2016-11-28 00:14:58,934 INFO  [AIF]: LOAD_METHOD:ESSFILE, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, BATCH_SIZE:10000, PREFIX_DIM_DUPLICATE_MEM:true

            2016-11-28 00:14:58,934 DEBUG [AIF]: GlobalUserForAppAccess from Profile: admin

            2016-11-28 00:14:58,934 INFO  [AIF]: Cloud Mode: NONE, Resolved user name for application access: admin

            2016-11-28 00:15:01,746 DEBUG [AIF]: updateMultiCurrencyProperties - BEGIN

            2016-11-28 00:15:06,996 DEBUG [AIF]: Currency Properties Exist for Planning Application: FPACORP

            2016-11-28 00:15:06,996 DEBUG [AIF]: Number of existing multi-currency property rows deleted: 123

            2016-11-28 00:15:06,996 DEBUG [AIF]: Base Currency for Application: USD

            2016-11-28 00:15:07,199 DEBUG [AIF]: Number of multi-currency property rows inserted: 123

            2016-11-28 00:15:07,199 DEBUG [AIF]: updateMultiCurrencyProperties - END

            2016-11-28 00:15:07,231 DEBUG [AIF]: Obtained connection to essbase cube: PnL

            2016-11-28 00:15:07,231 DEBUG [AIF]: ACCOUNT,ENTITY,UD1,UD2,UD3,UD4,CURRENCY,SCENARIO,YEAR,PERIOD,HSP_Rates,AMOUNT

            FROM AIF_HS_BALANCES_HPL_MC_V

            WHERE LOADID = 6436

            2016-11-28 00:15:07,231 INFO  [AIF]: Creating data file: \\EPMSYSD\Oracle\FDMEE\FPACORP/outbox/FPACORP_6436.dat

            2016-11-28 00:15:11,668 INFO  [AIF]: Data file creation complete

             

            Import, Validate and export stages are successful, there are no errors in log file.

             

            There are valid rows for export, but a blank file is getting generated.

            Target is multi-currency planning application, source is Teradata table loaded through open interface source type.

             

             

            Thanks,

            Prav

            • 3. Re: Zero Kb export file is getting created when trying to load data into planning via FDMEE
              Francisco Amores

              what do you get when you run sql query?

               

              SELECT * from AIF_HS_BALANCES_HPL_MC_V where loadid = x

               

              x is your loadid