[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
A .NET Framework error occurred

 

 

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: 24141: A number is expected at position 41 of the input. The input has o.
System.FormatException:
at Microsoft.SqlServer.Types.OpenGisWktReader.RecognizeDouble()
at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePoint()
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)
.

 

 

Cause.

You get this error message in Microsoft SQL Server 2008, when you execute a SELECT statement and that statement processes invalid geometry objects, as in the example below:

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

As you can see in the image, when defining the polygon's points we typed and "o" instead of zero.

 

Solution.

Review your geometry objects and correct where needed.


 

 

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