Re: [mapserver-users] Help with NQuery error (CGI)
Hi Steve... Any update on MSSQL2008 driver to solve that bug? Thanks On Fri, Oct 30, 2009 at 2:48 PM, Steve Lime steve.l...@dnr.state.mn.uswrote: 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 33fad6880910301022s40c76f88ha011362964e21...@mail.gmail.com, Paul james paulj...@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.l...@dnr.state.mn.uswrote: 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 33fad6880910300433i342c619am99935a6078966...@mail.gmail.com, Paul james paulj...@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.l...@dnr.state.mn.uswrote: 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 33fad6880910290557m71ee3fdatd470590e3256f...@mail.gmail.com, Paul james paulj...@gmail.com wrote: Hello guys... Ím got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmape x t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.35807 61718 75+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762i 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI)
Thanks Steve...
Trying execute a query point like that:
http://localhost/cgi-bin-last/mapserv.exe?map=C:/map.mapmode=queryLAYERS=UFmapext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375imgext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375map_size=1217+680imgxy=1217+680img.x=608.5img.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.l...@dnr.state.mn.uswrote:
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
33fad6880910301022s40c76f88ha011362964e21...@mail.gmail.com, Paul
james
paulj...@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.l...@dnr.state.mn.uswrote:
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
33fad6880910300433i342c619am99935a6078966...@mail.gmail.com, Paul
james
paulj...@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.l...@dnr.state.mn.uswrote:
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
33fad6880910290557m71ee3fdatd470590e3256f...@mail.gmail.com,
Paul
james
paulj...@gmail.com wrote:
Hello guys...
Ím got this error when trying to execute a Nquery :
http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmape
x
t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.35807
61718
75+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762i
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
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI)
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.l...@dnr.state.mn.uswrote: 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 33fad6880910290557m71ee3fdatd470590e3256f...@mail.gmail.com, Paul james paulj...@gmail.com wrote: Hello guys... Ím got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmapex t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.3580761718 75+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762imgb 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI)
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 33fad6880910300433i342c619am99935a6078966...@mail.gmail.com, Paul james paulj...@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.l...@dnr.state.mn.uswrote: 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 33fad6880910290557m71ee3fdatd470590e3256f...@mail.gmail.com, Paul james paulj...@gmail.com wrote: Hello guys... Ím got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmape x t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.35807 61718 75+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762i 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI)
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.l...@dnr.state.mn.uswrote: 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 33fad6880910300433i342c619am99935a6078966...@mail.gmail.com, Paul james paulj...@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.l...@dnr.state.mn.uswrote: 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 33fad6880910290557m71ee3fdatd470590e3256f...@mail.gmail.com, Paul james paulj...@gmail.com wrote: Hello guys... Ím got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmape x t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.35807 61718 75+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762i 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI)
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 33fad6880910301022s40c76f88ha011362964e21...@mail.gmail.com, Paul james paulj...@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.l...@dnr.state.mn.uswrote: 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 33fad6880910300433i342c619am99935a6078966...@mail.gmail.com, Paul james paulj...@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.l...@dnr.state.mn.uswrote: 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 33fad6880910290557m71ee3fdatd470590e3256f...@mail.gmail.com, Paul james paulj...@gmail.com wrote: Hello guys... Ím got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmape x t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.35807 61718 75+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762i 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI)
I'm no expert on this one, but . . . If you do an NQUERY Mapserver needs to know which layer you plan on querying, either by name, explicitly through the call (layer=??) or by having the mapfile give them up by default (STATUS=default ??), either way, mapserver need to know somehow what to apply the query to, I think. Also, how do you want mapserver to output the results of the NQUERY? by templated output or . . . you can use NQUERYMAP I believe to get an image back of the NQUERY . . . bobb Paul james paulj...@gmail.com wrote: Hello guys... I´m got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmapext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762imgbox=0+0+1221+762 ( http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmapext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762imgbox=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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI) using MSSQL2008
It´s not the case... I´m using Layers on URL and the output is in template.html... I executed the same test using POSTGIS connection, and It worked fine ,,, I got my template filled up as result... Is there any difference using nquery with MSSQL2008 or maybe is a bug ? Thanks Paul On Thu, Oct 29, 2009 at 11:06 AM, Bob Basques bob.basq...@ci.stpaul.mn.uswrote: I'm no expert on this one, but . . . If you do an NQUERY Mapserver needs to know which layer you plan on querying, either by name, explicitly through the call (layer=??) or by having the mapfile give them up by default (STATUS=default ??), either way, mapserver need to know somehow what to apply the query to, I think. Also, how do you want mapserver to output the results of the NQUERY? by templated output or . . . you can use NQUERYMAP I believe to get an image back of the NQUERY . . . bobb Paul james paulj...@gmail.com wrote: Hello guys... I´m got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmapext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762imgbox=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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Help with NQuery error (CGI)
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 33fad6880910290557m71ee3fdatd470590e3256f...@mail.gmail.com, Paul james paulj...@gmail.com wrote: Hello guys... Ím got this error when trying to execute a Nquery : http://localhost/cgi-bin-54/mapserv.exe?map=Map.mapmode=nqueryLAYERS=TESTmapex t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875imgext=-58.3580761718 75+-11.42570625+-57.193525390625+-10.37101875map_size=1221+762imgxy=1221+762imgb 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
