nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query ArcGIS Services where "Lock Database Schema" is True

JoshLehn

Does anyone know how we can search our services for this parameter, or set the default to false?? These are really hard to find without clicking into each individual service!

UPDATE: Jake showed us how to find them with python, but we are now finding that the Services do not seem to be respecting/modifying the information in the configuration store (even after stop/starting). Has anyone experienced this or know how we might resolve this?

Vind meer berichten getagd met

Accepted answers

jskinner

Hi Josh,

One way you could search this is by using Python. Ex:

import os, json

for root, dirs, files in os.walk(r"C:\arcgisserver\directories\arcgissystem\arcgisinput"):
    for name in files:
        if 'serviceconfiguration.json' in name:
            json_data = open(os.path.join(root, name))
            data = json.load(json_data)
            values = data['service']
            try:
                properties = values['properties']                
                if properties['schemaLockingEnabled'] == 'false':
                    print values['serviceName']
            except:
                pass

All comments

BeccaBlackman1

My DBA helped me alter the above code so it would work on the non-static json files for the services:

import os, json

for root, dirs, files in os.walk(r"C:\arcgisserver\config-store\services"):
    for name in files:
        if name.endswith('.json') and name != 'FolderInfo.json':
            filename = os.path.join(root, name)
            json_data = open(os.path.join(root, name))
            data = json.load(json_data)

            try:
                properties = data['properties']
                if properties['schemaLockingEnabled'] == 'true':
                    print data['serviceName']
            except:
                pass

This helped me check that I had fixed all the 'false' to 'true'

JamesVogl

I think that the "serviceconfiguration.json" files located in /arcgisinput are static and written to only once upon creation of the service. The configuration files that are updated whenever changes are made are the ones located in the configuration store directory. (C:\arcgisserver\config-store\services\<servicename>.MapServer.json).

JoshLehn

I've got another question for you. How can i actually modify the property to set the flags to false if they are enabled? I tried several different ways of setting the json property in the "if properties['schemaLockingEnabled'] == 'false':" section, but couldn't get one to stick so I thought I'd ask for your approach.

XanderBakker

I have used the Catalog window for that purpose and that seems to work.

In the Catalog window (or using ArcCatalog) Connect to your ArcGIS Server with admin rights, go to the parameters tab and click on the button Advanced. At the bottom, you will see the property and you can change the value to "false" (just write it).

JoshLehn

Awesome code, thank you!

Here is the next puzzler, we're finding that the configuration store does not seem to be updating the "schemaLockingEnabled" property when we toggle it in server manager, even after restarting the service. Have you experienced this before??

jskinner

Hi Josh,

One way you could search this is by using Python. Ex:

import os, json

for root, dirs, files in os.walk(r"C:\arcgisserver\directories\arcgissystem\arcgisinput"):
    for name in files:
        if 'serviceconfiguration.json' in name:
            json_data = open(os.path.join(root, name))
            data = json.load(json_data)
            values = data['service']
            try:
                properties = values['properties']                
                if properties['schemaLockingEnabled'] == 'false':
                    print values['serviceName']
            except:
                pass

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Inloggen
Registreren

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.