[QGIS-Developer] Unable to commit changes to MSSQL Server

Ethan Synder techrules08041 at yahoo.com
Wed Jan 9 06:05:13 PST 2019

Hi, I have seen this question appear on the QGIS-Users mailing list, but with no answer (also old posts from QGIS 2.14). I'm using QGIS 3.2.0. My problem is that I can move a features vertices, but not add. This is the error that I get:
[Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": 
 System.FormatException: 24142: Expected "NULL" at position 112. The input has "nan,".


 at Microsoft.SqlServer.Types.WellKnownTextReader.RecognizeToken(String token)

 at Microsoft.SqlServer.Types.WellKnownTextReader.RecognizeOptionalKeyword(String keyword)

 at Microsoft.SqlServer.Types.WellKnownTextReader.RecognizeOptionalDouble()

 at Microsoft.SqlServer.Types.WellKnownTextReader.ParseLineStringText()

 at Microsoft.SqlServer.Types.WellKnownTextReader.ParsePolygonText()

 at Microsoft.SqlServer.Types.WellKnownTextReader.ParseTaggedText(OpenGisType type)

 at Microsoft.SqlServer.Types.WellKnownTextReader.Read(OpenGisType type, Int32 srid)

 at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)

 . [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. QODBC3: Unable to execute statement

I figured that this error (Expected "NULL" and got "nan") is an internal problem and that this would be the place to put this.This error is also present in the new 3.4.3.

Thank you for your time
Ethan Snyder
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190109/bbead033/attachment.html>

More information about the QGIS-Developer mailing list