9 Replies Latest reply on Nov 4, 2010 10:13 PM by ant7

    Interactive Reports not working with APEX listener

    Zeeshan BaiG
      Hi,

      I recently installed APEX listener on Glassfish and Tomcat to evaluate with OHS.

      But on both servers i am not able to run Interactive reports in 3 different browsers (IE, FireFox, Chrome), However the same application running smoothly using OHS.

      I configured APEX listener on Glassfish according to Installation guide. Can anyone suggest where to look on this issue, may be i missed some special security setting?

      Thanks,
      Baig
      http://baigsorcl.blogspot.com/
        • 1. Re: Interactive Reports not working with APEX listener
          Kris Rice-Oracle
          Do you have anything to look into? logs , errors, screenshots, anything?
          -kris
          • 2. Re: Interactive Reports not working with APEX listener
            Zeeshan BaiG
            Thanks

            I figured it that on localhost (where the apex listener is running) Interactive reports are running smoothly. Issue with Network client where do i have to check it.

            Here are the logs i m posting Tomcat logs......Glassfish i uninstall for a while. I know it is not supported but issue is same with both servers
            Aug 16, 2010 9:17:57 AM org.apache.catalina.core.ApplicationContext log
            INFO: ContextListener: contextInitialized()
            Aug 16, 2010 9:17:57 AM org.apache.catalina.core.ApplicationContext log
            INFO: SessionListener: contextInitialized()
            Aug 16, 2010 11:30:11 AM org.apache.catalina.core.ApplicationContext log
            INFO: SessionListener: contextDestroyed()
            Aug 16, 2010 11:30:11 AM org.apache.catalina.core.ApplicationContext log
            INFO: ContextListener: contextDestroyed()
            Aug 16, 2010 11:30:14 AM org.apache.catalina.core.ApplicationContext log
            INFO: ContextListener: contextInitialized()
            Aug 16, 2010 11:30:14 AM org.apache.catalina.core.ApplicationContext log
            INFO: SessionListener: contextInitialized()
            Aug 16, 2010 11:55:53 AM org.apache.catalina.core.StandardWrapperValve invoke
            SEVERE: Servlet.service() for servlet ModApex threw exception
            java.lang.IllegalStateException
                 at org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:407)
                 at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:308)
                 at oracle.dbtools.apex.OWA.downloadFile(OWA.java:297)
                 at oracle.dbtools.apex.hooks.postProcess.CachedItems.postProcess(CachedItems.java:54)
                 at oracle.dbtools.apex.hooks.ProcessorRegistry.postProcess(ProcessorRegistry.java:30)
                 at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:198)
                 at oracle.dbtools.apex.ModApex.doGet(ModApex.java:78)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
                 at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
                 at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
                 at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
                 at java.lang.Thread.run(Unknown Source)
            Aug 16, 2010 12:04:34 PM org.apache.catalina.core.StandardWrapperValve invoke
            SEVERE: Servlet.service() for servlet ModApex threw exception
            java.lang.IllegalStateException
                 at org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:407)
                 at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:308)
                 at oracle.dbtools.apex.OWA.downloadFile(OWA.java:297)
                 at oracle.dbtools.apex.hooks.postProcess.CachedItems.postProcess(CachedItems.java:54)
                 at oracle.dbtools.apex.hooks.ProcessorRegistry.postProcess(ProcessorRegistry.java:30)
                 at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:198)
                 at oracle.dbtools.apex.ModApex.doGet(ModApex.java:78)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
                 at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
                 at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
                 at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
                 at java.lang.Thread.run(Unknown Source)
            Aug 16, 2010 12:09:07 PM org.apache.catalina.core.StandardWrapperValve invoke
            SEVERE: Servlet.service() for servlet ModApex threw exception
            java.lang.IllegalStateException
                 at org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:407)
                 at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:308)
                 at oracle.dbtools.apex.OWA.downloadFile(OWA.java:297)
                 at oracle.dbtools.apex.hooks.postProcess.CachedItems.postProcess(CachedItems.java:54)
                 at oracle.dbtools.apex.hooks.ProcessorRegistry.postProcess(ProcessorRegistry.java:30)
                 at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:198)
                 at oracle.dbtools.apex.ModApex.doGet(ModApex.java:78)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
                 at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
                 at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
                 at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
                 at java.lang.Thread.run(Unknown Source)
            Aug 16, 2010 9:17:55 AM org.apache.catalina.core.AprLifecycleListener init
            INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
            Aug 16, 2010 9:17:55 AM org.apache.catalina.core.AprLifecycleListener init
            INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
            Aug 16, 2010 9:17:56 AM org.apache.coyote.http11.Http11AprProtocol init
            INFO: Initializing Coyote HTTP/1.1 on http-8080
            Aug 16, 2010 9:17:56 AM org.apache.coyote.ajp.AjpAprProtocol init
            INFO: Initializing Coyote AJP/1.3 on ajp-8009
            Aug 16, 2010 9:17:56 AM org.apache.catalina.startup.Catalina load
            INFO: Initialization processed in 982 ms
            Aug 16, 2010 9:17:56 AM org.apache.catalina.core.StandardService start
            INFO: Starting service Catalina
            Aug 16, 2010 9:17:56 AM org.apache.catalina.core.StandardEngine start
            INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
            Aug 16, 2010 9:17:56 AM org.apache.catalina.startup.HostConfig deployDescriptor
            INFO: Deploying configuration descriptor host-manager.xml
            Aug 16, 2010 9:17:56 AM org.apache.catalina.startup.HostConfig deployDescriptor
            INFO: Deploying configuration descriptor manager.xml
            Aug 16, 2010 9:17:56 AM org.apache.catalina.startup.HostConfig deployWAR
            INFO: Deploying web application archive apex.war
            Aug 16, 2010 9:17:56 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory docs
            Aug 16, 2010 9:17:56 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory examples
            Aug 16, 2010 9:17:57 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory i
            Aug 16, 2010 9:17:57 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory ROOT
            Aug 16, 2010 9:17:57 AM org.apache.coyote.http11.Http11AprProtocol start
            INFO: Starting Coyote HTTP/1.1 on http-8080
            Aug 16, 2010 9:17:57 AM org.apache.coyote.ajp.AjpAprProtocol start
            INFO: Starting Coyote AJP/1.3 on ajp-8009
            Aug 16, 2010 9:17:57 AM org.apache.catalina.startup.Catalina start
            INFO: Server startup in 1188 ms
            Aug 16, 2010 11:30:10 AM org.apache.coyote.http11.Http11AprProtocol pause
            INFO: Pausing Coyote HTTP/1.1 on http-8080
            Aug 16, 2010 11:30:10 AM org.apache.coyote.ajp.AjpAprProtocol pause
            INFO: Pausing Coyote AJP/1.3 on ajp-8009
            Aug 16, 2010 11:30:11 AM org.apache.catalina.core.StandardService stop
            INFO: Stopping service Catalina
            Aug 16, 2010 11:30:11 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
            SEVERE: The web application [/apex] registered the JBDC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
            Aug 16, 2010 11:30:12 AM org.apache.coyote.http11.Http11AprProtocol destroy
            INFO: Stopping Coyote HTTP/1.1 on http-8080
            Aug 16, 2010 11:30:12 AM org.apache.coyote.ajp.AjpAprProtocol destroy
            INFO: Stopping Coyote AJP/1.3 on ajp-8009
            Aug 16, 2010 11:30:13 AM org.apache.catalina.core.AprLifecycleListener init
            INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
            Aug 16, 2010 11:30:13 AM org.apache.catalina.core.AprLifecycleListener init
            INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
            Aug 16, 2010 11:30:13 AM org.apache.coyote.http11.Http11AprProtocol init
            INFO: Initializing Coyote HTTP/1.1 on http-8080
            Aug 16, 2010 11:30:13 AM org.apache.coyote.ajp.AjpAprProtocol init
            INFO: Initializing Coyote AJP/1.3 on ajp-8009
            Aug 16, 2010 11:30:13 AM org.apache.catalina.startup.Catalina load
            INFO: Initialization processed in 1012 ms
            Aug 16, 2010 11:30:13 AM org.apache.catalina.core.StandardService start
            INFO: Starting service Catalina
            Aug 16, 2010 11:30:13 AM org.apache.catalina.core.StandardEngine start
            INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
            Aug 16, 2010 11:30:13 AM org.apache.catalina.startup.HostConfig deployDescriptor
            INFO: Deploying configuration descriptor host-manager.xml
            Aug 16, 2010 11:30:14 AM org.apache.catalina.startup.HostConfig deployDescriptor
            INFO: Deploying configuration descriptor manager.xml
            Aug 16, 2010 11:30:14 AM org.apache.catalina.startup.HostConfig deployWAR
            INFO: Deploying web application archive apex.war
            Aug 16, 2010 11:30:14 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory docs
            Aug 16, 2010 11:30:14 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory examples
            Aug 16, 2010 11:30:14 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory i
            Aug 16, 2010 11:30:14 AM org.apache.catalina.startup.HostConfig deployDirectory
            INFO: Deploying web application directory ROOT
            Aug 16, 2010 11:30:14 AM org.apache.coyote.http11.Http11AprProtocol start
            INFO: Starting Coyote HTTP/1.1 on http-8080
            Aug 16, 2010 11:30:14 AM org.apache.coyote.ajp.AjpAprProtocol start
            INFO: Starting Coyote AJP/1.3 on ajp-8009
            Aug 16, 2010 11:30:14 AM org.apache.catalina.startup.Catalina start
            INFO: Server startup in 948 ms
            • 3. Re: Interactive Reports not working with APEX listener
              Kris Rice-Oracle
              I just posted a new version. Can you try this and see if your issue is fixed?
              -kris
              • 4. Re: Interactive Reports not working with APEX listener
                Zeeshan BaiG
                I upgraded to latest APEX patch but still not resolved...

                here are couple of screen shots from google chrome

                From Server (where apex listener is installed) The javascript is not giving any error so interactive reports are working
                http://i55.tinypic.com/2ngbe3m.jpg

                From client (my machine) Javascript is giving syntax error
                http://i51.tinypic.com/2vv8181.jpg


                May be its a issue with proxy server? All APEX pages are cache disabled in my app i faced HTTP Error 304 in the chrome inspect element section.
                • 5. Re: Interactive Reports not working with APEX listener
                  Zeeshan BaiG
                  In addition to that i noticed that Firefox is able to display interactive menus but with very long delay on the client machine.
                  • 6. Re: Interactive Reports not working with APEX listener
                    Patrick Wolf-Oracle
                    Hi Baig,

                    I think Kris ment that you install the newest APEX Listener version (1.0.2). I think you installed the patchset (4.0.1) for APEX

                    Regards
                    Patrick
                    -----------
                    My Blog: http://www.inside-oracle-apex.com
                    APEX 4.0 Plug-Ins: http://apex.oracle.com/plugins
                    Twitter: http://www.twitter.com/patrickwolf
                    1 person found this helpful
                    • 7. Re: Interactive Reports not working with APEX listener
                      Zeeshan BaiG
                      Patrick Wolf wrote:
                      Hi Baig,

                      I think Kris ment that you install the newest APEX Listener version (1.0.2). I think you installed the patchset (4.0.1) for APEX

                      Regards
                      Patrick
                      -----------
                      My Blog: http://www.inside-oracle-apex.com
                      APEX 4.0 Plug-Ins: http://apex.oracle.com/plugins
                      Twitter: http://www.twitter.com/patrickwolf
                      oops my mistake Thanks for clarification. i will try new apex listener tomorrow and will update this post.
                      • 8. Re: Interactive Reports not working with APEX listener
                        Zeeshan BaiG
                        Sorry for late response.

                        It was a firewall issue
                        • 9. Re: Interactive Reports not working with APEX listener
                          ant7
                          Can you give any more details about what with the firewall was the issue. I believe I may be running into the same issue and so far haven't been able to crack this nut.