<html><body>
<p><font size="2" face="sans-serif">Thanks James,</font><br>
<br>
<font size="2" face="sans-serif">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.</font><br>
<br>
<font size="2" face="sans-serif">_______________<br>
Johanna Botman<br>
GIS / Assets Officer<br>
<br>
</font><br>
<font size="2" face="sans-serif">Griffith City Council<br>
Ph: 02 6962 8168</font><br>
<br>
<tt><font size="2">James Wood <jwood911@gmail.com> wrote on 15/09/2016 12:43:31 AM:<br>
<br>
> From: James Wood <jwood911@gmail.com></font></tt><br>
<tt><font size="2">> To: Johanna Botman <Johanna.Botman@griffith.nsw.gov.au></font></tt><br>
<tt><font size="2">> Cc: qgis-user@lists.osgeo.org</font></tt><br>
<tt><font size="2">> Date: 15/09/2016 12:43 AM</font></tt><br>
<tt><font size="2">> Subject: Re: [Qgis-user] Fail to commit changes to SQL database</font></tt><br>
<tt><font size="2">> <br>
> I have seen similar behavior with SQL Server 2012, so I would be <br>
> interested to hear from the user community as well. </font></tt><br>
<tt><font size="2">> <br>
> Johanna,</font></tt><br>
<tt><font size="2">> What version of SQL and is this SQL Spatial (ST Geometry)?<br>
> <br>
> Thanks,</font></tt><br>
<tt><font size="2">> James<br>
> Sent from my iPhone</font></tt><br>
<tt><font size="2">> <br>
> On Sep 13, 2016, at 22:42, Johanna Botman <Johanna.Botman@griffith.nsw.gov.au<br>
> > wrote:<br>
</font></tt><br>
<tt><font size="2">> I'm working on a [road] line layer and changing the geometry so that<br>
> it matches the aerial image. I can make some changes and save them, <br>
> but then suddenly I can't save anymore changes.<br>
> In the yellow line at the top of the canvas it says Commit Errors: <br>
> Could not commit changes to layer [road]. When I click the 'show <br>
> more' it simply says 'Errors: ERROR: [x] geometries not changed'<br>
> <br>
> I can shut QGIS down and restart it. Then I still cannot change that<br>
> last geometry that caused the issue, but I can change others until I<br>
> get that message again. I have rebooted my machine and I made a <br>
> little more progress but still come up against the error.<br>
> <br>
> My research in stack exchange yielded nothing in relation to SQL <br>
> server, but I asked our IT to have a look at the logs anyway. They <br>
> said there was nothing in the SQL logs either.<br>
> <br>
> I am using QGIS 2.14.4 and this particular table is on a SQL server.<br>
> <br>
> Any ideas?<br>
> _______________<br>
> Johanna Botman<br>
> GIS / Assets Officer<br>
> <br>
> Griffith City Council<br>
> Ph: 02 6962 8168 </font></tt><br>
<tt><font size="2">> </font></tt><br>
<tt><font size="2">> </font></tt>
<P><FONT size=2 face=Arial></FONT> </P>
<P><FONT size=2 face=Arial> </P>
<P>
<HR>
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. </FONT>
<P></P>
<P><FONT size=2 face=Arial>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.</FONT></P>
<P><FONT face=Arial><FONT size=2>This email was scanned and cleared by
MailMarshal, Sophos & Kaspersky AV<BR>
<HR>
</FONT></FONT>
<P></P>
</body></html>