[mapserver-users] WFS: msMSSQL2008LayerGetShapeRandom bad shape: 1

[Tamas Szekeres]

Hi,

You've probably run into the same problem which I've already fixed (in trunk
and branch-5-4) 2 days ago.
For more details see:

http://trac.osgeo.org/mapserver/ticket/3082

Windows binary packages (containing the fix) can be downloaded at:
http://vbkto.dyndns.org:1280/sdk/Default.aspx

Best regards,

Tamas


2009/8/12 D Boyd <davidboyd at ntlworld.com>

>
> Hi folks,
>
> I'm having a little trouble creating a WFS that takes data from a MS SQL
> 2008 database. I have a table that stores points of interest, the table has
> a unique field (PointID) and a geometry field (PointPos) that stores the
> location.
>
> Previously I created a WMS that serves a map with these points drawn on
> which worked fine, with the WFS however none of the points are being
> returned in the feature collection. The following is displayed in the error
> log:
>
> Wed Aug 12 15:55:11 2009].450000 in msMSSQL2008LayerGetItems  (find column
> names)
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerInitItemInfo called
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShape called for
> record
> = 1
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShape: select
> convert(varchar(max), PointID),convert(varchar(max),
> PointIdentifier),convert(varchar(max), PointDate),convert(varchar(max),
> PointClass),convert(varchar(max), PointSubClass),PointPos from Points where
> PointID = 1
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShapeRandom bad shape:
> 1
> [Wed Aug 12 15:55:11 2009].450000 mapserv request processing time
> (msLoadMap
> not incl.): 0.372s
>
> The getshape query in is returning the correct row with the PointPos in hex
> (tested SQL managment studio).
>
> The layer is as follows:
>
>    LAYER
>        NAME "PointData"
>        DEBUG 5
>
>        METADATA
>                wfs_title "Point data test"
>                gml_featureID "PointID"
>                wfs_version "1.0.0"
>                wfs_typename "PointData"
>        END
>
>        CONNECTIONTYPE PLUGIN
>        TYPE POINT
>        PLUGIN "C:/mapserver/msplugin_mssql2008.dll"
>        CONNECTION "sql connection string"
>        DATA "PointPos FROM Points"
>
>        STATUS ON
>
>        PROJECTION
>                "init=epsg:27700"
>        END
>        DUMP TRUE
>
>        CLASS
>                STYLE
>                        COLOR 0 0 255
>                END
>        END
>    END
>
> Any help with this issue would be greatly apreciated!
>
>
>
> --
> View this message in context:
> http://n2.nabble.com/WFS%3A-msMSSQL2008LayerGetShapeRandom-bad-shape%3A-1-tp3431353p3431353.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/20090812/f6106361/attachment-0001.html