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

[D Boyd]

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.