Error viewing wms layer: 2 SRIDs in same layer ( not true) ) error: Operation on two geometries with different SRIDs
--------------------------------------------------------------------------------------------------------------------
Key: GEOS-4452
URL: http://jira.codehaus.org/browse/GEOS-4452
Project: GeoServer
Issue Type: Bug
Components: WMS
Environment: Error viewing wms layer: 2 SRIDs in same layer ( not true) ) error: operation on two geometries with different SRIDs
Reporter: Marc Benito
Assignee: Andrea Aime
Priority: Minor
Attachments: error_snapshot.JPG
Error viewing wms layer in geoserver.
I create 2 differents datastores (postGis stores) pointing to the same machine ( ex: Server1) accessing to different databases but with the same schema and same table but with different SRIDs
Ex:
Server1 ( postgres) --> databaseBarcelona --> map.limit_line --> srid ( the_geom ) == 23031
Server2 ( postgres) --> databaseMadrid --> map.limit_line --> srid ( the_geom ) == 900913
When i acces to the first, the wms layer runs OK.
When i acces to the second. the wms layers report an ERROR:
org.postgresql.util.PSQLException: ERROR: Operation on two geometries with different SRIDs
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:147)
at org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:557)
... 149 more
I Reproduce this error in 2 different enviroments:
- with the build 2.1 of 30-03-2011 --> 2.1-SNAPSHOT -->Subversion Revision: 15612
- with an old 2.1 build ( 2 months ago).
In both cases occurs the same.
I Founf a solution:
Change the name of the table:
When i changed the name of the table the second layers runs OK.
--
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