SDE Feature classes continue to get schema locks put on them even when no one is in them or have ever even opened them. It's driving me a bit nuts. Has anyone else seen this?
SDE 10.6.1 SQL 2012.
Thanks about info about build number.
The locks are not keeping us from updating data. There are only three of us and all is versioned.
What is so odd is that the general username for READERS with select privileges only will lock a feature class and I’m not able to modify schema such as add a field/column.
Not a big deal really, but –
Why is a reader locking the SDE feature class?
The locks are being put on at 1:02 am 1:03 am 1:05 am and then stops for a few hours. Then 5am. I can guarantee that no one is in this test feature class. Other feature classes get the same.
Thanks
Doug
The ".9270" part is the build number of the client that was used to upgrade / create the enterprise geodatabase.
Are the locks preventing you from doing any work or more just curious (or annoyed) about them?
Hey Vince,
The locks are pretty much all over the place. I understand that Catalog or a service or just an ArcMap session can lock something.
The offending server is where Enterprise is installed. The lock owner is Enterpriseservername.10.6.1.9270
We are enterprise 10.6.1 so the first part makes sense. 9270 makes no sense to me though. I plan on booting the server tomorrow morning for Win updates and that may give me a way to target in on it.
Note that this is also happening on a new feature class that I just created for testing. NO one is in it. Some refresh process I suspect.
Doug Pare
GIS Programmer/Analyst
Summit County Government
970-668-4221
Locks, by their very nature, tell you who has obtained them (host and connection user). This will tell you why they exist. The biggest offenders are feature dataset use (lock one, lock them all) and ArcGIS Server map services, but simply having ArcCatalog and ArcMap open at the same time can suffice (which is why I only use the Catalog window of ArcMap, not ArcCatalog).
- V
Are they part of a feature dataset or related table?
Schema locking—ArcGIS Help | Documentation
Are you attempting to update the schema?
Are there any active map services using that feature class?
You are going to need to provide some more information to get more responses .
Geodatabase
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
