Bug report #17182

Save Graduated Style to MSSQL Database Fails

Added by Martin Bain about 4 years ago. Updated about 4 years ago.

Category:Data Provider/MSSQL
Affected QGIS version:2.18.11 Regression?:No
Operating System:Win7 32 bit Easy fix?:No
Pull Request or Patch supplied:No Resolution:duplicate
Crashes QGIS or corrupts data:No Copied to github as #:25081


I tried to save a Graduated Style to the database but it failed with the message box:

"Unable to save layer style. It's not possible to insert a new record into the style table. Maybe this is due to table permissions. Please contact your database administrator."

I converted it to a rule based style and it saved without error.

I have been happily saving styles to the database for a while now and it always works but I think this is the first time I have tried to save a Graduated Style.

The offending style files are attached.

Thank you.

PipeAgeStyle.sld (7.88 KB) Martin Bain, 2017-09-22 03:55 AM

PipeAgeStyle.qml (32.2 KB) Martin Bain, 2017-09-22 03:55 AM

Related issues

Duplicates QGIS Application - Bug report #16937: Error saving graduated style in databases Closed 2017-07-27


#1 Updated by Giovanni Manghi about 4 years ago

  • Resolution set to duplicate
  • Status changed from Open to Closed

Duplicate of #16937

#2 Updated by Jürgen Fischer about 4 years ago

Also available in: Atom PDF