10 Replies Latest reply: Sep 9, 2013 9:19 AM by Tom Petrus RSS

    Interactive Report Actions Filter not responding

    user10473774

      We have several Interactive Reports implemented in our application.

       

      At some point in time, a few days ago, suddenly in ALL Interactive Reports of the application we have

      the effect that pressing the Actions button and then choosing the Filter option, just hangs and only

      displays the turning wheel at the top of the report.

       

      It looks like looping, waiting or something like this - it stays forever ...

       

      Even a simple Interactive Report based on "select * from dual" shows this effect.

       

      Any ideas? Can somebody please help?

       

      Thanks, Werner

        • 1. Re: Interactive Report Actions Filter not responding
          vincent_deelen

          Hi Werner,

           

          Sounds like something's wrong with your browsers'  JavaScript handling/settings. Some browser get updated in the background, so you don't need to do anything yourself to get unexpected behaviour

          Have you tested your application on different browsers?

           

          Regards,

          Vincent Deelen

          • 2. Re: Interactive Report Actions Filter not responding
            user10473774

            Hi Vincent,

             

            we are using IE (which is the standard in our company), but we tried Firefox (not a standard) - same effect.

            Our company is very strict with the IE standard - no chance to change to any other browser.

             

            And, you are right, IE updates are happening in the background all the time. Maybe one of these updates

            caused the problem.

             

            Do you see any chance to fix the Filter problem?

             

            Regards,

            Werner

            • 3. Re: Interactive Report Actions Filter not responding
              user10473774

              Hi Vincent,

               

              I just made another test - I created a new application inside the same workspace and create an Interactive

              Report - funny, the Actions Filter option works fine!!!

               

              Regards,

              Werner

              • 4. Re: Interactive Report Actions Filter not responding
                vincent_deelen

                Hi Werner,

                Well that is strange. What version of APEX are you running?

                You can try opening the report filter with a javascript call: "gReport.dialog2('SHOW_FILTER');" opens the filter in APEX 4.2.

                 

                Regards,

                Vincent

                • 5. Re: Interactive Report Actions Filter not responding
                  user10473774

                  Hi Vincent,

                   

                  we are using Apex 4.2.1.00.08 ....

                   

                  the javascript call brings the same problem ...

                   

                  Regards,

                  Werner

                  • 6. Re: Interactive Report Actions Filter not responding
                    Tom Petrus

                    Which IE version are you using?

                    What might help is to see what happens with the calls made to the database and see what error they report. It could be that you are getting an error page in HTML code instead of the filter HTML code.

                     

                    If you have IE9 (or above): load the page, press F12 to bring up dev tools. Go to the network tab. Click "start capturing". Now in your page go to actions > filter. Stop capturing.

                    What interests you is the call here with method POST  to WWV_FLOW.SHOW. Select that line and click "go to detailed view". Click the "Response body" tab. Take a look at it.  Maybe best to copy the code and paste it into a file and view it in a browser (unsure if that works) or format the code.

                     

                    Alternatively, just to debug this issue and if you do not have IE9 or above: get Chrome or get the Firebug addon for Firefox. Their tools are better suited.

                    Chrome: Press F12 to bring up the console. Open the Network tab. Click actions > filter. View the latest entry in the network tab that points to wwv_flow.show. Click it and it will open the details up. Now you can click the preview tab to see what is returned - which is handy when unformatted html is returned.

                    Firebug: Press F12 and go to the console tab. Now do the actions > filter. You'll see a line (or lines) pop up (POST GET GET eg). Select the POST to wwv_flow.show. Click the HTML tab and preview.

                    • 7. Re: Interactive Report Actions Filter not responding
                      user10473774

                      We are using IE 9 and followed your first approach ...

                       

                      When opening the file with the saved HTML code the filter page appears, but with the message

                       

                      "Internet Explorer restricted this webpage from running scripts or ActiveX controls. Blocked content"

                       

                      So, do we have a too restricted IE 9 settings problem? Do you know which setting we have to change?

                       

                      Thanks for your help.

                       

                      Regards,

                      Werner

                      • 8. Re: Interactive Report Actions Filter not responding
                        Tom Petrus

                        - Go to the internet options of IE and check the security tab, see what it is set to. I'm not sure this is a related issue and might just be because you're trying to run that html in a seperate file. It'd be weird for this to be a security issue if you have no issue with newly-created IRs. Good to know that the filter html is there though. That html contains script tags but shouldn't be an issue (again, since newly created ones raise no error).

                        Maybe I went a bit overboard with the network capture - can you simply check the Console and Script tabs in the developer tools after you've done actions > filter. Any warnings or errors (red line)?

                        I'm taking some stabs in the dark here though!

                        • 9. Re: Interactive Report Actions Filter not responding
                          user10473774

                          I can see these error message under Console and Script tab:

                           

                          SCRIPT5007: Unable to delete property 'maxDate': object is null or undefined 

                          desktop_all.min.js?v=4.2.1.00.08, line 2 character 11496

                           

                           

                          SCRIPT257: Could not complete the operation due to error 80020101.

                          desktop_all.min.js?v=4.2.1.00.08, line 2 character 11496

                           

                          I am far away from understanding the meaning and consequences of these messages?

                           

                          Do you?

                          • 10. Re: Interactive Report Actions Filter not responding
                            Tom Petrus

                            That is ugly. I think this is an error from the widget.datepicker.js file where it tries to execute

                            delete lLocale.maxDate;
                            

                            and fails because the locale has not been instantiated. This locale instantiation should occur from 1 of the 2 script files added by the get filter call.

                            Unsure how or why. Do you know whether you have any custom javascript running for your IR pages?

                             

                            - To make sure the error is where it is I think: log in as developer, run the page. Enable debug. Do actions > filter. Go back to the browser developer tools and look at the maxdate error again. It should no longer say "desktop_all.min.js" for filename but a more specific file.

                            - When you capture traffic in the dev tools in ie (rerun it, start capture before clicking actions, stop capturing after you've clicked filter): what files does it mention?

                            For example, I get these:

                            /pls/apex/wwv_flow.showPOST
                            /l/libraries/jquery-ui/1.8.22/ui/i18n/oracle/jquery.ui.datepicker-en-us.jsGET
                            /l/libraries/apex/minified/widget.datepicker.min.js?v=4.2.2.00.11GET

                            (The locale initializations are in that second file normally.)