1 Reply Latest reply on Aug 31, 2018 12:21 PM by GregorM

    Error 404 after database + ords upgrade

    GregorM

      HI.

       

      The steps we did before hitting 404 error :

      1. database upgrade from 11.2.0.3 to 18c

      2. new ords 18.2 installation and configuration

       

      After starting Ords in standalone mode we get an "404 Not Found" error while accessing apex from browser.

       

      The "Debug Trace" is :

      =====================================================

      [TE] url-mapping start: 2018-08-30T15:55:23.558Z duration: 7ms

      Mapped request to mapping: |apex|pu|

      did not authenticate request

      mapped request using: /*:PL/SQL to: |apex|pu|

      Could not find any dispatcher to handle request:

      --Attributes--

      oracle.dbtools.http.ecid = bi6BZqpD9GIVKGLVaXH4sw..

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

      oracle.dbtools.common.di.Services = URL Mapped Scope

      oracle.dbtools.plugin.api.di.InstanceLocator = oracle.dbtools.common.di.Services$InstanceLocator@3b4e2012

      --Attributes--

      GET /ords/ HTTP/1.1

      Host: localhost

      Cookie: ORA_WWV_USER_230159280434784=OR__dq

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

      Upgrade-Insecure-Requests: 1

      User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0

      Connection: keep-alive

      Host: localhost:8080

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

      Accept-Encoding: gzip, deflate

       

       

      HttpInputOverHTTP@3bf194c6[c=0,q=0,[0]=null,s=STREAM]

      mapped request using: /*:PL/SQL to: |apex|pu|

      Could not find any dispatcher to handle request:

      --Attributes--

      oracle.dbtools.http.ecid = bi6BZqpD9GIVKGLVaXH4sw..

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

      oracle.dbtools.common.di.Services = URL Mapped Scope

      oracle.dbtools.plugin.api.di.InstanceLocator = oracle.dbtools.common.di.Services$InstanceLocator@4184e9f6

      --Attributes--

      GET /ords/ HTTP/1.1

      Host: localhost

      Cookie: ORA_WWV_USER_230159280434784=OR__dq

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

      Upgrade-Insecure-Requests: 1

      User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0

      Connection: keep-alive

      Host: localhost:8080

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

      Accept-Encoding: gzip, deflate

       

       

      HttpInputOverHTTP@3bf194c6[c=0,q=0,[0]=null,s=STREAM]

      [TE] GET /ords/ start: 2018-08-30T15:55:23.557Z duration: 99ms

      =========================================================

       

      The "Stack Trace" is :

      =====================================================

      DispatcherNotFoundException [statusCode=404, reasons=[]]

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

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

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

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

          at oracle.dbtools.url.mapping.RequestMapperImpl.doFilter(RequestMapperImpl.java:161)

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

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

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

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

          at oracle.dbtools.http.auth.external.ExternalSessionFilter.doFilter(ExternalSessionFilter.java:59)

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

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

          at oracle.dbtools.rt.authentication.apex.ApexSessionQueryRewriteFilter.doFilter(ApexSessionQueryRewriteFilter.java:58)

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

          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.filters.AbsoluteLocationFilter.doFilter(AbsoluteLocationFilter.java:65)

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

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

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

          at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:74)

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

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

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

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

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

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

          at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)

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

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

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

          at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)

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

          at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)

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

          at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)

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

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

          at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)

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

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

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

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

          at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169)

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

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

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

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

          at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)

          at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)

          at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)

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

          at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)

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

      =====================================================

       

      As I ran out of ideas what could be wrong I have installed fresh non cdb 18c database. Configured ords against this new database, but the result is the same.

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

      Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 - Production

      Version 18.3.0.0.0

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

       

      Right now I am in a dark as I do not know what could be wrong. Any hint what to check / look for would be appreciated.

       

      Best regards

        • 1. Re: Error 404 after database + ords upgrade
          GregorM

          Made some progress here. Or better to say got another type of error.

           

          Aug 31, 2018 2:17:01 PM oracle.dbtools.standalone.JettyDefaultHandler handle

          SEVERE: null

          java.lang.NullPointerException

              at oracle.dbtools.common.util.URIs.normalizeBackslashes(URIs.java:478)

              at oracle.dbtools.common.util.URIs.normalize(URIs.java:460)

              at oracle.dbtools.common.util.URIs.resolve(URIs.java:205)

              at oracle.dbtools.standalone.JettyDefaultHandler.permanentRedirect(JettyDefaultHandler.java:181)

              at oracle.dbtools.standalone.JettyDefaultHandler.handle(JettyDefaultHandler.java:90)

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

              at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169)

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

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

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

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

              at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)

              at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)

              at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)

              at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)

              at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)

              at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)

              at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)

              at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)

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

              at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)

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

           

          Tried to make same on fresh (not upgraded) 18c database could not reproduce. On fresh installation of database everything works fine.

          Do I have to reinstall apex in the database?

           

          Best regards.