[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
A .NET Framework error occurred (2)

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

A .NET Framework error occurred during execution of user defined routine or aggregate 'geometry'.


Applies to: Microsoft SQL Server 2008 (Katmai) November CTP (CTP 5).



Error Message.

(local)(DOMAINNAME\amorillo): Msg 6522, Level 16, State 1, Line 3
A .NET Framework error occurred during execution of user defined routine or aggregate 'geometry':
System.FormatException: 24119: The Polygon input is not valid because the start and end points of the exterior ring are not the same. Each ring of a polygon must have the same start and end points.
System.FormatException:
at Microsoft.SqlServer.Types.GeometryDataBuilder.EndFigure()
at Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText(FigureAttributes attributes)
at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText()
at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonTaggedText()
at Microsoft.SqlServer.Types.OpenGisWktReader.ParseGeometryTaggedText()
at Microsoft.SqlServer.Types.OpenGisWktReader.ReadGeometry()
at Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
.

(local)(DOMAINNAME\amorillo): (1 row(s) affected)
 

 

Cause.

Each ring of a polygon must have the same start and end points. If you don't do this you would get the error shown above.
 

Solution.

Let's convert the original geometry instance into a valid one.

The original instance is the following:

Declare @shape geometry

SET @shape = geometry::STGeomFromText
('POLYGON ((0 0, 150 0, 150 150, 0 150, 150 150))',0)
SELECT @shape.ToString()

The valid instance would be:

SET @shape = geometry::STGeomFromText
('POLYGON ((0 0, 150 0, 150 150, 0 150, 0 0))',0)
SELECT @shape.ToString()
 


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.