Afroz, This error message says you must specify a search shape with area > 0 during the query. Assuming you use a queryByPoint operation, either the buffer parameter of the tolerance of the layer should be specified as a positive number.
Best regards, Tamas 2010/2/25 Afroz Kannancheri <afr...@gmail.com> > > 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 >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users