0 Replies Latest reply on Jul 11, 2018 4:29 AM by Mkakade-Oracle

    Null pointer Exception accessing ORDS 18.2 with 12.1.0.2.0  DB

    Mkakade-Oracle

      Hi ,

       

      I have Oracle 12.1.0.2 DB CDB database with Patch 20885778 applied to be able to use ORDS .

       

      I downloaded the latest ORDS 18.2 and installed on my linux-X64 box .

       

      Complete the ords setup with my database java -jar ords.war setup --database DB1633

      java -jar ords.war validate --database DB1633

      gives no errors

       

      Enter the database password for SYS AS SYSDBA:

      Confirm password:

       

      Retrieving information.

       

      Oracle REST Data Services will be validated.

      Validating Oracle REST Data Services schema version 18.2.0.r1831332

      ... Log file written to /home/mkakade/ords_validate_core_2018-07-10_212722_00346.log

      Completed validating Oracle REST Data Services version 18.2.0.r1831332.  Elapsed time: 00:00:04.254

       

       

       

      Completed the Url mapping with the database with the following command

       

      java -jar ords.war map-url --type base-path /db1633 db1633

       

      Started ords in standalone mode .

      Now when I access the ords  like http://hostname:8080/ords/db1633/ I get 500 Internal Server error with following error seen on the ORDS console

       

      Jul 10, 2018 9:02:32 PM 

      SEVERE: null            

      java.lang.NullPointerException

              at java.util.Objects.requireNonNull(Objects.java:203)

              at oracle.dbtools.url.mapping.db.DatabaseURLMappingImpl.addServices(DatabaseURLMappingImpl.java:319)

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

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

              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.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.produce(EatWhatYouKill.java:132)

              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)

       

       

       

      Can some one please help with this ?