[Qgis-user] Fail to commit changes to SQL database

Johanna Botman Johanna.Botman at griffith.nsw.gov.au
Tue Sep 13 20:42:58 PDT 2016



I'm working on a [road] line layer and changing the geometry so that it
matches the aerial image. I can make some changes and save them, but then
suddenly I can't save anymore changes.
In the yellow line at the top of the canvas it says Commit Errors: Could
not commit changes to layer [road]. When I click the 'show more' it simply
says 'Errors: ERROR: [x] geometries not changed'

I can shut QGIS down and restart it. Then I still cannot change that last
geometry that caused the issue, but I can change others until I get that
message again. I have rebooted my machine and I made a little more progress
but still come up against the error.

My research in stack exchange yielded nothing in relation to SQL server,
but I asked our IT to have a look at the logs anyway. They said there was
nothing in the SQL logs either.

I am using QGIS 2.14.4 and this particular table is on a SQL server.

Any ideas?
_______________
Johanna Botman
GIS / Assets Officer

Griffith City Council
Ph: 02 6962 8168
Please consider the environment before printing this email notice.

--------------------------------------------------------------------
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. 
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.
This email was scanned and cleared by MailMarshal, Sophos and Kaspersky AV
---------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/67986709/attachment.html>


More information about the Qgis-user mailing list