[OpenLayers-Users] Getfeatureinfo and MSsql 2008 server

Afroz Kannancheri afrozk at gmail.com
Thu Feb 25 05:55:10 EST 2010


Hi All,

I have a layer drawn from the shape information stored in MSSQL 2008 server.
The layer has around 300 polygons which are drawn perfectly on a world base
map.
When i try to get the details for each polygon using the Getfeatureinfo
during the click event, i get the following error from MSSQL 2008 server.

msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL
statement: SELECT convert(varchar(max), numb1),convert(varchar(max),
poprate),geom.STAsBinary(),convert(varchar(20), ID) from table1 WHERE
geom.STIntersects(Geometry::STGeomFromText('POLYGON((-16.4101563310658
17.724609875,-16.4101563310658 17.724609875,-16.4101563310658
17.724609875,-16.4101563310658 17.724609875,-16.4101563310658
17.724609875))',0)) = 1 -[Microsoft][ODBC SQL Server Driver][SQL Server]A
.NET Framework error occurred during execution of user defined routine or
aggregate 'geometry': System.FormatException: 24118: The Polygon input is
not valid because the exterior ring does not have enough points. Each ring
of a polygon must contain at least three distinct points.
System.FormatException: at
Microsoft.SqlServer.Types.GeometryDataBuilder.EndFigure() at
Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText(FigureAttributes
attributes) at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText()
at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonTaggedText() at
Microsoft.SqlServer.Types.OpenGisWktReader.ParseGeometryTaggedText() at
Microsoft.SqlServer.Types.OpenGisWktReader.ReadGeometry() at
Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars
geometryTaggedText, Int32 srid)


Has anyone faced such an issue before. 


Thanks and regards
Afroz Kannancheri
-- 
View this message in context: http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631771p4631771.html
Sent from the OpenLayers Users mailing list archive at Nabble.com.



More information about the Users mailing list