RFE: GeoServer response when SQL request fails

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

RFE: GeoServer response when SQL request fails

Mike Atkinson-2

The GeoServer response to a failed request is

 

<ServiceExceptionReport version="1.2.0" xsi:schemaLocation="http://www.opengis.net/ogc http://localhost:8080/geoserver/data/capabilities//wfs/1.0.0/OGC-exception.xsd">

   <ServiceException>

      org.geotools.data.DataSourceException: Could not count   

   </ServiceException>

</ServiceExceptionReport>

 

This is very confusing as the WFS request was not for a count!

 

It seems that the “Caused by” of the exception is generally more revealing.

 

 

 

 

Request: null

 output format:GML2

 max features:2147483647

 version:

 queries:

  Query []

   feature type: LandRegistry:LRPOLYS

   filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]

   [properties:  ALL ]

 

 50572000 [FINE] org.vfny.geoserver.servlets.AbstractService - strategy is: org.

vfny.geoserver.servlets.SpeedStrategy@1735602

 50572000 [FINE] org.vfny.geoserver.global.Data - getting type LandRegistry:LRPO

LYS

 50572000 [FINE] org.vfny.geoserver.wfs.responses.FeatureResponse - Query is

  Query []

   feature type: LandRegistry:LRPOLYS

   filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]

   [properties:  ALL ]

 To gt2: Query: []

   feature type: LRPOLYS

   filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]

   [properties:  ALL ]

 50572000 [FINE] org.geotools.filter.SQLEncoderOracle - SQLEncoderOracle: Geomet

ric Column is: GEOMETRY

 50572000 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available conne

ction.

 50572000 [FINE] org.geotools.filter.SQLEncoderOracle - Using layer SRID: 4277

 50572156 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - C

onnection closed - adding to available connections.

 50572156 [WARNING] org.vfny.geoserver.servlets.AbstractService - service except

ion while executing request:

Request: null

 output format:GML2

 max features:2147483647

 version:

 queries:

  Query []

   feature type: LandRegistry:LRPOLYS

   filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]

   [properties:  ALL ]

 

cause: org.geotools.data.DataSourceException: Could not count

 50572172 [WARNING] org.vfny.geoserver.ServiceException - encountered error: org

.geotools.data.DataSourceException: Could not count

StackTrace: org.geotools.data.DataSourceException: Could not count

        at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java

:416)

        at org.geotools.data.jdbc.JDBCFeatureSource$1.getCount(JDBCFeatureSource

.java:229)

        at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo

nse.java:286)

        at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo

nse.java:143)

        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService

.java:408)

        at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.ja

va:344)

        at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doResponse(WfsDispatche

r.java:246)

        at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doPost(WfsDispatcher.ja

va:135)

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

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

        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358

)

        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati

onHandler.java:294)

        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5

67)

        at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)

        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication

Context.java:525)

        at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)

        at org.mortbay.http.HttpServer.service(HttpServer.java:879)

        at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)

        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)

        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)

        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:

197)

        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)

        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)

Caused by: java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart()

 routine

ORA-13207: incorrect use of the [SDO_WITHIN_DISTANCE] operator

ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 391

ORA-06512: at line 1

 

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

        at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)

        at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:12

55)

        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav

a:2391)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme

nt.java:2672)

        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:

572)

        at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java

:405)

        ... 22 more

 

 50572172 [FINE] org.vfny.geoserver.ServiceException - return wfs exception is <

?xml version="1.0" ?>

<ServiceExceptionReport

   version="1.2.0"

   xmlns="http://www.opengis.net/ogc"

   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

   xsi:schemaLocation="http://www.opengis.net/ogc http://localhost:8080/geoserve

r/data/capabilities//wfs/1.0.0/OGC-exception.xsd">

   <ServiceException>

      org.geotools.data.DataSourceException: Could not count    </ServiceExcepti

on>

</ServiceExceptionReport>

org.vfny.geoserver.ServiceException: org.geotools.data.DataSourceException: Coul

d not count

        at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo

nse.java:368)

        at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo

nse.java:143)

        at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService

.java:408)

        at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.ja

va:344)

        at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doResponse(WfsDispatche

r.java:246)

        at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doPost(WfsDispatcher.ja

va:135)

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

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

        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358

)

        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati

onHandler.java:294)

        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5

67)

        at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)

        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication

Context.java:525)

        at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)

        at org.mortbay.http.HttpServer.service(HttpServer.java:879)

        at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)

        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)

        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)

        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:

197)

        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)

        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)

Caused by: org.geotools.data.DataSourceException: Could not count

        at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java

:416)

        at org.geotools.data.jdbc.JDBCFeatureSource$1.getCount(JDBCFeatureSource

.java:229)

        at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo

nse.java:286)

        ... 20 more

Caused by: java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart()

 routine

ORA-13207: incorrect use of the [SDO_WITHIN_DISTANCE] operator

ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 391

ORA-06512: at line 1

 

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

        at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)

        at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:12

55)

        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav

a:2391)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme

nt.java:2672)

        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:

572)

        at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java

:405)

        ... 22 more

08:44:54.038 EVENT  Started HttpContext[/]

Reply | Threaded
Open this post in threaded view
|

Re: RFE: GeoServer response when SQL request fails

Chris Holmes-2
And a full stack trace is even more useful.  If you'd like one, with the
complete caused by, you can turn on Verbose Exceptions, in Config ->
Server.

best regards,

Chris

Quoting Mike Atkinson <[hidden email]>:

> The GeoServer response to a failed request is
>
>
>
> <ServiceExceptionReport version="1.2.0"
> xsi:schemaLocation="http://www.opengis.net/ogc
>
http://localhost:8080/geoserver/data/capabilities//wfs/1.0.0/OGC-excepti

> on.xsd">
>
>    <ServiceException>
>
>       org.geotools.data.DataSourceException: Could not count
>
>    </ServiceException>
>
> </ServiceExceptionReport>
>
>
>
> This is very confusing as the WFS request was not for a count!
>
>
>
> It seems that the "Caused by" of the exception is generally more
> revealing.
>
>
>
>
>
>
>
>
>
> Request: null
>
>  output format:GML2
>
>  max features:2147483647
>
>  version:
>
>  queries:
>
>   Query []
>
>    feature type: LandRegistry:LRPOLYS
>
>    filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]
>
>    [properties:  ALL ]
>
>
>
>  50572000 [FINE] org.vfny.geoserver.servlets.AbstractService -
> strategy
> is: org.
>
> vfny.geoserver.servlets.SpeedStrategy@1735602
>
>  50572000 [FINE] org.vfny.geoserver.global.Data - getting type
> LandRegistry:LRPO
>
> LYS
>
>  50572000 [FINE] org.vfny.geoserver.wfs.responses.FeatureResponse -
> Query is
>
>   Query []
>
>    feature type: LandRegistry:LRPOLYS
>
>    filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]
>
>    [properties:  ALL ]
>
>  To gt2: Query: []
>
>    feature type: LRPOLYS
>
>    filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]
>
>    [properties:  ALL ]
>
>  50572000 [FINE] org.geotools.filter.SQLEncoderOracle -
> SQLEncoderOracle: Geomet
>
> ric Column is: GEOMETRY
>
>  50572000 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available conne
>
> ction.
>
>  50572000 [FINE] org.geotools.filter.SQLEncoderOracle - Using layer
> SRID: 4277
>
>  50572156 [FINE]
> org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - C
>
> onnection closed - adding to available connections.
>
>  50572156 [WARNING] org.vfny.geoserver.servlets.AbstractService -
> service except
>
> ion while executing request:
>
> Request: null
>
>  output format:GML2
>
>  max features:2147483647
>
>  version:
>
>  queries:
>
>   Query []
>
>    feature type: LandRegistry:LRPOLYS
>
>    filter: [ GEOMETRY beyond POINT (380032.6 89329), distance: 20.0 ]
>
>    [properties:  ALL ]
>
>
>
> cause: org.geotools.data.DataSourceException: Could not count
>
>  50572172 [WARNING] org.vfny.geoserver.ServiceException - encountered
> error: org
>
> .geotools.data.DataSourceException: Could not count
>
> StackTrace: org.geotools.data.DataSourceException: Could not count
>
>         at
> org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java
>
> :416)
>
>         at
> org.geotools.data.jdbc.JDBCFeatureSource$1.getCount(JDBCFeatureSource
>
> .java:229)
>
>         at
> org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo
>
> nse.java:286)
>
>         at
> org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo
>
> nse.java:143)
>
>         at
> org.vfny.geoserver.servlets.AbstractService.doService(AbstractService
>
> .java:408)
>
>         at
> org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.ja
>
> va:344)
>
>         at
> org.vfny.geoserver.wfs.servlets.WfsDispatcher.doResponse(WfsDispatche
>
> r.java:246)
>
>         at
> org.vfny.geoserver.wfs.servlets.WfsDispatcher.doPost(WfsDispatcher.ja
>
> va:135)
>
>         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>
>         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>
>         at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358
>
> )
>
>         at
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
>
> onHandler.java:294)
>
>         at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
>
> 67)
>
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
>
>         at
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
>
> Context.java:525)
>
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
>
>         at org.mortbay.http.HttpServer.service(HttpServer.java:879)
>
>         at
> org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
>
>         at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
>
>         at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
>
>         at
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
>
> 197)
>
>         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
>
>         at
> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)
>
> Caused by: java.sql.SQLException: ORA-29902: error in executing
> ODCIIndexStart()
>
>  routine
>
> ORA-13207: incorrect use of the [SDO_WITHIN_DISTANCE] operator
>
> ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 391
>
> ORA-06512: at line 1
>
>
>
>         at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>
>         at
> oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
>
>         at
> oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:12
>
> 55)
>
>         at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
>
> a:2391)
>
>         at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
>
> nt.java:2672)
>
>         at
> oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
>
> 572)
>
>         at
> org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java
>
> :405)
>
>         ... 22 more
>
>
>
>  50572172 [FINE] org.vfny.geoserver.ServiceException - return wfs
> exception is <
>
> ?xml version="1.0" ?>
>
> <ServiceExceptionReport
>
>    version="1.2.0"
>
>    xmlns="http://www.opengis.net/ogc"
>
>    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>
>    xsi:schemaLocation="http://www.opengis.net/ogc
> http://localhost:8080/geoserve
>
> r/data/capabilities//wfs/1.0.0/OGC-exception.xsd">
>
>    <ServiceException>
>
>       org.geotools.data.DataSourceException: Could not count
> </ServiceExcepti
>
> on>
>
> </ServiceExceptionReport>
>
> org.vfny.geoserver.ServiceException:
> org.geotools.data.DataSourceException: Coul
>
> d not count
>
>         at
> org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo
>
> nse.java:368)
>
>         at
> org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo
>
> nse.java:143)
>
>         at
> org.vfny.geoserver.servlets.AbstractService.doService(AbstractService
>
> .java:408)
>
>         at
> org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.ja
>
> va:344)
>
>         at
> org.vfny.geoserver.wfs.servlets.WfsDispatcher.doResponse(WfsDispatche
>
> r.java:246)
>
>         at
> org.vfny.geoserver.wfs.servlets.WfsDispatcher.doPost(WfsDispatcher.ja
>
> va:135)
>
>         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>
>         at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>
>         at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358
>
> )
>
>         at
> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
>
> onHandler.java:294)
>
>         at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
>
> 67)
>
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
>
>         at
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
>
> Context.java:525)
>
>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
>
>         at org.mortbay.http.HttpServer.service(HttpServer.java:879)
>
>         at
> org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
>
>         at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
>
>         at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
>
>         at
> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
>
> 197)
>
>         at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
>
>         at
> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)
>
> Caused by: org.geotools.data.DataSourceException: Could not count
>
>         at
> org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java
>
> :416)
>
>         at
> org.geotools.data.jdbc.JDBCFeatureSource$1.getCount(JDBCFeatureSource
>
> .java:229)
>
>         at
> org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureRespo
>
> nse.java:286)
>
>         ... 20 more
>
> Caused by: java.sql.SQLException: ORA-29902: error in executing
> ODCIIndexStart()
>
>  routine
>
> ORA-13207: incorrect use of the [SDO_WITHIN_DISTANCE] operator
>
> ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 391
>
> ORA-06512: at line 1
>
>
>
>         at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>
>         at
> oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
>
>         at
> oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:12
>
> 55)
>
>         at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
>
> a:2391)
>
>         at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
>
> nt.java:2672)
>
>         at
> oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
>
> 572)
>
>         at
> org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java
>
> :405)
>
>         ... 22 more
>
> 08:44:54.038 EVENT  Started HttpContext[/]
>




----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/


-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users