This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Jan 29, 2013 2:04 AM by 987765 RSS

Apex listener 2 - blank page loaded

tomvdduin Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    ReneW. Explorer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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
    ReneW. Explorer
    Currently Being Moderated
    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
    ReneW. Explorer
    Currently Being Moderated
    Update: Using Apex Listener 2.0 with a 11G database gives no problems.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points