topic Re: Edit feature layer in EGDB that is also published on Portal in Geodatabase Questions

Edit feature layer in EGDB that is also published on Portal

Peter_Green — Wed, 04 Sep 2024 13:01:44 GMT

Good afternoon.

I have a simple point feature layer that resides in an Enterprise Geodatabase/SQL Server (SDE). I created the layer to use in Field Maps. It includes various domains and attribute rules that I'd like to retain.

I have subsequently published this feature layer to our Portal as a Map Image (reference registered data) including the feature option so that it can ultimately be edited in Field Maps. This seemed to work fine and I am able to use the data in Portal to create a new Webmap.

The issue I've run into, and can't quite understand, is that after the feature layer was published I am no longer able to edit the feature layer in ArcGIS Pro. Any edits I try to make to the feature layer results in an error - "error 000464 cannot get exclusive schema lock...".

I appreciate why this may be the case but wondering if there is a way around this. Down the road I may, for example chose to make edits to the data or need to make changes to the attribute rules which will be easier in Pro. The only solution I can find is to delete the feature layer from our Portal which seems to remove the schema lock allowing me to edit the data in Portal.

This is not a long term option of course so wondering if there might be something I'm missing here.

A couple of points here

Versions: Enterprise 11.3 and Pro 3.3
Our Portal and Server are federated.

Thanks for any advice.

Re: Edit feature layer in EGDB that is also published on Portal

Marshal — Wed, 04 Sep 2024 13:15:51 GMT

You need to stop the map service in ArcGIS Server Manager to perform edits in ArcGIS Pro. Stopping the map service will release the lock.

Alternatively, I believe you can disable schema locking for the service in ArcGIS Server Manager. I haven't used that feature, but it sounds like it will prevent schema locking and allow edits while the service is still running.

https://enterprise.arcgis.com/en/server/latest/administer/windows/disabling-schema-locking-on-a-map-service.htm

Re: Edit feature layer in EGDB that is also published on Portal

Peter_Green — Wed, 04 Sep 2024 13:31:25 GMT

Thanks for the speedy reply, Marshal. That's done the trick. I was able to stop the service, make the edits and restart the service.

Re: Edit feature layer in EGDB that is also published on Portal

MarceloMarques — Wed, 04 Sep 2024 15:23:04 GMT

@Peter_Green
Publish as a Feature Service and you will be able to edit the data using the service in ArcGIS Pro, you can also edit the data using the service in Portal/ArcGIS Server web apps, and you shall also be able to edit the ArcSDE SQLServer featureclass directly in ArcGIS Pro as well.