[mapserver-users] WFS: msMSSQL2008LayerGetShapeRandom badshape: 1

[Steve Lime]

Is this from the 5.4 branch or the main trunk? I'd stick with the 5.4 branch if at all possible. There's
change going on in the trunk that could result in problems, especially with drivers that I can't test.

Steve

>>> On 8/13/2009 at 6:45 AM, in message <1250163903613-3437352.post at n2.nabble.com>,
D Boyd <davidboyd at ntlworld.com> wrote:

> 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
>