oracle.jdbc.driver.OracleSQLException: ORA-13249: SDO_NN cannot be evaluated without using index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 17 ORA-06512: at "MDSYS.PRVT_IDX", line 33

Oracle Community | 444920 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    routeserver exception: SDO_NN cannot be evaluated without using index

    Oracle Community | 1 decade ago | 444920
    oracle.jdbc.driver.OracleSQLException: ORA-13249: SDO_NN cannot be evaluated without using index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 17 ORA-06512: at "MDSYS.PRVT_IDX", line 33

    Root Cause Analysis

    1. oracle.jdbc.driver.OracleSQLException

      ORA-13249: SDO_NN cannot be evaluated without using index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 17 ORA-06512: at "MDSYS.PRVT_IDX", line 33

      at oracle.spatial.geocoder.client.ThinClientGeocoder.batchGeocode()
    2. oracle.spatial.geocoder
      ThinClientGeocoder.batchGeocode
      1. oracle.spatial.geocoder.client.ThinClientGeocoder.batchGeocode(ThinClientGeocoder.java:350)
      1 frame
    3. oracle.spatial.router
      RouteServerServlet.doPost
      1. oracle.spatial.router.server.RouteServerServlet.processRouteRequest(RouteServerServlet.java:467)
      2. oracle.spatial.router.server.RouteServerServlet.takeXMLRequestAndReturnResponse(RouteServerServlet.java:411)
      3. oracle.spatial.router.server.RouteServerServlet.doPost(RouteServerServlet.java:272)
      3 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    5. com.evermind.server
      HttpRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:810)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
      3. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
      4. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
      5. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
      5 frames
    6. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
      1 frame
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame