Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ords 3.0.2 and Apex 5.0.3 RestFul 404 Not Found Error

GerardApr 17 2016 — edited Apr 26 2016

Hi all,

Windows 10

Oracle Xe 11G R2

Apex 5.0.3

ORDS 3.0.2

Apache tomcat: 8.0.33

jdk1.8.0_77

I have several days with this problem and can't solve it, I can't see the RestFul services.

I started installing ORDS 3.0.3 and encountered the problem with RESTful services and then found this WARNING. DO NOT USE ORDS 3.0.3 with APEX. There must be a Bug in 3.0.3.351.13.24 regarding static Apex files. then decided to install ORDS 3.0.2 and the same problem remains. I'm already configured the RESTful service in the database and activate the ORDS logs.

Debug Trace

mapped request using: /dev/* to: APEX:apex_rt.DEV, id=1692550478763994

Could not find any dispatcher to handle request:

--Attributes--

apex.diagnostic.context = ...

ECID-Principal = ECIDPrincipal [ecid=UUfaaW0Z0MYSFb_aD3KVnw..]

oracle.dbtools.http.ecid = tW5njfpVhtlM9Y8YHoqX2w..

oracle.dbtools.common.di.Services = Request Scope

--Attributes--

GET /ords/dev/hr/employees/ HTTP/1.1

Host: localhost

host: localhost:8080

connection: keep-alive

accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

upgrade-insecure-requests: 1

user-agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.75 Safari/537.36

referer: http://localhost:8080/ords/f?p=4850:9:9578349730314:::9:P9_ID,ACTIVE_NODE:1701656917483436,1701656917483436

accept-encoding: gzip, deflate, sdch

accept-language: en-US,en;q=0.8,es-419;q=0.6,es;q=0.4

cookie: ORA_WWV_REMEMBER_UN=GMEONO:DEV; ORA_WWV_USER_103897191415857=ORA_WWV-kgwnO_O4pyTR1Y0EO1iT8u1Q

org.apache.catalina.connector.CoyoteInputStream@2f881ba5

mapped request using: /dev/* to: APEX:apex_rt.DEV, id=1692550478763994

Could not find any dispatcher to handle request:

--Attributes--

apex.diagnostic.context = ...

ECID-Principal = ECIDPrincipal [ecid=UUfaaW0Z0MYSFb_aD3KVnw..]

oracle.dbtools.http.ecid = tW5njfpVhtlM9Y8YHoqX2w..

oracle.dbtools.common.di.Services = Request Scope

--Attributes--

GET /ords/dev/hr/employees/ HTTP/1.1

Host: localhost

host: localhost:8080

connection: keep-alive

accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

upgrade-insecure-requests: 1

user-agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.75 Safari/537.36

referer: http://localhost:8080/ords/f?p=4850:9:9578349730314:::9:P9_ID,ACTIVE_NODE:1701656917483436,1701656917483436

accept-encoding: gzip, deflate, sdch

accept-language: en-US,en;q=0.8,es-419;q=0.6,es;q=0.4

cookie: ORA_WWV_REMEMBER_UN=GMEONO:DEV; ORA_WWV_USER_103897191415857=ORA_WWV-kgwnO_O4pyTR1Y0EO1iT8u1Q

org.apache.catalina.connector.CoyoteInputStream@2f881ba5

Stack Trace

DispatcherNotFoundException [statusCode=404, reasons=[]]

at oracle.dbtools.http.entrypoint.Dispatcher.choose(Dispatcher.java:84)

at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:94)

at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:123)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:73)

at oracle.dbtools.url.mapping.RequestMapperBase.doFilter(RequestMapperBase.java:53)

at oracle.dbtools.url.mapping.CompositeMapper$RequestMapperFilterChain.doFilter(CompositeMapper.java:144)

at oracle.dbtools.url.mapping.RequestMapperBase.doFilter(RequestMapperBase.java:53)

at oracle.dbtools.url.mapping.CompositeMapper.doFilter(CompositeMapper.java:37)

at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:89)

at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:86)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

at oracle.dbtools.http.locale.LocaleFilter.doFilter(LocaleFilter.java:60)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:71)

at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:75)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

at oracle.dbtools.http.ecid.ECIDFilter.doFilter(ECIDFilter.java:35)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

at oracle.dbtools.http.filters.Filters.filter(Filters.java:47)

at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:80)

at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:46)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:156)

at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:85)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2500)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2489)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

This post has been answered by Gerard on Apr 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2016
Added on Apr 17 2016
2 comments
1,622 views