[mapserver-users] Getfeatureinfo and MSsql 2008 server

[afrozk at gmail.com]

Dear tamas, 
I'll try the buffer  parameter that u have mentioned once I m back in office on sunday and update u guys about the output.

Thanks a lot guys..
Sent from my BlackBerry® smartphone from du

-----Original Message-----
From: Tamas Szekeres <szekerest at gmail.com>
Date: Thu, 25 Feb 2010 23:06:47 
To: Afroz Kannancheri<afrozk at gmail.com>
Cc: <mapserver-users at lists.osgeo.org>
Subject: Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server

 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 <afrozk at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100226/05774ee5/attachment.htm>