[Geoserver-users] Uprgrade from 1.5.4 to 1.6.4 (with Oracle Spatial) failing with message: [window SRID does not match layer SRID]

Sam_Gem_Den_Haag · August 12, 2008, 12:07pm

Hi Geoserver Community, I'm upgrading a client from 1.5.4 to 1.6.4 (with
Oracle Spacial) and I'm having the same problem as this fellow:

http://www.nabble.com/WFS-GetFeature-request-fails-in-GeoServer-1.6.3-with-Oracle-plugin-because-of-missing-SRID-in-SQL-query-td16961671.html#a16961671

It appears that my SRS is not being picked up for the SRID part of the
eventual Oracle query (this worked fine in 1.5.4)

Thanks in advance for any pointers y'all can give me.

Here's are my info.xml, brower request, and relevant geoserver stacktrace

----------------------------
featureTypes\<feature_name>\info.xml :

<featureType datastore = "krtopo" >
  <name>KT10_V_BEBOUWD_TERREIN</name>
  
  <SRS>28992</SRS>
  <SRSHandling>0</SRSHandling>
  <title>Ovz10000_Bebouwd_terrein_Type</title>
  <abstract>Generated from Ovz10000_Bebouwd_terrein</abstract>
  <wmspath>KT10_V_BEBOUWD_TERREIN</wmspath>
  <numDecimals value = "0" />
  <keywords>Ovz10000_Bebouwd_terrein</keywords>
  <latLonBoundingBox dynamic = "false" miny = "-90.0" maxy = "90.0" maxx =
"180.0" minx = "-180.0" />
  <nativeBBox dynamic = "false" miny = "447700.0" maxy = "460700.0" maxx =
"89000.0" minx = "73200.0" />
  
  <styles default = "Ovz10000_Bebouwd_terrein" />
  <cacheinfo enabled = "false" />
  <searchable enabled = "false" />
  <regionateAttribute />
  <regionateStrategy />
  <regionateFeatureLimit value = "10" />
  <maxFeatures>0</maxFeatures>
</featureType>
----------------------------
Browser Request:
http://localhost:8080/geoserver/wfs?request=GetFeature&version=1.0.0&typeName=KT50_V_BEDRIJFSTERREIN&outputFormat=json&bbox=61735.0148367952,447700,100464.985163205,460700&maxFeatures=1
----------------------------
2008-08-12 12:56:12,812 INFO [STDOUT] 12 aug 12:56:12 ERROR [data.jdbc] -
Error Performing SQL query: SELECT "ID", "OCE_ID", "GEOMETRIE" FROM
"KT50_V_BEDRIJFSTERREIN" WHERE
SDO_RELATE("GEOMETRIE",MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(68303.9215686275,447700.0,93896.0784313726,460700.0)),'mask=anyinteract
querytype=WINDOW') = 'TRUE'
java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart()
routine
ORA-13208: internal error while evaluating [window SRID does not match
layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286

  at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
  at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
  at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
  at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
  at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:919)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:642)
  at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:88)
  at
org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:227)
  at
org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:197)
  at
org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:186)
  at
org.geotools.data.crs.ForceCoordinateSystemFeatureResults.openIterator(ForceCoordinateSystemFeatureResults.java:93)
  at
org.geotools.feature.collection.AbstractFeatureCollection.features(AbstractFeatureCollection.java:64)
  at
org.geoserver.wfs.response.GeoJSONOutputFormat.write(GeoJSONOutputFormat.java:105)
  at
org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:137)
  at org.geoserver.ows.Dispatcher.response(Dispatcher.java:637)
  at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:198)
  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:690)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  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:264)
  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:274)
  at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  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:163)
  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.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  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:230)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
  at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
  at java.lang.Thread.run(Thread.java:595)

----------------------------
--
View this message in context: http://www.nabble.com/Uprgrade-from-1.5.4-to-1.6.4-(with-Oracle-Spatial)-failing-with-message%3A--window-SRID-does-not-match-layer-SRID--tp18943053p18943053.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Sam_Gem_Den_Haag · August 12, 2008, 2:25pm

NOTE to upgraders to 1.6.4 - I found a solution. My previous problem was
using the latest 1.6.x SNAPSHOT from the svn repo. I got it to work by
downloading the prebuilt 1.6.4 war and then using this oracle spatial jar
http://gridlock.openplans.org/geoserver/1.6.x/ext-latest/geoserver-1.6.0-oracle-plugin.zip
(which had a fix for another "invalid relational operator" problem I was
having with the 2.4.3 version of the jar)

--
View this message in context: http://www.nabble.com/Uprgrade-from-1.5.4-to-1.6.4-(with-Oracle-Spatial)-failing-with-message%3A--window-SRID-does-not-match-layer-SRID--tp18943053p18945327.html
Sent from the GeoServer - User mailing list archive at Nabble.com.