8 Replies Latest reply on Sep 5, 2013 7:56 AM by Anthony Dodds

    Import issue

    904244

      Hi Gurus,

      Here is my requirement.I am exporting(full export of level0) file then defrag db ,again building the dimensions then refresh fnally  want to load exported(level0) file back.for that i used the following script.

      To Export:

      SET DATAEXPORTOPTIONS
        {
      DataExportLevel "LEVEL0";
      DataExportDecimal  6;
      DataExportOverwriteFile ON;
      DataExportRelationalFile ON;
      };
      DATAEXPORT "File"  ","  "E:\HYPERION\logs\export.err";


      I am getting exported file.and i would like to import again.that time i am getting warning given below.

      import database 'APPNAME'.'DBNAME' data from local text data_file 'E:\HYPERION\DATA\export.txt' using server rules_file 'loadplan' on error write to 'E:\HYPERION\logs\export.err';

      statement executed with warnings
      No data values modified by load of this data file
      there were errores in E:\HYPERION\logs\export.err


      can you pls suggest.