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; } } }

esriExclusiveSchemaLock Error on Hosted Featre Layer

CodyPatterson

Hey all,

Enterprise 11.3

Today, I'm attempting to add a field to a hosted feature layer, that was created when making a Workforce app, so I did not upload this from ArcGIS Pro. This is interacting with the datastore database itself. I received this error here when attempting to add it:

So far, the only documents I see are stating that I need to ensure that I am the only user attempting these changes, and that I need to ensure that the GDB it's stored on when uploading from Pro has its locks cleared, these fit neither of my situation.

What does this error mean? How can I resolve it? This only is affecting a single hosted feature layer, others are perfectly fine, this is a synced and offline mode feature layer that I have added additional fields to before, but not anymore.

Cody

Find more posts tagged with

Content Management

Data and services

Accepted answers

All comments

RPGIS

Hey @ChristopherCounsell,

Have you tried overwriting the service or publishing a small subset of data to see if the lock has anything to do with the feature itself. Also, what kind of versioning is being used, if any, and does modifying the versioning fix anything?

ChristopherCounsell

Thanks.

We're seeing it on a hosted feature layer in 11.5, with Tasks enabled. It had been fine for a week. Possibly started after a schema change or appending data. Still investigating and testing fixes.

CodyPatterson

Hey @ChristopherCounsell

I did, but not in the way I would have liked and neither did Esri support, they said that it was more than likely a bugged layer. I had to recreate the entire hosted feature layer, and it repeated the same problem around a week later, we unfortunately had to give up the idea and move on to upgrading our enterprise environment and using Tasks.

Cody

ChristopherCounsell

hi @CodyPatterson , did you ever find a resolution to this? We are seeing it on a Hosted Feature Layer. Preventing adding/deleting fields, managing domains or deleting view layers

CodyPatterson

Hey @RyanUthoff

Great point and idea! I hadn't thought about unsharing it, but maybe that could end up working. I could definitely see that the lock may fail due to the excessive amount of users on, but didn't consider at that moment. I normally restart all servers on Friday, but I may try today if this doesn't work at the moment.

Cody

CodyPatterson

Hey @RPGIS

Unfortunately, I did not upload this from ArcPro and this is an attempt to add a field to a hosted feature layer created by Enterprise Portal from the Workforce app.

Cody

ryanuthoff

I know I commonly have issues like these with SQL EGDB's and not hosted, but maybe other people are actively using that hosted feature service and therefore, Esri can't get a lock? That's my best guess.

One thing that you could try is to un-share the hosted feature service with everyone to ensure that no one is actively using it, then try and add the new field. And worst case scenario, possibly restart the ArcGIS Data Store to clear out any orphaned locks or anything like that that could be causing issues.

RPGIS

Hi @CodyPatterson,

Try these options:

Close out of pro and reopen your project. Sometimes pro will randomly put locks on features for reasons unknown and that will impact some workflows.
Try publishing a new service and see if the copy allows for changes. If the copy allows for changes then it might have something to do with the service definition which will require it to be overwritten.
Try making a complete copy of the data and see if publishing it works. if that works then it might indicate that the service is probably corrupted.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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