Hi,
We have been running APEX for a number of years and have had APEX 5.0.2 and ORDS 3.0.3 installed for a couple of months with no problems.
Recently, I installed APEX 5.0.3 and ORDS 3.0.5 into the PDB on a new 12c RAC cluster. APEX works just fine, but any RESTful web service I try to run returns a 404 Not Found.
The environment is:
WebLogic 12.2.1.0.0
DB 12.1.0.2 (RAC)
APEX 5.0.3
ORDS 3.0.5 (instance deployed as "apexprod")
I believe the DB users are all installed and set up (I ran apex_rest_config.sql) and when ORDS starts up, it logs:
Jun 09, 2016 5:35:55 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Validating pool: |apex||
Jun 09, 2016 5:35:56 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: |apex|| is correctly configured
Jun 09, 2016 5:35:56 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Validating pool: |apex|al|
Jun 09, 2016 5:35:56 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: |apex|al| is correctly configured
Jun 09, 2016 5:35:56 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Validating pool: |apex|pu|
Jun 09, 2016 5:35:57 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: |apex|pu| is correctly configured
Jun 09, 2016 5:35:57 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Validating pool: |apex|rt|
Jun 09, 2016 5:35:57 PM oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: |apex|rt| is correctly configured
With debugging turned on, ORDS prints this on the error page:
404 Not Found
The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured
Debug Trace
[TE] url-mapping start: 2016-06-09T21:36:37.469Z duration: 11ms
[TE] GET /apexprod/ejc/cache_cover_image?date=all start: 2016-06-09T21:36:37.469Z duration: 11ms
[TE] url-mapping start: 2016-06-09T21:36:37.482Z duration: 8ms
Stack Trace
URLMappingNotFoundException [statusCode=404, reasons=[The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured]]
at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:78)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.locale.LocaleFilter.doFilter(LocaleFilter.java:59)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:46)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
...
The url-mapping.xml file contains (NOTE: I know this file may not be necessary. The error is the same with or without this file):
<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="apex" base-path="/ejc" workspace-id="EJCSEARCH" updated="2016-06-09T18:58:26.704Z"/>
</pool-config>
That workspace exists and has the RWS deployed in it.
Just as another, possibly unrelated data point. We also have three environments running ORDS 3.0.2 with no problems. I recently tried to upgrade one of them to ORDS 3.0.5 and got the same RWS problem. When I reverted back to 3.0.2, everything worked fine again.
Thanks for any suggestions! This has me completely baffled.