[mapserver-users] Help with NQuery error (CGI)

[Paul james]

Thanks Steve...
Trying execute a query point like that:
http://localhost/cgi-bin-last/mapserv.exe?map=C:/map.map&mode=query&LAYERS=UF&mapext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375&imgext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375&map_size=1217+680&imgxy=1217+680&img.x=608.5&img.y=340

 generated that error :

msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL
statement: SELECT convert(varchar(max), oid),convert(varchar(max),
codigouf),convert(varchar(max), codigoregiao),convert(varchar(max),
nomeuf),convert(varchar(max),
siglauf),the_geom.STAsBinary(),convert(varchar(20), oid) from viwgeo_uf
WHERE
the_geom.STIntersects(Geometry::STGeomFromText('POLYGON((-56.6879924952826
-14.1504774265924,-56.6879924952826 -14.1504774265924,-56.6879924952826
-14.1504774265924,-56.6879924952826 -14.1504774265924,-56.6879924952826
-14.1504774265924))',0)) = 1

System.FormatException: 24305: The Polygon input is not valid because the
ring does not have enough distinct points. Each ring of a polygon must
contain at least three distinct points. System.FormatException: at
Microsoft.SqlServer.Types.Validator.Execute(Transition transition) at
Microsoft.SqlServer.Types.Validator.EndFigure() at
Microsoft.SqlServer.Types.ForwardingGeoDataSink.EndFigure() at
Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText() at
Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText() at
Microsoft.SqlServer.Types.OpenGisWktReader.ParseTaggedText(OpenGisType type)
at Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32
srid) at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType
type, SqlChars text, Int32 srid) at
Microsoft.SqlServer.Types.SqlGeometry.STGeom


Paul


On Fri, Oct 30, 2009 at 2:48 PM, Steve Lime <Steve.Lime at dnr.state.mn.us>wrote:

> Probably. Does a point query work? I reassigned the ticket to the keeper
> of the SQLServer
> driver in hopes that it gets attention.
>
> Curiously, have you tried 5.6 at all with SQLServer?
>
> Steve
>
> >>> On 10/30/2009 at 12:22 PM, in message
> <33fad6880910301022s40c76f88ha011362964e21808 at mail.gmail.com>, Paul
>  james
> <pauljame at gmail.com> wrote:
> > I think so...
> > Is it related with that ticket?
> > http://trac.osgeo.org/mapserver/ticket/3058
> >
> > Paul
> >
> > On Fri, Oct 30, 2009 at 1:53 PM, Steve Lime
> <Steve.Lime at dnr.state.mn.us>wrote:
> >
> >> Odd. Unfortunately I can't debug anything related to MSSQL2008,
> perhaps
> >> the driver isn't
> >> supporting functions necessary to complete a query?
> >>
> >> Steve
> >>
> >> >>> On 10/30/2009 at 6:33 AM, in message
> >> <33fad6880910300433i342c619am99935a607896643f at mail.gmail.com>, Paul
> >>  james
> >> <pauljame at gmail.com> wrote:
> >> > Hey Steve...
> >> >
> >> > Yes I had...
> >> > QUERYMAP
> >> >  COLOR 255 0 0
> >> >  SIZE -1 -1
> >> >  STATUS ON
> >> >  STYLE hilite
> >> > END
> >> >
> >> > With Status OFF I got that :
> >> > Content-type: text/html
> >> >
> >> > Using MSSQL2008
> >> >
> >> > Paul
> >> >
> >> >
> >> > On Thu, Oct 29, 2009 at 6:13 PM, Steve Lime
> >> <Steve.Lime at dnr.state.mn.us>wrote:
> >> >
> >> >> Do you have a querymap object configured with status on? I would
> >> guess
> >> >> so in order to see that
> >> >> error. What happens if you set STATUS OFF in the querymap?
> >> >>
> >> >> >>> On 10/29/2009 at 7:57 AM, in message
> >> >> <33fad6880910290557m71ee3fdatd470590e3256f175 at mail.gmail.com>,
> Paul
> >> >> james
> >> >> <pauljame at gmail.com> wrote:
> >> >>  > Hello guys...
> >> >> > Ím got this error when trying to execute a Nquery :
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mape
>
> >
> >>
> >> > x
> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.35807
> >
> >> > 61718
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> 75+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&i
> >
> >> > mgb
> >> >> > ox=0+0+1221+762
> >> >> >
> >> >> > msDrawMap(): Image handling error. Failed to draw layer named
> >> >> 'TEST'.
> >> >> >
> >> >> > But, If I execute the same url with "mode=map", the image is
> >> >> generated
> >> >> > fine... What this error means?
> >> >> >
> >> >> >
> >> >> > TEST Layer
> >> >> >
> >> >> >  LAYER
> >> >> >   NAME TEST
> >> >> >   GROUP "TE"
> >> >> >   TYPE polygon
> >> >> >   STATUS ON
> >> >> >   CONNECTIONTYPE PLUGIN
> >> >> >   PLUGIN "msplugin_mssql2008.dll"
> >> >> >   CONNECTION "server=X;Integrated
> >> >> Security=false;database=X;uid=X;pwd=X"
> >> >> >   DATA "the_geom from viw USING UNIQUE oid USING SRID=0"
> >> >> >   CLASS
> >> >> >    TEMPLATE "template.html"
> >> >> >    NAME "X"
> >> >> >    STYLE
> >> >> >     OUTLINECOLOR 150 150 150
> >> >> >     WIDTH 1
> >> >> >    END
> >> >> >   END
> >> >> >  END
> >> >> >
> >> >> > Thanks
> >> >> >
> >> >> > Paul
> >> >>
> >>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091103/3d883609/attachment-0001.html