4 Replies Latest reply on Dec 14, 2016 9:19 AM by Neruda from Italy

    Oracle REST Data Services - 404 Not found

    Neruda from Italy

      Hello dears.

      I am using for more than one year Oracle Apex 5.x with Oracle 11g and Apache Tomcat 7.0.

      Since yesterday all has worked very well but this morning, if I try to connect to Oracle Apex, is being showed the message "Oracle REST Data Services - 404 Not found".

       

      Then I enabled the tracing in ORDS by addind the following two rows in the file default.xml

       

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

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

       

      After restarning if I connect to APEX is being showed this:

       

       

      Debug Trace

      mapped request using: /* to: PLSQL:apex

       

      Could not find any dispatcher to handle request:

      --Attributes--

      nanoStart = 1481013800241

      apex.diagnostic.context = Attempting to process as a Dispatchable Service

       

      ECID-Principal = ECIDPrincipal [ecid=1kmnaQIjAuZBvDVgoPyOoA..]

      oracle.dbtools.http.ecid = U38PBxNhRzJmxG15MV65OQ..

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

      --Attributes--

      GET /ords/f?p=101:LOGIN_DESKTOP:::::: HTTP/1.1

      Host: apex-prod

      host: apex-prod:8080

      connection: keep-alive

      cache-control: max-age=0

      upgrade-insecure-requests: 1

      user-agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.99 Safari/537.36

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

      accept-encoding: gzip, deflate, sdch

      accept-language: it-IT,it;q=0.8,en-US;q=0.6,en;q=0.4,pt;q=0.2

      cookie: ORA_WWV_REMEMBER_UN=SAVERIO.MOLA:ws-segnalazioni; ORA_WWV_USER_103889354093289=ORA_WWV-EOC3FUYoeAgnxVngRn2nzydc; LOGIN_USERNAME_COOKIE=saverio.mola; ORA_WWV_APP_101=ORA_WWV-MzoB0yh1RqaFp7g_IVDWOCA-

       

      org.apache.catalina.connector.CoyoteInputStream@6d07a441

       

       

      Stack Trace

      NotFoundException [statusCode=404, reasons=[]]

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

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

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

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

        at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:82)

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

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

        at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:59)

        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.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:67)

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

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

        at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:61)

        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.AuthenticationFilter.authenticate(AuthenticationFilter.java:89)

        at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:62)

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

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

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

        at oracle.dbtools.url.mapping.URLMapping.doFilter(URLMapping.java:78)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)

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

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

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

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

        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

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

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

       

       

      Then in the instance of the database I wrote the following instruction:

       

      select username, account_status, lock_date, expiry_date from dba_users where username like '%APEX%';

       

      with the following result 

       

      USERNAME                       ACCOUNT_STATUS                   LOCK_DATE       EXPIRY_DA

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

      APEX_050000                    EXPIRED & LOCKED                 17-LUG-15       17-LUG-15                                                                      

                                                                                     

      APEX_030200                    EXPIRED & LOCKED                 17-LUG-15       17-LUG-15                                                                      

                                                                                     

      APEX_LISTENER                  EXPIRED                                          29-MAG-16                                                                      

                                                                                     

      APEX_PUBLIC_USER               EXPIRED                                          04-DIC-16                                                                      

                                                                                     

      APEX_REST_PUBLIC_USER          EXPIRED                                          06-GIU-16 

       

      Any suggestion will be appreciated. Thank you