SQL Server is nasty with geometry "errors" (anything that doesn't conform to OGC valid geometry) and if spatial query results contain any invalid geometry it throws an exception.
If I recall correctly, MapGuide always tries a BBOX constrained query and then if that fails an unconstrained query, so you are seeing errors AND poor performance. This could also cause memory problems, since regardless of scale-dependent rendering when an invalid geometry is in view MapGuide will be working with the entire dataset. How is the data getting into SQL Express? Is there a way of adding a validity test on the way in? Note, MapGuide 2.1 is much more stable than 2.0 so your upgrade is a step in the right direction. Jason On 2010-01-25, JamesDudden <[email protected]> wrote: > > Hi, > Currently I am using MG 2.0 on windows server 2003 with IIS 5, MG Studio > 2009 and .net build. I have about 60 layers of data including raster, sdf, > MS Access and SQL Express. > > Recently there have been alot of instances of MG stalling and me having to > restart it to get things going again. > > Below I have pasted 5 minutes worth of todays error log. Does anybody > understand whtat these error mean and if so how can I stop them?? > > Any help or advice is welcomed. > > Regards > JD > > <2010-01-25T12:35:08> 127.0.0.1 Administrator > Error: An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET > Framework error occurred during execution of user-defined routine or > aggregate "geometry": > > System.ArgumentException: 24144: This operation cannot be completed > because the instance is not valid. Use MakeValid to convert the instance to > a valid instance. Note that MakeValid may cause the points of a geometry > instance to shift slightly. > > System.ArgumentException: > > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > > at Microsoft.SqlServer.T > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpQueryFeatures.Execute line 125 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpQueryFeatures.cpp > - MgServerRenderingService.QueryFeatures line 652 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerRenderingService.RenderForSelection line 1326 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerSelectFeatures.SelectFeatures line 249 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\feature\ServerSelectFeatures.cpp > An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error > occurred during execution of user-defined routine or aggregate "geometry": > System.ArgumentException: 24144: This operation cannot be completed because > the instance is not valid. Use MakeValid to convert the instance to a valid > instance. Note that MakeValid may cause the points of a geometry instance to > shift slightly. > System.ArgumentException: > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > at Microsoft.SqlServer.T > <2010-01-25T12:35:10> 127.0.0.1 Administrator > Error: Out of memory. > bad allocation > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpRenderDynamicOverlay.Execute line 109 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpRenderDynamicOverlay.cpp > - MgServerRenderingService.RenderDynamicOverlay line 305 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > Out of memory. > bad allocation > <2010-01-25T12:35:16> 127.0.0.1 Administrator > Error: Out of memory. > bad allocation > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpRenderDynamicOverlay.Execute line 109 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpRenderDynamicOverlay.cpp > - MgServerRenderingService.RenderDynamicOverlay line 305 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > Out of memory. > bad allocation > <2010-01-25T12:35:22> 127.0.0.1 > Error: Session has expired or is invalid. Please log in again. > StackTrace: > - MgSiteServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\site\SiteServiceHandler.cpp > - MgOpAuthenticate.Execute line 107 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\site\OpAuthenticate.cpp > - MgSecurityManager.Authenticate line 224 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\SecurityManager.cpp > - MgSessionCache.GetSessionInfo line 175 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\SessionCache.cpp > Session has expired or is invalid. Please log in again. > <2010-01-25T12:35:41> 127.0.0.1 Administrator > Error: Out of memory. > bad allocation > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpRenderDynamicOverlay.Execute line 109 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpRenderDynamicOverlay.cpp > - MgServerRenderingService.RenderDynamicOverlay line 305 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > Out of memory. > bad allocation > <2010-01-25T12:35:41> 127.0.0.1 Administrator > Error: Out of memory. > bad allocation > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpRenderDynamicOverlay.Execute line 109 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpRenderDynamicOverlay.cpp > - MgServerRenderingService.RenderDynamicOverlay line 305 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > Out of memory. > bad allocation > <2010-01-25T12:36:49> 127.0.0.1 Administrator > Error: Out of memory. > bad allocation > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpRenderDynamicOverlay.Execute line 109 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpRenderDynamicOverlay.cpp > - MgServerRenderingService.RenderDynamicOverlay line 305 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > Out of memory. > bad allocation > <2010-01-25T12:37:35> 127.0.0.1 Administrator > Error: Out of memory. > bad allocation > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpRenderDynamicOverlay.Execute line 109 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpRenderDynamicOverlay.cpp > - MgServerRenderingService.RenderDynamicOverlay line 305 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > Out of memory. > bad allocation > <2010-01-25T12:40:34> 127.0.0.1 Administrator > Error: An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET > Framework error occurred during execution of user-defined routine or > aggregate "geometry": > > System.ArgumentException: 24144: This operation cannot be completed > because the instance is not valid. Use MakeValid to convert the instance to > a valid instance. Note that MakeValid may cause the points of a geometry > instance to shift slightly. > > System.ArgumentException: > > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > > at Microsoft.SqlServer.T > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpQueryFeatures.Execute line 125 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpQueryFeatures.cpp > - MgServerRenderingService.QueryFeatures line 652 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerRenderingService.RenderForSelection line 1326 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerSelectFeatures.SelectFeatures line 249 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\feature\ServerSelectFeatures.cpp > An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error > occurred during execution of user-defined routine or aggregate "geometry": > System.ArgumentException: 24144: This operation cannot be completed because > the instance is not valid. Use MakeValid to convert the instance to a valid > instance. Note that MakeValid may cause the points of a geometry instance to > shift slightly. > System.ArgumentException: > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > at Microsoft.SqlServer.T > <2010-01-25T12:40:38> 127.0.0.1 Administrator > Error: An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET > Framework error occurred during execution of user-defined routine or > aggregate "geometry": > > System.ArgumentException: 24144: This operation cannot be completed > because the instance is not valid. Use MakeValid to convert the instance to > a valid instance. Note that MakeValid may cause the points of a geometry > instance to shift slightly. > > System.ArgumentException: > > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > > at Microsoft.SqlServer.T > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpQueryFeatures.Execute line 125 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpQueryFeatures.cpp > - MgServerRenderingService.QueryFeatures line 652 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerRenderingService.RenderForSelection line 1326 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerSelectFeatures.SelectFeatures line 249 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\feature\ServerSelectFeatures.cpp > An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error > occurred during execution of user-defined routine or aggregate "geometry": > System.ArgumentException: 24144: This operation cannot be completed because > the instance is not valid. Use MakeValid to convert the instance to a valid > instance. Note that MakeValid may cause the points of a geometry instance to > shift slightly. > System.ArgumentException: > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > at Microsoft.SqlServer.T > <2010-01-25T12:40:42> 127.0.0.1 Administrator > Error: An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET > Framework error occurred during execution of user-defined routine or > aggregate "geometry": > > System.ArgumentException: 24144: This operation cannot be completed > because the instance is not valid. Use MakeValid to convert the instance to > a valid instance. Note that MakeValid may cause the points of a geometry > instance to shift slightly. > > System.ArgumentException: > > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > > at Microsoft.SqlServer.T > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpQueryFeatures.Execute line 125 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpQueryFeatures.cpp > - MgServerRenderingService.QueryFeatures line 652 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerRenderingService.RenderForSelection line 1326 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerSelectFeatures.SelectFeatures line 249 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\feature\ServerSelectFeatures.cpp > An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error > occurred during execution of user-defined routine or aggregate "geometry": > System.ArgumentException: 24144: This operation cannot be completed because > the instance is not valid. Use MakeValid to convert the instance to a valid > instance. Note that MakeValid may cause the points of a geometry instance to > shift slightly. > System.ArgumentException: > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > at Microsoft.SqlServer.T > <2010-01-25T12:40:50> 127.0.0.1 Administrator > Error: An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET > Framework error occurred during execution of user-defined routine or > aggregate "geometry": > > System.ArgumentException: 24144: This operation cannot be completed > because the instance is not valid. Use MakeValid to convert the instance to > a valid instance. Note that MakeValid may cause the points of a geometry > instance to shift slightly. > > System.ArgumentException: > > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > > at Microsoft.SqlServer.T > StackTrace: > - MgRenderingServiceHandler.ProcessOperation line 83 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\RenderingServiceHandler.cpp > - MgOpQueryFeatures.Execute line 125 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\OpQueryFeatures.cpp > - MgServerRenderingService.QueryFeatures line 652 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerRenderingService.RenderForSelection line 1326 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\rendering\ServerRenderingService.cpp > - MgServerSelectFeatures.SelectFeatures line 249 file > d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\feature\ServerSelectFeatures.cpp > An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error > occurred during execution of user-defined routine or aggregate "geometry": > System.ArgumentException: 24144: This operation cannot be completed because > the instance is not valid. Use MakeValid to convert the instance to a valid > instance. Note that MakeValid may cause the points of a geometry instance to > shift slightly. > System.ArgumentException: > at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() > at Microsoft.SqlServer.T > > ----- > http://www.software-matters.co.uk Software Matters - > http://www.software-matters.co.uk/bespoke-database-design.html Bespoke > Database and Software Solutions > -- > View this message in context: > http://n2.nabble.com/Does-anybody-understand-these-errors-tp4454117p4454117.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
