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

[Paul james]

Hi
I´m sending a point table that I´m using to test...

Layer definition :
LAYER
        NAME Test
        METADATA
            "wms_title"    "Test"   ##required

            "wms_feature_info_mime_type" "text/html"
        END
        TYPE POINT
        STATUS ON
        INCLUDE "Connection.map"
        DATA "the_geom from tblGeo_Porto USING UNIQUE CodigoPorto USING
SRID=0"

        TOLERANCE 14
        TEMPLATE "query.html"

        CLASS
            TEMPLATE "dummy"
            NAME "Test"
            STYLE
                SYMBOL 'test_15'
                COLOR 0 0 0
                ANTIALIAS TRUE
            END
        END
    END

Nquery CGI call :
http://localhost/cgi-bin-last/mapserv.exe?map=Map.map&mode=nquery&LAYERS=Test&mapext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&imgext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&map_size=1221+670&imgxy=1221+670&imgbox=0+0+1221+670

I got :
Content-type: text/html

Using Postgis (same code) works fine...

If you need, I can send the GetFeatureInfo code as well... But I think it´s
the same "bug" ...

The db data is attached...

Paul




On Tue, Mar 2, 2010 at 8:01 PM, Tamas Szekeres <szekerest at gmail.com> wrote:

> Paul
>
> It would be helpful to have some test data to reproduce your problem.
>
> In the meantime I've found an issue with regards of the query handling in
> the sql2008 driver and working on a fix right now, however I'm not sure if
> it is related to the problem of yours.
>
> Best regards,
>
> Tamas
>
>
> 2010/3/2 Paul james <pauljame at gmail.com>
>
> Hi ...
>>
>> I have the same error here using Getfeature and Mssql2008... Works fine
>> with Postgis connection ...
>>
>> My last test was using Getfeature with a Point Layer... The message
>> returned was :
>>
>>
>> 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>
>>
>> No error reported using DEBUG mode...
>>
>> The query generated was :
>>
>> SELECT convert(varchar(max), oid),convert(varchar(max),
>> id),the_geom.STAsBinary(),convert(varchar(20), oid) from viw_test WHERE
>> the_geom.STIntersects(Geometry::STGeomFromText('POLYGON((-62.4340041752662
>> -11.1071026733531,-61.8187697837838 -11.1071026733531,-61.8187697837838
>> -10.4918682818707,-62.4340041752662 -10.4918682818707,-62.4340041752662
>> -11.1071026733531))',0)) = 1
>>
>> That query executed in Analyser return the right result:
>> 0x010100000000917EFB3A104FC061A6ED5F598925C0
>>
>> Using CGI NQuery also doesnt work, returning :
>> Content-type: text/html
>>
>> If you need more details, let me know...
>>
>> Paul
>>
>>
>>
>>
>> On Tue, Mar 2, 2010 at 5:34 AM, Afroz Kannancheri <afrozk at gmail.com>wrote:
>>
>>>
>>> Dear Tamas,
>>>  Heres the debug log obtained when i clicked on the polygon
>>>
>>> [Tue Mar 02 12:28:47 2010].113000 msMSSQL2008LayerOpen called
>>> datastatement:
>>> geom from region1 USING UNIQUE id USING SRID=4326
>>> [Tue Mar 02 12:28:47 2010].113000 MSMSSQL2008LayerOpen -- shared
>>> connection
>>> not available.
>>> [Tue Mar 02 12:28:47 2010].957000
>>>
>>> msConnPoolRegister(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
>>> Security=false,01E39FC0)
>>> [Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerParseData: unique
>>> column =
>>> id, srid='4326', geom_column_name = geom, table_name=region1
>>> [Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerFreeItemInfo called
>>> [Tue Mar 02 12:28:47 2010].957000 in msMSSQL2008LayerGetItems  (find
>>> column
>>> names)
>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called
>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called
>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerWhichShapes called
>>> [Tue Mar 02 12:28:48 2010].113000 query_string_temp: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 WHERE
>>> geom.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
>>> [Tue Mar 02 12:28:48 2010].394000 msMSSQL2008LayerClose datastatement:
>>> geom
>>> from region1 USING UNIQUE id USING SRID=4326
>>> [Tue Mar 02 12:28:48 2010].394000
>>>
>>> msConnPoolRelease(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
>>> Security=false,01E39FC0)
>>> [Tue Mar 02 12:28:48 2010].394000
>>>
>>> msConnPoolClose(server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
>>> Security=false,01E39FC0)
>>> [Tue Mar 02 12:28:48 2010].410000 freeLayer(): freeing layer at 01E15180.
>>>
>>> Thnx
>>> Afroz
>>> --
>>> View this message in context:
>>> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4659685.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/20100303/651dc6d6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: My Received Files.rar
Type: application/octet-stream
Size: 1640 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100303/651dc6d6/attachment.obj>