OSGeo.org › OSGeo Software and Data Projects › MapServer › Mapserver - User

Help with NQuery error (CGI)

8 messages

Paul james

Help with NQuery error (CGI)

Reply Threaded

Hello guys...

I´m got this error when trying to execute a Nquery :

http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mapext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&imgbox=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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Bob Basques

Re: Help with NQuery error (CGI)

Reply Threaded

Some javascript/style in this post has been disabled (why?)

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 <[hidden email]> wrote:

Hello guys...

I´m got this error when trying to execute a Nquery :

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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Steve Lime

Re: Help with NQuery error (CGI)

Reply Threaded

In reply to this post by Paul james

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
<[hidden email]>, Paul
james
<[hidden email]> wrote:
> Hello guys...
> Ím got this error when trying to execute a Nquery :
>
http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mapex

>
t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.3580761718
>
75+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&imgb
> 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Paul james

Re: Help with NQuery error (CGI)

Reply Threaded

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 <[hidden email]> 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
<[hidden email]>, Paul

james
<[hidden email]> wrote:

> Hello guys...
> Ím got this error when trying to execute a Nquery :
>
http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mapex

>
t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.3580761718
>
75+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&imgb
> 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Steve Lime

Re: Help with NQuery error (CGI)

Reply Threaded

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
<[hidden email]>, Paul
james
<[hidden email]> 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

<[hidden email]>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
>> <[hidden email]>, Paul
>> james
>> <[hidden email]> wrote:
>> > Hello guys...
>> > Í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
>>

_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Paul james

Re: Help with NQuery error (CGI)

Reply Threaded

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 <[hidden email]> 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
<[hidden email]>, Paul

james
<[hidden email]> 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
<[hidden email]>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
>> <[hidden email]>, Paul
>> james
>> <[hidden email]> wrote:
>> > Hello guys...
>> > Í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
>>

_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Steve Lime

Re: Help with NQuery error (CGI)

Reply Threaded

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
<[hidden email]>, Paul
james
<[hidden email]> 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
<[hidden email]>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
>> <[hidden email]>, Paul
>> james
>> <[hidden email]> 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
>> <[hidden email]>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
>> >> <[hidden email]>,

Paul

>> >> james
>> >> <[hidden email]> wrote:
>> >> > Hello guys...
>> >> > Í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
>> >>
>>

_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Paul james

Re: Help with NQuery error (CGI)

Reply Threaded

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 <[hidden email]> 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
<[hidden email]>, Paul

james
<[hidden email]> 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
<[hidden email]>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
>> <[hidden email]>, Paul
>> james
>> <[hidden email]> 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
>> <[hidden email]>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
>> >> <[hidden email]>,
Paul
>> >> james
>> >> <[hidden email]> wrote:
>> >> > Hello guys...
>> >> > Í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
>> >>
>>

_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users