2 Replies Latest reply on Apr 7, 2016 7:43 PM by Kris Rice-Oracle

    ORACLE REST DATA SERVICES error (404)

    Alex.V-Oracle

      Hello ,

      please help with the following REST issue,

       

      i have :

      Oracle DB 11.2.0.4.0

      Apex 5.0.2.

      ords. 3.0.4.

       

      running ords in standalone mode (java -jar ords.war standalone)

      APEX related schemas created and configured

       

      USERNAME

      ------------------------------

      APEX_REST_PUBLIC_USER

      APEX_PUBLIC_USER

      APEX_LISTENER

      APEX_050000

       

       

      I've then created a new workspace named dragos_apex_ws, and tried to "test" oracle.example.hr RESTful Services .... but it fails with 404 Not found error

      for example employeesfeed :

       

      http://localhost:8080/ords/dragos_apex_ws/hr/employeesfeed/

       

      See below debug trace

       

      Thank you !

       

       

      Debug trace :

      mapped request using: /dragos_apex_ws/* to: APEX:apex_rt.DRAGOS_APEX_WS, id=1654440014145133

       

      Could not find any dispatcher to handle request:

      --Attributes--

      apex.diagnostic.context = ...

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

      oracle.dbtools.http.ecid = mflS2zqNDo9PCO5GwHHw6A..

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

      --Attributes--

      GET /ords/dragos_apex_ws/hr/employeesfeed/ HTTP/1.1

      Host: localhost

      Cookie: ORA_WWV_USER_102266077708442=ORA_WWV-U7Ao4lv98LAluo9gHZIswP1h; ORA_WWV_REMEMBER_UN=APEX_ADMIN:dragos_apex_ws

      Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

      User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0

      Referer: http://localhost:8080/ords/f?p=4850:9:9576338990402:::9:P9_ID,ACTIVE_NODE:1655769935145246,1655769935145246

      Connection: keep-alive

      Host: localhost:8080

      Accept-Language: en-US,en;q=0.5

      Accept-Encoding: gzip, deflate

       

       

      HttpInputOverHTTP@76825ec6

       

      mapped request using: /dragos_apex_ws/* to: APEX:apex_rt.DRAGOS_APEX_WS, id=1654440014145133

       

      Could not find any dispatcher to handle request:

      --Attributes--

      apex.diagnostic.context = ...

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

      oracle.dbtools.http.ecid = mflS2zqNDo9PCO5GwHHw6A..

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

      --Attributes--

      GET /ords/dragos_apex_ws/hr/employeesfeed/ HTTP/1.1

      Host: localhost

      Cookie: ORA_WWV_USER_102266077708442=ORA_WWV-U7Ao4lv98LAluo9gHZIswP1h; ORA_WWV_REMEMBER_UN=APEX_ADMIN:dragos_apex_ws

      Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

      User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0

      Referer: http://localhost:8080/ords/f?p=4850:9:9576338990402:::9:P9_ID,ACTIVE_NODE:1655769935145246,1655769935145246

      Connection: keep-alive

      Host: localhost:8080

      Accept-Language: en-US,en;q=0.5

      Accept-Encoding: gzip, deflate

       

       

      HttpInputOverHTTP@76825ec6

       

      Stack Trace

       

      DispatcherNotFoundException [statusCode=404, reasons=[]]

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

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

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

      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:83)

      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:82)

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

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

      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:790)

      at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:751)

      at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:566)

      at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:219)

      at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)

      at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:498)

      at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)

      at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)

      at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)

      at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)

      at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)

      at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:98)

      at org.eclipse.jetty.server.Server.handle(Server.java:461)

      at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:284)

      at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)

      at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)

      at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)

      at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)

      at java.lang.Thread.run(Unknown Source)

       

      ******************************************************

      content of defaults.xml configuration file .........................not sure what are these security.crypto.* entries and if i should have (or not) here entries like db.username and db.password......

       

       

       

      <?xml version="1.0" encoding="UTF-8" standalone="no"?>

      <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

      <properties>

      <comment>Saved on Fri Mar 18 16:35:48 EET 2016</comment>

      <entry key="cache.caching">false</entry>

      <entry key="cache.directory">/tmp/apex/cache</entry>

      <entry key="cache.duration">days</entry>

      <entry key="cache.expiration">7</entry>

      <entry key="cache.maxEntries">500</entry>

      <entry key="cache.monitorInterval">60</entry>

      <entry key="cache.procedureNameList"/>

      <entry key="cache.type">lru</entry>

      <entry key="db.hostname">localhost</entry>

      <entry key="db.port">1521</entry>

      <entry key="db.servicename">x240orcl2.ro.oracle.com</entry>

      <entry key="debug.debugger">true</entry>

      <entry key="debug.printDebugToScreen">true</entry>

      <entry key="error.keepErrorMessages">true</entry>

      <entry key="error.maxEntries">50</entry>

      <entry key="jdbc.DriverType">thin</entry>

      <entry key="jdbc.InactivityTimeout">1800</entry>

      <entry key="jdbc.InitialLimit">3</entry>

      <entry key="jdbc.MaxConnectionReuseCount">1000</entry>

      <entry key="jdbc.MaxLimit">10</entry>

      <entry key="jdbc.MaxStatementsLimit">10</entry>

      <entry key="jdbc.MinLimit">1</entry>

      <entry key="jdbc.statementTimeout">900</entry>

      <entry key="log.logging">true</entry>

      <entry key="log.maxEntries">500</entry>

      <entry key="misc.compress"/>

      <entry key="misc.defaultPage">apex</entry>

      <entry key="security.crypto.enc.password">9dXEIpaKVWkmw4xvufHm5w..</entry>

      <entry key="security.crypto.mac.password">ZyAEbAwQnNbCsHSgRogNKA..</entry>

      <entry key="security.disableDefaultExclusionList">false</entry>

      <entry key="security.maxEntries">2000</entry>

      <entry key="security.verifySSL">false</entry>

      </properties>