[mapserver-users] Re: Getfeatureinfo and MSsql 2008 server

[Tamas Szekeres]

Hmmm... That might be a different error. Do you have a debug log to get
further information about the problem? Or could you back up a test database
for me to reproduce this issue?

Best regards,

Tamas

2010/3/2 Afroz K <afrozk at gmail.com>

>  Dear Mr. Tamas,
>  I have upgraded my Mapserver from 5.4.2 to 5.6.1 . I still get the same
> message.
>
> Layer 'region1'
> Content-type: application/vnd.ogc.se_xml
> <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
> <!DOCTYPE ServiceExceptionReport SYSTEM "
> http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">
> <ServiceExceptionReport version="1.1.1">
> <ServiceException>
> </ServiceException>
> </ServiceExceptionReport>
>
> There are two notable changes after the upgrade
>
> 1. I no more get the error  "msMSSQL2008LayerGetShapeRandom bad shape: 1"
> in the log file.
> 2. The query coming to the SQL server has changed a bit now , though it
> gives me the correct result while running it on the query window.
>
> SELECT convert(varchar(max), ID),convert(varchar(max), name),convert(varchar(max),
> flag1),convert(varchar(max), flag2),convert(varchar(max),
> flag3),geom.STAsBinary(),convert(varchar(20), id) from region1 WHEREgeom.STIntersects(Geometry
> ::STGeomFromText('POLYGON((55.4843749962207
> -4.59960928778372,56.5390624973545 -4.59960928778372,56.5390624973545
> -3.54492178664993,55.4843749962207 -3.54492178664993,55.4843749962207
> -4.59960928778372))',4326)) = 1
>
> Thanks and regards
> Afroz
>
>  On Mon, Mar 1, 2010 at 4:28 PM, <afrozk at gmail.com> wrote:
>
>> Dear Tamaz,
>> My mapserver version is 5.4.2 .
>> I ll upgrade and let u know the results.
>>
>> Thnx a lot
>> Afroz
>>
>> Sent from my BlackBerry® smartphone from du
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100302/7d19c1ef/attachment.html