6 Replies Latest reply: Feb 7, 2013 11:21 PM by abroshan-Oracle RSS

    Export Data from EAS console to a Mapped Drive in Server

    814832
      Hi All,
      I have one query regarding the export of data from EAS console:
      Can we export data to the Mapped drive from the EAS console?
      Is it possible & how can this happen?
      We have mapped our local drives to the server & tried to export the data from EAS console to that mapped drive. The process got failed. Could you provide the information why it go failed with Mapped drive.
      Waiting for your update.

      Thanks in Advance
        • 1. Re: Export Data from EAS console to a Mapped Drive in Server
          Prabhas
          811829 wrote:
          Hi All,
          I have one query regarding the export of data from EAS console:
          Can we export data to the Mapped drive from the EAS console?
          Is it possible & how can this happen?
          We have mapped our local drives to the server & tried to export the data from EAS console to that mapped drive. The process got failed. Could you provide the information why it go failed with Mapped drive.
          Waiting for your update.

          Thanks in Advance
          Do you mean Exporting data from EAS to Network drives ??? I think that is not possible....But you can export it into local server from there you can copy by mapping to server from your computer.


          Edited by: Prabhas on Feb 6, 2013 5:18 PM

          Edited by: Prabhas on Feb 6, 2013 5:19 PM
          • 2. Re: Export Data from EAS console to a Mapped Drive in Server
            Prabhas
            Go thru this and try...

            Error: 1005000 Ascii Backup: Failed to open

            I forgot to tell you ..Is your server login domain and system login domain same????If it is different your server side login only have read only access to your system..

            That may be cause of not exporting the file...

            Edited by: Prabhas on Feb 6, 2013 5:26 PM

            Edited by: Prabhas on Feb 6, 2013 5:28 PM
            • 3. Re: Export Data from EAS console to a Mapped Drive in Server
              814832
              Hi,
              Thanks for your reply.

              I have checked the url.
              I have given the export command in maxl script as below:

              export database 'Sample'.'Basic' all data to data_file '\\\\10.14.193.57\\CDB\\sj013341\\data\\exp_data\\Basic.txt';


              But its throwing an error:
              Error-1005000-Ascii Backup: failed to open [\\10.14.193.57\CDB\sj013341\data\exp_data\Basic.txt';]

              Could any one please help on this to export the data to the Mapped drive?
              • 4. Re: Export Data from EAS console to a Mapped Drive in Server
                Prabhas
                Hi...

                Check whether user able to copy any file to mapped drive manually or not...If no errors...follow below steps...
                -----------------------------------------------------------------------------------------------------------------

                1.Maxl script:test.msh

                login username password on Server;

                export database 'Sample'.'basic' level0 data to server data_file 'D:\Test\level0.txt';

                logout;
                ---------------------------------------------------------------------------------------------------------------
                2. Batch file


                echo on

                C:\Hyperion\Essbase\bin\essmsh.exe D:\\myscripts\\test.msh

                @echo off

                Xcopy D:\\Test\*.* \\Ipaddress\Test\*.*;
                echo exit;
                --------------------------------------------------------------------------------------------------------------

                Edited by: Prabhas on Feb 8, 2013 9:11 AM

                Edited by: Prabhas on Feb 8, 2013 9:12 AM
                • 5. Re: Export Data from EAS console to a Mapped Drive in Server
                  Prabhas
                  Make sure user must have write access to shared file (mapped drive)..
                  • 6. Re: Export Data from EAS console to a Mapped Drive in Server
                    abroshan-Oracle
                    There are 3 possible solutions:

                    1. Export locally by typing the name of a text file.
                    DATABASE -> EXPORT -> SERVER FILE NAME

                    2. Make sure you have permission to write to a NTFS file system that is mapped locally from another server.
                    Test creating a file from outside of Essbase.

                    3. If you to have permission to create a file, then the folders must exist.
                    If you are writing to \APP\anyname.txt, then the APP folder must exist on the remote server.