Editing schema, privileges, table is read-only

CelinaR

Hello, I'm attempting to add fields to a point and a line feature within our parcel fabric (ArcGIS Enterprise 11.3). I followed the steps to log in to server manager to stop the service, and then to remove gdb locks. When I tried to open the Fields Data Design, I received the message "the table or feature class corresponding to this view is read-only".

Looking at the privileges of the feature dataset, I see that the only user/role is "sde". All feature names look like "OWNER.ProParcelFabric_Points".

Do we need to start over as far as publishing via a db connection as a db parcel fabric owner?

ESRI_PF.png

ThomasRickett_0-1739554588157.png

AmirBar-Maor

@CelinaR 

You need to be the 'owner' or the sys admin user to make a schema change.

Here are the steps to make schema changes for published branch version data. There is nothing unique in that regards with feature classes controlled by the parcel fabric:

1. Go to Server Manager > Parameters and uncheck the 'Lock Database Schema' Option
2. Click save and restart (this is a service level change that requires restarting)
3. Stop the service.
4. Add the new fields or make other changes to the feature class.
5. Start the service again.

 

If you use these fields to symbolize your layers, you can republish the layers with the existing service by using the 'overwrite' option from your existing publication map. This way you will keep any open versions and the edits they contain.
Some schema changes do not require to republish the data. It all depends if and how those changes impact the layers you have.

You can also consider going to the server manager to re-check the 'Lock Database Schema option' again.

 

1. Restart the service again