1 2 Previous Next 19 Replies Latest reply: Jan 29, 2013 4:04 AM by JasG RSS

    Apex listener 2 - blank page loaded

    tomvdduin
      Hi all,

      I installed the Apex Listener 2 production (2.0.0.354.17.05) on Glassfish 3.1.2.2, build 5. It's got deployed correct, I've followed all the necessary steps found in the installation and configuration guide. But when I enter the url: http://server:8080/apex, all I see is a blank page. I tried adding a second database, but using the url http://server:8080/apex/zeno (the name of the database is zeno), I also see a blank page.

      There aren't any logfiles made when I enter the above urls. In sql developer, I checked the log options, but the logs inside SQL developer are empty, and the Glassfish logs doesn't seem to have logged an error somewhere.

      When I stop the Glassfish service, there are no Apex Listener connections to my database. When I start the service, three connections are made; so the db settings must be good?

      Does anyone have a clue what's wrong?

      Regards,
      Tom
        • 1. Re: Apex listener 2 - blank page loaded
          tomvdduin
          Also, when deployed as standalone, also a blank page is showed.

          This is the console output when starting standalone:

          D:\oracle\apex_listener.2.0.0.354.17.05>java -jar apex.war standalone --port 8889
          Dec 24, 2012 2:21:07 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
          INFO: Using configuration folder: D:\oracle\apex_listener.2.0.0.354.17.05\config\apex
          Dec 24, 2012 2:21:07 PM oracle.dbtools.standalone.Standalone execute
          INFO: NOTE:

          Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.

          Dec 24, 2012 2:21:07 PM oracle.dbtools.standalone.Standalone execute
          INFO: Starting standalone Web Container in: D:\oracle\apex_listener.2.0.0.354.17.05\config\apex
          Dec 24, 2012 2:21:07 PM oracle.dbtools.standalone.Deployer deploy
          INFO: Will deploy application path = D:\oracle\apex_listener.2.0.0.354.17.05\config\apex\apex\WEB-INF\web.xml
          Dec 24, 2012 2:21:07 PM oracle.dbtools.standalone.Deployer deploy
          INFO: Deployed application path = D:\oracle\apex_listener.2.0.0.354.17.05\config\apex\apex\WEB-INF\web.xml
          Dec 24, 2012 2:21:07 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
          INFO: Using configuration folder: D:\oracle\apex_listener.2.0.0.354.17.05\config\apex
          Configuration properties for: apex
          apex.docTable=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$
          apex.excel2collection=false
          apex.excel2collection.name=
          apex.excel2collection.onecollection=true
          apex.excel2collection.useSheetName=false
          apex.extensions=
          cache.caching=false
          cache.directory=/tmp/apex/cache
          cache.duration=days
          cache.expiration=7
          cache.maxEntries=500
          cache.monitorInterval=60
          cache.procedureNameList=
          cache.type=lru
          db.connectionType=basic
          db.customURL=
          db.hostname=localhost
          db.password=******
          db.port=1521
          db.servicename=ZENO
          db.sid=orcl
          db.tnsAliasName=
          db.tnsDirectory=
          db.username=APEX_PUBLIC_USER
          debug.debugger=false
          debug.printDebugToScreen=false
          error.keepErrorMessages=true
          error.maxEntries=50
          icap.port=
          icap.server=
          jdbc.DriverType=thin
          jdbc.InactivityTimeout=1800
          jdbc.InitialLimit=3
          jdbc.MaxConnectionReuseCount=1000
          jdbc.MaxLimit=10
          jdbc.MaxStatementsLimit=10
          jdbc.MinLimit=1
          jdbc.statementTimeout=900
          log.logging=false
          log.maxEntries=50
          log.procedure=false
          misc.compress=
          misc.defaultPage=apex
          procedure.postProcess=
          procedure.preProcess=
          security.disableDefaultExclusionList=false
          security.exclusionList=
          security.inclusionList=
          security.maxEntries=2000
          security.requestValidationFunction=
          security.validationFunctionType=plsql
          security.verifySSL=false
          sqldev.description=
          sqldev.name=apex
          sqldev.version=3.2.20.09.87
          Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0
          Dec 24, 2012 2:21:09 PM oracle.dbtools.rt.web.SCListener contextInitialized
          INFO: Oracle Application Express Listener initialized
          Application Express Listener version : 2.0.0.354.17.06
          Application Express Listener server info: Grizzly/1.9.49

          Dec 24, 2012 2:21:09 PM com.sun.grizzly.Controller logVersion
          INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 12/24/12 2:21 PM
          Dec 24, 2012 2:21:09 PM oracle.dbtools.standalone.Standalone execute
          INFO: http://localhost:8889/apex started.

          Edited by: tomvdduin on 24-dec-2012 14:26
          • 2. Re: Apex listener 2 - blank page loaded
            mnoor
            I am also facing the same problem. The issue seems to be with routing rules. If I directly access any application using f?p=12:101 type URL then I am able to access both instances of apex configured on different DB. But workspace login is still missing. I am trying to find the way out. If you solve this problem please let me know too.

            Edited by: muzzamil on Dec 26, 2012 8:48 PM
            • 3. Re: Apex listener 2 - blank page loaded
              mnoor
              I just found the solution. The issue was with routing rules. Use URL Path as routing Rule type and in Routing rule mention complete URL as http://example.com/apex/sales where /apex is the context path for apex listener on example.com and sales is the settings name in URL settings of connection. Schema for restful services is optional.


              Now using http://example.com/apex/sales you will be able to access the workspace login page and no blank page will be shown.
              • 4. Re: Apex listener 2 - blank page loaded
                tomvdduin
                Hi (?),

                Thanks! That was the problem. I assumed that jou don't have to enter any routing rules, that when the database name you give the connection is used in the url. But when I entered the routing rule, it works like a charm.

                Regards,
                Tom
                • 5. Re: Apex listener 2 - blank page loaded
                  tomvdduin
                  Hmm. It seems it works for about 10 seconds, but after 10 seconds, all it gives is a blank page (again). Even when I enter a direct (valid) url, the page is blank. After I restarted Glassfish, it works again for 10 seconds.

                  My configuration is now as follows:
                  h1. Global settings/connections
                  - Username: apex_public_user
                  - password: correct one!
                  - connection type: basic
                  - hostname: localhost
                  - port: 1521
                  - SID: ZENO
                  h1. Database settings:
                  h2. database apex
                  - Username: apex_public_user
                  - password: correct one!
                  - connection type: basic
                  - hostname: localhost
                  - port: 1521
                  - SID: ZENO
                  h3. url mapping
                  - Rule type: Request path
                  - Routing table: /socho

                  It occurs with both urls:
                  - http://server:8080/apex/f?p=102:2
                  - http://server:8080/apex/socho/f?p=102:2

                  There is no error in the server.log file, and also the 'error tracking' report in the apex listener configuration tool in sql developer states: The Application Express Listener does not contain any errors.

                  Edited by: tomvdduin on 27-dec-2012 12:05
                  • 6. Re: Apex listener 2 - blank page loaded
                    mnoor
                    Hi Tom!
                    You should try using URLPath in routing rules and give complete URL as mentioned in my earlier post.

                    Regards,
                    Muzzamil
                    • 7. Re: Apex listener 2 - blank page loaded
                      Nattu
                      Hi,

                      I also have the same issue, for me the link for the RESTful service is not working. After having configured Listener, I am able to login to apex. However, when clicking the TEST button on "Resource Handler" page on one of the RESTful services (The sample web service given by Oracle - oracle.example.hr) , listener throws error for the link http://localhost:8585/apex/natarajan/hr/empinfo/. My listener 2.0 is running as a stand alone mode on apex 4.2 and Oracle 11g.

                      I tried both Rule types "Request Path" and URL Path in Database Settings>apex (The context name) > Connections > RESTful Connections by giving the below.

                      For Request Path, I gave

                      i) /natarajan as Routing Rule
                      ii)/natarajan as Routing Rule and hr as schema for the RESTful services. Here "natarajan" is my workspace name and hr is the schema associated with the workspace.

                      For URL Path, as Muzammil suggested, I gave the full URL http://localhost:8585/apex/natarajan/hr/empinfo/.

                      Still it is giving the page 404 - not found error.
                      WebException [statusCode=404]
                           at oracle.dbtools.rt.web.WebException.webException(WebException.java:330)
                           at oracle.dbtools.rt.web.WebException.notFound(WebException.java:284)
                           at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:71)
                           at oracle.dbtools.rt.web.HttpEndpointBase.restfulServices(HttpEndpointBase.java:336)
                           at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:125)
                           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                           at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)
                           at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)
                           at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)
                           at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:65)
                           at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)
                           at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
                           at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)
                           at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
                           at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
                           at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
                           at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
                           at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
                           at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
                           at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
                           at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
                           at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
                           at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
                           at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
                           at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
                           at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
                           at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
                           at java.lang.Thread.run(Unknown Source)
                      Request to please find any possible issues with my configuratio and will greatly appreciate the help.

                      Note: I have posted this issue in another thread, RESTful web services throws page not found error in apex listener but found this one just now, so posting here as mine is also the same problem. I will close the other one as I get a solution.


                      Regards,

                      Natarajan

                      Edited by: Nattu on Jan 2, 2013 3:28 AM
                      • 8. Re: Apex listener 2 - blank page loaded
                        Nattu
                        I still couldn't resolve the issue, Any possible solution for this?

                        Also, I tried to generate the log by enabling the logging for the listener using options in SQL Developer. It does not generate any log report but just throws the error only on the browser.

                        Regards,

                        Natarajan
                        • 9. Re: Apex listener 2 - blank page loaded
                          noelk01469
                          Nattu,

                          I'm having the exact same issue. I haven't been able to get the Apex 2.0 listener to work as advertised. I wouldnt' think it should be this hard. I"m using Weblogic...

                          I can get 1 db connection to work but any other databases don't work or only work once then stop working the next time I restart WL without me even making changes. Not ready for production as far as I can tell..

                          Ken
                          • 10. Re: Apex listener 2 - blank page loaded
                            983057
                            hi
                            I am facing same the problem.
                            I have installed apex on port number 8080. and apex listener on port 9999 using standalone mode.
                            But apexlistener gives blank page.. please give me solution
                            • 11. Re: Apex listener 2 - blank page loaded
                              Rene W.
                              Came here to look for a solution for the same problem. Sometimes I get the login page but after that blank.
                              • 12. Re: Apex listener 2 - blank page loaded
                                Colm Divilly
                                Hi Folks,
                                could I ask all people reporting seeing an issue with blank pages to provide the following information

                                OS Version, DB Version, APEX Version

                                There seems to be some correlation between having multiple databases defined and seeing this problem, if you do have multiple databases defined can you also include your url-mapping.xml and also indicate whether you enabled RESTful Services for each database (<pool-name>rt.xml and <pool-name>al.xml exist in the conf folder).

                                Thanks,
                                Colm
                                • 13. Re: Apex listener 2 - blank page loaded
                                  Rene W.
                                  OS: Windows 7professional 64 bit SP1
                                  DB: 10.2.0.5
                                  Apex: 4.0.2 and 4.2.0 both give problems.
                                  No URL mapping, No RESTful services.

                                  Problem seems exactly the same as in this thread:
                                  blank screen after login listener hung
                                  • 14. Re: Apex listener 2 - blank page loaded
                                    Rene W.
                                    Update: Using Apex Listener 2.0 with a 11G database gives no problems.
                                    1 2 Previous Next