This discussion is archived
0 Replies Latest reply: Sep 19, 2013 12:18 PM by 12495df0-a700-4130-99d2-42d3956a931f RSS

RESTful web services not working (but APEX working fine)

12495df0-a700-4130-99d2-42d3956a931f Newbie
Currently Being Moderated

Hello All,
I recently upgraded our APEX servers from APEX 4.2.2 to 4.2.3. At the same time I upgraded the APEX Listener instances. We were using an older version of the listener in standalone mode but downloaded the latest version ( and deployed it into Glassfish (open source edition). Since making the changes APEX works fine in general but RESTful web services have stopped working.
In our environment we have 8 different databases all running APEX. We are using a single instance of the APEX listener for all the databases, each with its own database settings. We ran apex_rest_config.sql (from the 4.2.3 full install files) to make sure that was up to date. We configured the database settings in the listener so that the passwords for APEX_REST_PUBLIC_USER and APEX_LISTENER are correct. We know the URL mappings are set correctly because APEX works fine.
When we try the test button in APEX for our web services we get a 404 error with the following output:


Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=databaseabcdef, _regex=null, _workspaceIdentifier=schemaabcdef, _failed=false, _lastUpdate=-1, _template=/databaseabcdef/, _type=BASE_PATH]
Applied database connection info
Attempting to process with PL/SQL Gateway
Not processed as PL/SQL Gateway request
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path has one path segment, continuing processing
No Tenant Principal established yet, continuing processing
APEX_LISTENER pool exists, continuing processing
No matching tenant found for: test, cannot dispatch
No candidate found for: GET test/hr/empinfo/ in context: http://host/apex/databaseabcdef/
WebException [statusCode=404]
 at oracle.dbtools.rt.web.WebException.webException(
 at oracle.dbtools.rt.web.WebException.notFound(
 at oracle.dbtools.rt.web.RequestDispatchers.dispatch(
 at oracle.dbtools.rt.web.HttpEndpointBase.restfulServices(
 at oracle.dbtools.rt.web.HttpEndpointBase.service(
 at javax.servlet.http.HttpServlet.service(
 at org.apache.catalina.core.StandardWrapper.service(
 at org.apache.catalina.core.StandardWrapperValve.invoke(
 at org.apache.catalina.core.StandardContextValve.invoke(
 at org.apache.catalina.core.StandardPipeline.doInvoke(
 at org.apache.catalina.core.StandardPipeline.invoke(
 at com.sun.enterprise.web.WebPipeline.invoke(
 at org.apache.catalina.core.StandardHostValve.invoke(
 at org.apache.catalina.connector.CoyoteAdapter.doService(
 at org.apache.catalina.connector.CoyoteAdapter.service(
 at org.glassfish.grizzly.http.server.HttpHandler.runService(
 at org.glassfish.grizzly.http.server.HttpHandler.doHandle(
 at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(
 at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(
 at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(
 at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(
 at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(
 at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(
 at org.glassfish.grizzly.ProcessorExecutor.execute(
 at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(
 at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(
 at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(
 at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(
 at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$
 at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(
 at org.glassfish.grizzly.threadpool.AbstractThreadPool$
 at Source)


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