[mapguide-users] Does anybody understand these errors?
Jason Birch
jason at jasonbirch.com
Mon Jan 25 12:31:28 EST 2010
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 <jamesdudden at blueyonder.co.uk> 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
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
More information about the mapguide-users
mailing list