SDE geometry type ST_GEOMETRY - error with where clause/filter
--------------------------------------------------------------
Key: GEOS-4061
URL: http://jira.codehaus.org/browse/GEOS-4061
Project: GeoServer
Issue Type: Bug
Components: ArcSDE
Affects Versions: 2.0.1
Environment: Oracle 10.2, SDE 9.2 SP5, GeoServer 2.0.1 with SDE 9.3 jars
Reporter: Aleda Freeman
Assignee: Andrea Aime
1. WFS GetFeature shapefile extract causes error in geoserver.log.
2. WFS XML GetFeature with Filter error in geoserver.log
They seem to be related.
1. geoserver.log error:
2010-07-15 10:37:31,347 INFO [geoserver.wfs] -
Request: getFeature
handle = null
service = wfs
version = 1.0.0
baseUrl = http://maps.massgis.state.ma.us:80/geoserver/
providedVersion = null
query = [net.opengis.wfs.impl.QueryTypeImpl@anonymised.com (group: null, propertyName: null, function: null, filter: nu ll, sortBy: null, featureVersion: null, handle: null, srsName: null, typeName: [{http://massgis.state.ma.us/featuretype\}
AFREEMAN.COUNTIES_POLY_ST_G])]
maxFeatures = null
outputFormat = SHAPE-ZIP
resultType = results
traverseXlinkDepth = null
traverseXlinkExpiry = null
formatOptions = {}
2010-07-15 10:37:31,437 WARN [data.ArcSDEQuery] - Error fetching row for AFREEMAN.COUNTIES_POLY_ST_G[
Filter: Filter.INCLUDE
where clause sent: null
geometry filter:Filter.INCLUDE
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE LEVEL ERROR OCCURRED.][Extended desc= ]
at org.geotools.arcsde.session.Session.issue(Session.java:268)
at org.geotools.arcsde.session.Session.fetch(Session.java:704)
at org.geotools.arcsde.session.Session.fetch(Session.java:700)
at org.geotools.arcsde.data.ArcSDEQuery.fetch(ArcSDEQuery.java:828)
at org.geotools.arcsde.data.ArcSDEAttributeReader.hasNext(ArcSDEAttributeReader.java:182)
at org.geotools.data.DefaultFeatureReader.hasNext(DefaultFeatureReader.java:108)
at org.geotools.data.MaxFeatureReader.hasNext(MaxFeatureReader.java:84)
at org.geotools.data.store.FeatureReaderIterator.hasNext(FeatureReaderIterator.java:51)
at org.geoserver.feature.RetypingFeatureCollection$RetypingIterator.hasNext(RetypingFeatureCollection.java:116)
at org.geoserver.wfs.response.RemappingFeatureCollection$RemappingIterator.hasNext(RemappingFeatureCollection.ja
va:129)
at org.geoserver.wfs.response.RemappingFeatureCollection$RemappingIterator.hasNext(RemappingFeatureCollection.ja
va:129)
at org.geoserver.feature.RetypingFeatureCollection$RetypingIterator.hasNext(RetypingFeatureCollection.java:116)
at org.geotools.data.AbstractFeatureStore.addFeatures(AbstractFeatureStore.java:260)
at org.geoserver.wfs.response.ShapeZipOutputFormat.writeCollectionToShapefile(ShapeZipOutputFormat.java:244)
at org.geoserver.wfs.response.ShapeZipOutputFormat.write(ShapeZipOutputFormat.java:160)
at org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:137)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:726)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java
:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.ja
va:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.k.v(Unknown Source)
at com.esri.sde.sdk.client.k.d(Unknown Source)
at com.esri.sde.sdk.client.SeQuery.fetch(Unknown Source)
at org.geotools.arcsde.session.Session$4.execute(Session.java:708)
at org.geotools.arcsde.session.Session$4.execute(Session.java:706)
at org.geotools.arcsde.session.Session.issue(Session.java:265)
... 68 more
2. request:
<wfs:GetFeature xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wfs http://giswebservices.massgis.state.ma.us/geoserver/schemas/wfs/1.0.0/WFS-basic.xsd" xmlns:gml="http://www.opengis.net/gml" xmlns:wfs="http://www.opengis.net/wfs" xmlns:ogc="http://www.opengis.net/ogc" service="WFS" version="1.0.0">
<wfs:Query typeName="massgis:AFREEMAN.COUNTIES_POLY_ST_G" xmlns:massgis="http://massgis.state.ma.us/featuretype">
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>COUNTY</ogc:PropertyName>
<ogc:Literal>ESSEX</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
</wfs:Query>
</wfs:GetFeature>
2. geoserver.log error:
2010-07-15 10:57:56,007 INFO [geoserver.wfs] -
Request: getFeature
handle = null
service = WFS
version = 1.0.0
baseUrl = http://maps.massgis.state.ma.us:80/geoserver/
providedVersion = null
query = [net.opengis.wfs.impl.QueryTypeImpl@anonymised.com (group: null, propertyName: null, function: null, filter: [ COUNTY = ESSEX ], sortBy: null, featureVersion: null, handle: null, srsName: null, typeName: [{http://massgis.state.ma.
us/featuretype}AFREEMAN.COUNTIES_POLY_ST_G])]
maxFeatures = null
outputFormat = GML2
resultType = results
traverseXlinkDepth = null
traverseXlinkExpiry = null
formatOptions = {}
2010-07-15 10:57:56,017 ERROR [data.ArcSDEQuery] - ***********************
tables: [AFREEMAN.COUNTIES_POLY_ST_G]
filter: Filter.INCLUDE
SQL: AFREEMAN.COUNTIES_POLY_ST_G.COUNTY = 'ESSEX'
org.geotools.arcsde.ArcSdeException: [SDE error -42][Error desc=USER SPECIFIED WHERE CLAUSE IS INVALID.][Extended desc= ]
at org.geotools.arcsde.session.Session.issue(Session.java:268)
at org.geotools.arcsde.data.ArcSDEQuery.calculateQueryExtent(ArcSDEQuery.java:668)
at org.geotools.arcsde.data.ArcSDEQuery.calculateQueryExtent(ArcSDEQuery.java:597)
at org.geotools.arcsde.data.ArcSdeFeatureSource.getBounds(ArcSdeFeatureSource.java:187)
at org.geotools.arcsde.data.ArcSdeFeatureSource.getBounds(ArcSdeFeatureSource.java:165)
at org.geotools.arcsde.data.ArcSdeFeatureCollection.getBounds(ArcSdeFeatureCollection.java:85)
at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:490)
at org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:714)
at org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:484)
at org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:296)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:129)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:108)
at org.geoserver.wfs.xml.GML2OutputFormat.encode(GML2OutputFormat.java:265)
at org.geoserver.wfs.xml.GML2OutputFormat.write(GML2OutputFormat.java:284)
at org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:137)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:726)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java
:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.ja
va:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.k.a(Unknown Source)
at com.esri.sde.sdk.client.k.a(Unknown Source)
at com.esri.sde.sdk.client.SeQuery.calculateLayerExtent(Unknown Source)
at org.geotools.arcsde.data.ArcSDEQuery$3.execute(ArcSDEQuery.java:707)
at org.geotools.arcsde.data.ArcSDEQuery$3.execute(ArcSDEQuery.java:668)
at org.geotools.arcsde.session.Session.issue(Session.java:265)
... 67 more
2010-07-15 10:57:56,017 WARN [data.ArcSDEQuery] - Error fetching row for AFREEMAN.COUNTIES_POLY_ST_G[
Filter: [ COUNTY = ESSEX ]
where clause sent: AFREEMAN.COUNTIES_POLY_ST_G.COUNTY = 'ESSEX'
geometry filter:Filter.INCLUDE
org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE LEVEL ERROR OCCURRED.][Extended desc= ]
at org.geotools.arcsde.session.Session.issue(Session.java:268)
at org.geotools.arcsde.session.Session.fetch(Session.java:704)
at org.geotools.arcsde.session.Session.fetch(Session.java:700)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira