Parsing failed for tr5_72ha: java.lang.StringIndexOutOfBoundsException: String index out of range: 0
----------------------------------------------------------------------------------------------------
Key: GEOS-1862
URL: http://jira.codehaus.org/browse/GEOS-1862
Project: GeoServer
Issue Type: Bug
Components: WFS
Affects Versions: 1.7.x
Environment: Geoserver installed on Ubuntu server 7.10, tomcat 6.0.16, postgres+postgis 8.2, uDig on windows client
Reporter: Francesco Izzi
Assignee: Andrea Aime
Fix For: 1.7.0-beta1
when i try to do commit change using uDig client on windows, geoserver generates this exception
-------------------------------------------------------------------------------------------------------------------------------------
11 apr 10:57:39 ERROR [data.jdbc] - Error Performing SQL query: SELECT "pk_id", "gm_layer", "gm_type", "layer", "area", "cod_area", "criticita_", "nome_area", "reg_in_are", "tr2_1h", "tr2_3h", "tr2_6h", "tr2_12h", "tr2_24h", "tr5_1h", "tr5_3h", "tr5_6h", "tr5_12h", "tr5_24h", "tr10_1h", "tr10_3h", "tr10_6h", "tr10_12h", "tr10_24h", "tr20_1h", "tr20_3h", "tr20_6h", "tr20_12h", "tr20_24h", "tr2_1ha", "tr2_3ha", "tr2_6ha", "tr2_12ha", "tr2_24ha", "tr5_1ha", "tr5_3ha", "tr5_6ha", "tr5_12ha", "tr5_24ha", "tr2_48ha", "tr2_72ha", "tr5_48ha", "tr5_72ha", "tr10_1ha", "tr10_3ha", "tr10_6ha", "tr10_12ha", "tr10_24ha", "tr10_48ha", "tr10_72ha", "tr20_1ha", "tr20_3ha", "tr20_6ha", "tr20_12ha", "tr20_24ha", "tr20_48ha", "tr20_72ha", encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM "public"."sardegna_zoneallertanov05" WHERE ("pk_id" = '9223372036854775807')
org.postgresql.util.PSQLException: ERROR: value "9223372036854775807" is out of range for type integer
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:923)
at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:641)
at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:86)
at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:217)
at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:187)
at org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:176)
at org.geotools.data.crs.ForceCoordinateSystemFeatureResults$1.openIterator(ForceCoordinateSystemFeatureResults.java:96)
at org.geotools.feature.collection.AbstractFeatureCollection.features(AbstractFeatureCollection.java:61)
at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:480)
at org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:702)
at org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:484)
at org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:295)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:128)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:107)
at org.geoserver.wfs.xml.GML2OutputFormat.encode(GML2OutputFormat.java:244)
at org.geoserver.wfs.xml.GML2OutputFormat.write(GML2OutputFormat.java:263)
at org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:137)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:615)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:192)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:357)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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:69)
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:175)
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:263)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
11 apr 10:57:39 ERROR [geoserver.ows] -
org.geoserver.platform.ServiceException: error:Translator error
at org.geoserver.wfs.xml.GML2OutputFormat.encode(GML2OutputFormat.java:254)
at org.geoserver.wfs.xml.GML2OutputFormat.write(GML2OutputFormat.java:263)
at org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:137)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:615)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:192)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:357)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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:69)
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:175)
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:263)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: javax.xml.transform.TransformerException: Translator error
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:132)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:107)
at org.geoserver.wfs.xml.GML2OutputFormat.encode(GML2OutputFormat.java:244)
... 52 more
Caused by: java.lang.RuntimeException: Error reading Features
at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.handleFeatureIterator(FeatureTransformer.java:543)
at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:480)
at org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:702)
at org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:484)
at org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:295)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:128)
... 54 more
Caused by: java.util.NoSuchElementException: Could not aquire feature:org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "pk_id", "gm_layer", "gm_type", "layer", "area", "cod_area", "criticita_", "nome_area", "reg_in_are", "tr2_1h", "tr2_3h", "tr2_6h", "tr2_12h", "tr2_24h", "tr5_1h", "tr5_3h", "tr5_6h", "tr5_12h", "tr5_24h", "tr10_1h", "tr10_3h", "tr10_6h", "tr10_12h", "tr10_24h", "tr20_1h", "tr20_3h", "tr20_6h", "tr20_12h", "tr20_24h", "tr2_1ha", "tr2_3ha", "tr2_6ha", "tr2_12ha", "tr2_24ha", "tr5_1ha", "tr5_3ha", "tr5_6ha", "tr5_12ha", "tr5_24ha", "tr2_48ha", "tr2_72ha", "tr5_48ha", "tr5_72ha", "tr10_1ha", "tr10_3ha", "tr10_6ha", "tr10_12ha", "tr10_24ha", "tr10_48ha", "tr10_72ha", "tr20_1ha", "tr20_3ha", "tr20_6ha", "tr20_12ha", "tr20_24ha", "tr20_48ha", "tr20_72ha", encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM "public"."sardegna_zoneallertanov05" WHERE ("pk_id" = '9223372036854775807')
at org.geotools.data.store.NoContentIterator.next(NoContentIterator.java:55)
at org.geotools.data.store.NoContentIterator.next(NoContentIterator.java:40)
at org.geotools.feature.collection.DelegateFeatureIterator.next(DelegateFeatureIterator.java:57)
at org.geotools.data.crs.ForceCoordinateSystemIterator.next(ForceCoordinateSystemIterator.java:121)
at org.geotools.feature.collection.DelegateFeatureIterator.next(DelegateFeatureIterator.java:57)
at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.handleFeatureIterator(FeatureTransformer.java:529)
... 59 more
Caused by: org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "pk_id", "gm_layer", "gm_type", "layer", "area", "cod_area", "criticita_", "nome_area", "reg_in_are", "tr2_1h", "tr2_3h", "tr2_6h", "tr2_12h", "tr2_24h", "tr5_1h", "tr5_3h", "tr5_6h", "tr5_12h", "tr5_24h", "tr10_1h", "tr10_3h", "tr10_6h", "tr10_12h", "tr10_24h", "tr20_1h", "tr20_3h", "tr20_6h", "tr20_12h", "tr20_24h", "tr2_1ha", "tr2_3ha", "tr2_6ha", "tr2_12ha", "tr2_24ha", "tr5_1ha", "tr5_3ha", "tr5_6ha", "tr5_12ha", "tr5_24ha", "tr2_48ha", "tr2_72ha", "tr5_48ha", "tr5_72ha", "tr10_1ha", "tr10_3ha", "tr10_6ha", "tr10_12ha", "tr10_24ha", "tr10_48ha", "tr10_72ha", "tr20_1ha", "tr20_3ha", "tr20_6ha", "tr20_12ha", "tr20_24ha", "tr20_48ha", "tr20_72ha", encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM "public"."sardegna_zoneallertanov05" WHERE ("pk_id" = '9223372036854775807')
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:934)
at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:641)
at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:86)
at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:217)
at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:187)
at org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:176)
at org.geotools.data.crs.ForceCoordinateSystemFeatureResults$1.openIterator(ForceCoordinateSystemFeatureResults.java:96)
at org.geotools.feature.collection.AbstractFeatureCollection.features(AbstractFeatureCollection.java:61)
... 59 more
Caused by: org.postgresql.util.PSQLException: ERROR: value "9223372036854775807" is out of range for type integer
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:923)
... 66 more
11 apr 10:57:39 INFO [geoserver.filters] - 151.13.182.118 "POST /geoserver/wfs" took 36ms
11 apr 10:57:59 INFO [geoserver.filters] - Created BufferedRequestWrapper with String: "<?xml version="1.0" encoding="UTF-8"?>
<GetFeature xmlns="http://www.opengis.net/wfs" xmlns:gml="http://www.opengis.net/gml" xmlns:ogc="http://www.opengis.net/ogc" version="1.0.0" service="WFS" outputFormat="GML2"><Query typeName="Esercitazioni:sardegna_zoneallertanov05"><ogc:PropertyName>the_geom</ogc:PropertyName>
<ogc:Filter><ogc:BBOX><ogc:PropertyName>the_geom</ogc:PropertyName>
<gml:Box><gml:coordinates decimal="." cs="," ts=" ">9.673920498356994,40.12062143824493 9.788268844419427,40.34931813036979</gml:coordinates>
</gml:Box>
</ogc:BBOX>
</ogc:Filter>
</Query>
</GetFeature>
" as buffer
11 apr 10:57:59 INFO [geoserver.filters] - 151.13.182.118 "POST /geoserver/wfs" "uDig 1.1-RC10a (http://udig.refractions.net) Java/1.5.0_04" "" request-size: 589 body:
<?xml version="1.0" encoding="UTF-8"?>
<GetFeature xmlns="http://www.opengis.net/wfs" xmlns:gml="http://www.opengis.net/gml" xmlns:ogc="http://www.opengis.net/ogc" version="1.0.0" service="WFS" outputFormat="GML2"><Query typeName="Esercitazioni:sardegna_zoneallertanov05"><ogc:PropertyName>the_geom</ogc:PropertyName>
<ogc:Filter><ogc:BBOX><ogc:PropertyName>the_geom</ogc:PropertyName>
<gml:Box><gml:coordinates decimal="." cs="," ts=" ">9.673920498356994,40.12062143824493 9.788268844419427,40.34931813036979</gml:coordinates>
</gml:Box>
</ogc:BBOX>
</ogc:Filter>
</Query>
</GetFeature>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
to resolve this problem, we changed in the database schema the type of PK_ID from int to bigint.
--
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