Disable schema locking on a map service

An ArcGIS Server map service uses schema locking to prevent modifications to the source dataset schemas while the service is running. By default, schema locking is enabled on map services. If your workflow requires periodic updates to the dataset's schema without stopping the map service, for example, replacing feature classes as opposed to selectively updating rows within the schema, you can disable schema locking using ArcGIS Server Manager or ArcMap.

When schema locking is disabled, Esri recommends that you only update your source dataset schemas when the service is idle. If you update the dataset schema when the service is under load, users of your map service may experience unexpected behavior such as layers and fields missing, queries failing, and service unavailability. Changes to the dataset schema need to be carefully planned; permanently removing datasets may leave your map services in an inconsistent state.

Note:

Even when you disable schema locking in a map service, other ArcGIS applications and services may still be able to obtain exclusive locks to the schema. If you are unable to update the schema of the dataset after disabling schema locking, see Schema locking. This topic contains information that can help you understand how locks may be preventing you from updating the schema.

To disable schema locking, follow the steps in one of the sections below.

In Manager

1. Open Manager and log in.
2. Click Services > Manage Services.
3. In the Manage Services module, locate your map service and click Edit .

   If you don't see your map service in the list, it may be located within a subfolder under the Site (root) folder.

4. Click the Parameters tab.
5. In the Parameters tab, uncheck Lock Database Schema.
6. Click Save and Restart.

Schema locking is disabled for all the datasets referenced by your map service.

In ArcMap

1. Start ArcCatalog or ArcMap.
2. Expand the GIS Servers node in the Catalog tree.
3. Double-click Add ArcGIS Server and create an Administer GIS server connection to the server. For instructions on how to connect, see Make an administrative connection to ArcGIS Server in ArcMap. If you already have an administrative connection set up, you can skip this step.
4. Within your connection to ArcGIS Server, right-click the map service you want to edit and choose Service Properties.
5. Click the Parameters tab.
6. On the Parameters tab, click Advanced.
7. On the Advanced Properties dialog box, set the schemaLockingEnabled property to false.
8. Click OK.
9. On the Service Editor, click OK.

Schema locking is disabled for all the datasets referenced by your map service.