ArcGIS Server – How to Resolve ArcGIS Server SDE Table Locks Issue

arcgis-serverenterprise-geodatabase

My ArcGIS Server services are locking tables in SDE. This is a problem if I need to edit or overwrite them. Unfortunately the locks don't go away upon stopping the services. The only solution I have found is to restart the Linux arcsde service, which has many implications. Is there a better way to lose these phantom locks?

Best Answer

Tell ArcGIS Server not to make those locks.

In your service cfg files, add this:

<ServerObjectConfiguration>
...
    <Properties>
         ...
         <SchemaLockingEnabled>false</SchemaLockingEnabled>
    </Properties>
</ServerObjectConfiguration>

ESRI does not recommend this practice, but it should work for you. I did this for a bunch of really big services that required a massive (thousands of layers) data update while still running.

For more info, refer to the ESRI docs.

Related Question