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

[D Boyd]

Hi Tamas,

Thanks for the quick reply, I grabbed the new binaries but am now getting a
different error. The request seems to terminate while the error log is being
written do its now showing what is causing it. The page returns the "The
specified CGI application misbehaved by not returning a complete set of HTTP
headers" error message.

Any help would be greatly apreciated!

[Thu Aug 13 12:31:55 2009].204000 CGI Request 1 on process 2064
[Thu Aug 13 12:31:55 2009].204000 msMSSQL2008LayerOpen called datastatement:
PointPos FROM Points
[Thu Aug 13 12:31:55 2009].204000 MSMSSQL2008LayerOpen -- shared connection
not available.
[Thu Aug 13 12:31:55 2009].290000
msConnPoolRegister(PointData,connectiondata)
[Thu Aug 13 12:31:55 2009].290000 msMSSQL2008LayerRetrievePK: query = SELECT    
convert(varchar(50), sys.columns.name) AS ColumnName, sys.indexes.name FROM        
sys.columns INNER JOIN                      sys.indexes INNER JOIN                     
sys.tables ON sys.indexes.object_id = sys.tables.object_id INNER JOIN                     
sys.index_columns ON sys.indexes.object_id = sys.index_columns.object_id AND
sys.indexes.index_id = sys.index_columns.index_id ON                     
sys.columns.object_id = sys.index_columns.object_id AND
sys.columns.column_id = sys.index_columns.column_id WHERE    
(sys.indexes.is_primary_key = 1) AND (sys.tables.name = N'Points') 
[Thu Aug 13 12:31:55 2009].290000 msMSSQL2008LayerParseData: unique column =
PointID, srid='0', geom_column_name = PointPos, table_name=Points
[Thu Aug 13 12:31:55 2009].290000 msMSSQL2008LayerGetExtent called
[Thu Aug 13 12:31:55 2009].290000 msMSSQL2008LayerFreeItemInfo called
[Thu Aug 13 12:31:55 2009].290000 msMSSQL2008LayerClose datastatement:
PointPos FROM Points
[Thu Aug 13 12:31:55 2009].290000
msConnPoolRelease(PointData,connectiondata)
[Thu Aug 13 12:31:55 2009].290000 msConnPoolClose(connectiondata)
[Thu Aug 13 12:31:55 2009].321000 msMSSQL2008LayerOpen called datastatement:
PointPos FROM Points
[Thu Aug 13 12:31:55 2009].321000 MSMSSQL2008LayerOpen -- shared connection
not available.
[Thu Aug 13 12:31:55 2009].330000
msConnPoolRegister(PointData,connectionData)
[Thu Aug 13 12:31:55 2009].330000 msMSSQL2008LayerRetrievePK: query = SELECT    
convert(varchar(50), sys.columns.name) AS ColumnName, sys.indexes.name FROM        
sys.columns INNER JOIN                      sys.indexes INNER JOIN                     
sys.tables ON sys.indexes.object_id = sys.tables.object_id INNER JOIN                     
sys.index_columns ON sys.indexes.object_id = sys.index_columns.object_id AND
sys.indexes.index_id = sys.index_columns.index_id ON                     
sys.columns.object_id = sys.index_columns.object_id AND
sys.columns.column_id = sys.index_columns.column_id WHERE    
(sys.indexes.is_primary_key = 1) AND (sys.tables.name = N'Points') 
[Thu Aug 13 12:31:55 2009].331000 msMSSQL2008LayerParseData: unique column =
PointID, srid='0', geom_column_name = PointPos, table_name=Points
[Thu Aug 13 12:31:55 2009].331000 msMSSQL2008LayerFreeItemInfo called
[Thu Aug 13 12:31:55 2009].331000 msMSSQL2008LayerWhichShapes called
[Thu Aug 13 12:31:55 2009].331000 query_string_temp:SELECT
PointPos.STAsBinary(),convert(varchar(20), PointID) from Points WHERE
PointPos.STIntersects(Geometry::STGeomFromText('POLYGON((-1000000
-1000000,1000000 -1000000,1000000 1000000,-1000000 1000000,-1000000
-1000000))',0)) = 1 
[Thu Aug 13 12:31:56 2009].966000 msMSSQL2008LayerFreeItemInfo called
[Thu Aug 13 12:31:56 2009].966000 msMSSQL2008LayerClose datastatement:
PointPos FROM Points
[Thu Aug 13 12:31:56 2009].966000
msConnPoolRelease(PointData,connectiondata)
[Thu Aug 13 12:31:56 2009].966000 msConnPoolClose(connectionData)
[Thu Aug 13 12:31:56 2009].967000 msMSSQL2008LayerOpen called datastatement:
PointPos FROM Points
[Thu Aug 13 



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


-- 
View this message in context: http://n2.nabble.com/WFS%3A-msMSSQL2008LayerGetShapeRandom-bad-shape%3A-1-tp3431353p3437352.html
Sent from the Mapserver - User mailing list archive at Nabble.com.