3 Replies Latest reply: Dec 10, 2012 4:41 AM by Patrick Wolf-Oracle RSS

    Oracle Apex Websheet - '???' Javascript Error on clicking 'Apply Changes'

    978580
      At my organization we are using Apex Websheets for maintaining our wiki. During editing of page content, when 'Apply Changes' button is clicked, the browser often gives javascript alert showing the following message:



      Alert box title: Message from webpage

      Alert box message: ???



      Once this error occurs there is no way to save the changes other than to press 'Cancel' button and redo these changes again (with the hope that this error will not recur this time). Has anybody faced the similar problem or this is unique to our environment? Kindly suggest any workaround or solution.


      Server/Client Configuration:

      - Oracle Linux 32-bit

      - Oracle 11g Release1 (11.1.0.7)

      - Application Express 4 (4.1.1.00.23)

      - Tested in Internet Explorer 8 (8.0.7600.16385) and Firefox 17 (17.0.1) on Windows 7 32-bit
        • 1. Re: Oracle Apex Websheet - '???' Javascript Error on clicking 'Apply Changes'
          Patrick Wolf-Oracle
          Hi,

          are you able to reproduce this error at will? If you use Firefox it would be interesting what you see in Firebug when you submit the page and when you get the JavaScript error.
          In the Network pannel you should see an AJAX request which is issues in the background. The text in the response would be of interest to diagnose the error.

          Regards
          Patrick
          -----------
          My Blog: http://www.inside-oracle-apex.com
          APEX Plug-Ins: http://apex.oracle.com/plugins
          Twitter: http://www.twitter.com/patrickwolf
          • 2. Re: Oracle Apex Websheet - '???' Javascript Error on clicking 'Apply Changes'
            978580
            Thanks for looking into the issue.

            The error seems to be random. However one thing that i have observed is that the probability of occurrence increases with the size of change.

            Firebug shows the following information:

            NetworkError: 404 Not found - http://dap:8080/apex/wwv_flow.show

            XHR:Timeline shows that all the time invested was in waiting phase. We are using EPG with Shared Servers set to 100.

            Phase         Start Time    Elapsed Time
            DNS Lookup 0 0
            Connection 0 0
            Sending 0 0
            Waiting 0 453 ms
            Receiving +453 ms 0

            Other related information is

            Request Headers:
            Accept     */*
            Accept-Encoding     gzip, deflate
            Accept-Language     en-US,en;q=0.5
            Cache-Control     no-cache
            Connection     keep-alive
            Content-Length     24392
            Content-Type     application/x-www-form-urlencoded; charset=UTF-8
            Cookie     WWV_CUSTOM-F_3532631184348548_500=4A52C3076702A137DF66C201F6C82E3C; PUBLIC_-NO_COOKIE-=2413670114769401; LOGIN_USERNAME_COOKIE=moiz8711; WWV_CUSTOM-F_3532631184348548_800=7A516AC96C1AA2A801E41A6E7210BE21; ORA_WWV_WS_LANG_TERRITORY=en:AMERICA
            Host     dap:8080
            Pragma     no-cache
            Referer     http://dap:8080/apex/f?p=4900:930:2413670114769401:::930,P930_CONTENT:P930_SECTION_ID:275866862343483564146590430663216868253
            User-Agent     Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/20100101 Firefox/17.0
            X-Requested-With     XMLHttpRequest

            Response Headers:
            Content-Type     text/html
            Server     Oracle XML DB/Oracle Database
            Transfer-Encoding     chunked

            Response Body:
            <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
            <HTML><HEAD>
            <TITLE>404 Not found</TITLE>
            </HEAD><BODY><H1>Not found</H1>
            The requested URL /apex/wwv_flow.show was not found on this server</BODY></HTML>
            • 3. Re: Oracle Apex Websheet - '???' Javascript Error on clicking 'Apply Changes'
              Patrick Wolf-Oracle
              Hi,

              it would be interesting what the real cause of the 404 error is. Please see the following posting at http://www.inside-oracle-apex.com/oracle-apex-got-404-not-found-2/ to enable a debug logging for mod_plsql/EPG. In the comments you will find the instructions for EPG.

              Don't forget to turn it off again when you are done.

              Regards
              Patrick
              -----------
              My Blog: http://www.inside-oracle-apex.com
              APEX Plug-Ins: http://apex.oracle.com/plugins
              Twitter: http://www.twitter.com/patrickwolf