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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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