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-tp4631717p4631717.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
