4 Replies Latest reply: Nov 12, 2012 1:53 PM by Howard (... in Training) RSS

    Application Export Stops after 1Mb

    Mike Mac
      Hi

      I'm trying to export a smallish application on a local DB - +/- 3 Mb and no matter which browser I use whether I reboot etc. the export stops after 1 Mb.

      DB is local on workstation.
      Win 7 Pro 64Bit, DB is 11.2 - APEX version 4.1.1 running the EPG listener.
      Running Kaspersky Internet security - up to date - scan shows no viruses.

      This exact configuration has been working perfectly - including many exports imports etc. - for months.

      I haven't loaded any new software recently.

      The export starts fine and completes with no errors, but only exports just on 1mb (1023 kb) of the sql file.

      I've rebooted the entire workstation, tried IE, Firefox and Chrome browsers - they all behave the same and only download 1Mb of export file when the full application is about 3Mb.

      Any ideas?

      Thanks in advance

      Mike

      Edited by: Mike Mac on Nov 8, 2012 12:13 PM
        • 1. Re: Application Export Stops after 1Mb
          Mike Mac
          Hi

          I have now copied the database to an XP maching - same version, and the application export fails in exactly the same way.

          This happens running the browser on the DB workstation and also with the browser on a networked workstation.

          Any ideas?

          Thanks

          Mike
          • 2. Re: Application Export Stops after 1Mb
            Howard (... in Training)
            Mike,

            Did you check your scripts quota?

            Home > SQL Workshop > SQL Scripts > Script Quotas

            My Script Quota in Bytes "Maximum Script Size:" was set 500,000.

            May God Bless You,.
            Howard
            • 3. Re: Application Export Stops after 1Mb
              Mike Mac
              Hi Howard

              Thanks for the reply.

              Does the script quota really limit the size of an application export?

              On other instances I have applications that export more than 20 Mb.

              I have increased the maximum script size to 50Mb - this doesn't help - the problem remains - only 1 Mb of export file is saved.

              Mike
              • 4. Re: Application Export Stops after 1Mb
                Howard (... in Training)
                Mike Mac wrote:

                Does the script quota really limit the size of an application export?

                On other instances I have applications that export more than 20 Mb.

                I have increased the maximum script size to 50Mb - this doesn't help - the problem remains - only 1 Mb of export file is saved.

                Mike
                Perhaps that's not the problem. You tried various browsers and I assume you've checked freespace. Do you have another large appl. you can export as a test. Can you copy the offending one, delete some pages, etc. and see if that "edited" one also fails at 1023 KB?

                Howard

                Mike: What have you found out?

                Edited by: Howard (DBA in Training) on Nov 12, 2012 2:52 PM