topic Underlying DBMS Error sql 2012 in State & Local Government Questions

Underlying DBMS Error sql 2012

JenniferWoodward — Mon, 28 Jul 2014 21:45:30 GMT

Are there any compatability issues with arcgis server 10.2.2, sql 2012, and the governemnt model xml schema? I have my GDB set up and imported the model. I can create a new feature and edit fine. But when I try to import data or edit one of the features created by the XML schema I get this

Any ideas?

Re: Underlying DBMS Error sql 2012

AsrujitSengupta — Mon, 28 Jul 2014 22:24:30 GMT

Copy the entire dataset containing the feature class named "MunicipalBoundary" to a File gdb.
Delete the dataset from the sde geodatabase.
Copy/Paste that dataset from the file gdb back into the sde gdb
Check if you are still getting that error while editing.

Before trying/testing anything, please take a recent database backup to avoid any loss of data.

Re: Underlying DBMS Error sql 2012

JenniferWoodward — Mon, 28 Jul 2014 23:04:39 GMT

That did the trick. The DB was just the schema and no data so I did the copy paste on the whole thing and now I can edit all the layers that I have checked so far. Any thoughts as to the cause of this error incase it causes any other probelms?

Re: Underlying DBMS Error sql 2012

AsrujitSengupta — Mon, 28 Jul 2014 23:08:22 GMT

I am not exactly sure why that error came up, however I would always recommend loading the data into a File gdb first, make the modifications required there and then copy/paste the data to sde. That always works for me!