<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoPlainText>I get the same kind of commit errors when I change geometry for any of my SQL Spatial feature classes. I have traced the error back to the following error message in QGIS (version 2.16.2):<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText style='margin-left:.5in'><i>A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": System.FormatException: 24114: The label PointZ (1994269.8154 in the input well-known text (WKT) is not valid. Valid labels are POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION, CIRCULARSTRING, COMPOUNDCURVE, CURVEPOLYGON and FULLGLOBE (geography Data Type only). System.FormatException: at Microsoft.SqlServer.Types.OpenGisTypes.ParseLabel(String input) 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><i><o:p></o:p></i></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>My original geometry type is Point, and SQL Server does not recognize PointZ as a geometry type. This tells me that QGIS might be attempting a geometry move in SQL Server by updating the geometry field to the coordinates I move to, but writing a PointZ type. I am not sure if it attempts the same kind of thing for Linestring types (changing to LinestringZ for example).<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>I have this as an open question on GIS Stack Exchange: "Cannot commit simple edit actions (move or change node) in MSSQL feature class in QGIS". I am hoping a seasoned Python/QGIS developer can take a look at this, because I wouldn't mind using QGIS regularly for editing features in my enterprise database (in SQL Server).<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>-----Original Message-----<br>From: qgis-user-request@lists.osgeo.org [mailto:qgis-user-request@lists.osgeo.org] <br>Sent: Thursday, September 15, 2016 5:31 AM<br>To: qgis-user@lists.osgeo.org<br>Subject: Qgis-user Digest, Vol 127, Issue 41<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Send Qgis-user mailing list submissions to<o:p></o:p></p><p class=MsoPlainText> <a href="mailto:qgis-user@lists.osgeo.org"><span style='color:windowtext;text-decoration:none'>qgis-user@lists.osgeo.org</span></a><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>To subscribe or unsubscribe via the World Wide Web, visit<o:p></o:p></p><p class=MsoPlainText> <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user"><span style='color:windowtext;text-decoration:none'>http://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><o:p></o:p></p><p class=MsoPlainText>or, via email, send a message with subject or body 'help' to<o:p></o:p></p><p class=MsoPlainText> <a href="mailto:qgis-user-request@lists.osgeo.org"><span style='color:windowtext;text-decoration:none'>qgis-user-request@lists.osgeo.org</span></a><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>You can reach the person managing the list at<o:p></o:p></p><p class=MsoPlainText> <a href="mailto:qgis-user-owner@lists.osgeo.org"><span style='color:windowtext;text-decoration:none'>qgis-user-owner@lists.osgeo.org</span></a><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>When replying, please edit your Subject line so it is more specific than "Re: Contents of Qgis-user digest..."<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>------<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Message: 2<o:p></o:p></p><p class=MsoPlainText>Date: Thu, 15 Sep 2016 11:14:19 +1000<o:p></o:p></p><p class=MsoPlainText>From: Johanna Botman <<a href="mailto:Johanna.Botman@griffith.nsw.gov.au"><span style='color:windowtext;text-decoration:none'>Johanna.Botman@griffith.nsw.gov.au</span></a>><o:p></o:p></p><p class=MsoPlainText>To: James Wood <<a href="mailto:jwood911@gmail.com"><span style='color:windowtext;text-decoration:none'>jwood911@gmail.com</span></a>>, <a href="mailto:qgis-user@lists.osgeo.org"><span style='color:windowtext;text-decoration:none'>qgis-user@lists.osgeo.org</span></a><o:p></o:p></p><p class=MsoPlainText>Subject: Re: [Qgis-user] Fail to commit changes to SQL database<o:p></o:p></p><p class=MsoPlainText>Message-ID:<o:p></o:p></p><p class=MsoPlainText> <<a href="mailto:OF0F6F8398.671C32BF-ONCA25802F.0006A366-CA25802F.0006CE2D@griffith.nsw.gov.au"><span style='color:windowtext;text-decoration:none'>OF0F6F8398.671C32BF-ONCA25802F.0006A366-CA25802F.0006CE2D@griffith.nsw.gov.au</span></a>><o:p></o:p></p><p class=MsoPlainText> <o:p></o:p></p><p class=MsoPlainText>Content-Type: text/plain; charset="utf-8"<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Thanks James,<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>We are using SQL 2014 SP2. I don't know if we are using ST_Geometry. I have asked our consultant and he has not got back to me yet.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>_______________<o:p></o:p></p><p class=MsoPlainText>Johanna Botman<o:p></o:p></p><p class=MsoPlainText>GIS / Assets Officer<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Griffith City Council<o:p></o:p></p><p class=MsoPlainText>Ph: 02 6962 8168<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>James Wood <<a href="mailto:jwood911@gmail.com"><span style='color:windowtext;text-decoration:none'>jwood911@gmail.com</span></a>> wrote on 15/09/2016 12:43:31 AM:<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>> From: James Wood <<a href="mailto:jwood911@gmail.com"><span style='color:windowtext;text-decoration:none'>jwood911@gmail.com</span></a>><o:p></o:p></p><p class=MsoPlainText>> To: Johanna Botman <<a href="mailto:Johanna.Botman@griffith.nsw.gov.au"><span style='color:windowtext;text-decoration:none'>Johanna.Botman@griffith.nsw.gov.au</span></a>><o:p></o:p></p><p class=MsoPlainText>> Cc: <a href="mailto:qgis-user@lists.osgeo.org"><span style='color:windowtext;text-decoration:none'>qgis-user@lists.osgeo.org</span></a><o:p></o:p></p><p class=MsoPlainText>> Date: 15/09/2016 12:43 AM<o:p></o:p></p><p class=MsoPlainText>> Subject: Re: [Qgis-user] Fail to commit changes to SQL database<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> I have seen similar behavior with SQL Server 2012, so I would be <o:p></o:p></p><p class=MsoPlainText>> interested to hear from the user community as well.<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> Johanna,<o:p></o:p></p><p class=MsoPlainText>> What version of SQL and is this SQL Spatial (ST Geometry)?<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> Thanks,<o:p></o:p></p><p class=MsoPlainText>> James<o:p></o:p></p><p class=MsoPlainText>> Sent from my iPhone<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> On Sep 13, 2016, at 22:42, Johanna Botman<o:p></o:p></p><p class=MsoPlainText><Johanna.Botman@griffith.nsw.gov.au<o:p></o:p></p><p class=MsoPlainText>> > wrote:<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>> I'm working on a [road] line layer and changing the geometry so that <o:p></o:p></p><p class=MsoPlainText>> it matches the aerial image. I can make some changes and save them, <o:p></o:p></p><p class=MsoPlainText>> but then suddenly I can't save anymore changes.<o:p></o:p></p><p class=MsoPlainText>> In the yellow line at the top of the canvas it says Commit Errors:<o:p></o:p></p><p class=MsoPlainText>> Could not commit changes to layer [road]. When I click the 'show more' <o:p></o:p></p><p class=MsoPlainText>> it simply says 'Errors: ERROR: [x] geometries not changed'<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> I can shut QGIS down and restart it. Then I still cannot change that <o:p></o:p></p><p class=MsoPlainText>> last geometry that caused the issue, but I can change others until I <o:p></o:p></p><p class=MsoPlainText>> get that message again. I have rebooted my machine and I made a little <o:p></o:p></p><p class=MsoPlainText>> more progress but still come up against the error.<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> My research in stack exchange yielded nothing in relation to SQL <o:p></o:p></p><p class=MsoPlainText>> server, but I asked our IT to have a look at the logs anyway. They <o:p></o:p></p><p class=MsoPlainText>> said there was nothing in the SQL logs either.<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> I am using QGIS 2.14.4 and this particular table is on a SQL server.<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> Any ideas?<o:p></o:p></p><p class=MsoPlainText>> _______________<o:p></o:p></p><p class=MsoPlainText>> Johanna Botman<o:p></o:p></p><p class=MsoPlainText>> GIS / Assets Officer<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>> Griffith City Council<o:p></o:p></p><p class=MsoPlainText>> Ph: 02 6962 8168<o:p></o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>><o:p> </o:p></p><p class=MsoPlainText>Please consider the environment before printing this email notice.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>--------------------------------------------------------------------<o:p></o:p></p><p class=MsoPlainText>This e-mail, together with any attachments, is for the exclusive and confidential use of the addressee(s). Confidentiality is not waived if you are not the intended recipient. Any other distribution, use of, or reproduction without prior written consent is strictly prohibited. <o:p></o:p></p><p class=MsoPlainText>Views expressed in this e-mail are those of the individual, except where specifically stated otherwise. If this e-mail has been sent to you in error, please delete the e-mail completely and immediately from your system. Although reasonable precautions are taken, Griffith City Council does not warrant or guarantee this message to be free of errors, interference, viruses or similar malicious code and does not accept liability for any consequences to the recipient opening or using this email or attachments.<o:p></o:p></p><p class=MsoPlainText>This email was scanned and cleared by MailMarshal, Sophos and Kaspersky AV<o:p></o:p></p><p class=MsoPlainText>---------------------------------------------------------------------<o:p></o:p></p><p class=MsoPlainText>-------------- next part --------------<o:p></o:p></p><p class=MsoPlainText>An HTML attachment was scrubbed...<o:p></o:p></p><p class=MsoPlainText>URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20160915/c9440b3a/attachment-0001.html"><span style='color:windowtext;text-decoration:none'>http://lists.osgeo.org/pipermail/qgis-user/attachments/20160915/c9440b3a/attachment-0001.html</span></a>><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>------------------------------<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p></div></body></html>