sde locks

[Anonymous User]

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.

[Anonymous User]

I’m still puzzling through this but it looks like any service that uses a feature class in a dataset puts a lock on every feature class in the dataset. Doesn’t even need to be in the service. Everything in the dataset gets a lock on it.

- Doug

[George_Thompson]

That is the expected behavior of feature datasets.

[Anonymous User]

Thanks. I should have thought of this earlier. It really helps to have some confirmation.

I wonder if there is an easy way to discover just what services are using what feature classes in a dataset? Short of digging through the projects that are publishing services…

(Like many of us I’m working from home now. My only internet option is satellite and the latency makes things pretty tough).

Doug

[ahagopian_coj]

Hello!  I know this post is over a year old but I came across it while searching for the answer to our problem. We have an sde setup that every dataset has a lock on it.  I setup a test dataset that absolutely no one is using and has no map services on it. Yet it too has a schema lock on it. What we are finding is that every feature class in sde regardless of map services or not has a lock on it. This means that no one can add fields so I have people exporting the data in sde to shapefiles then working in the shapefiles causing the data in sde to become out of date. Is there a setting or something else I am missing causing every dataset to have a lock on it?  We are at 10.6.1.

[MichaelVolz]

Doug:

Do you have a specific business requirement for having feature classes in feature datasets (topology maybe) as opposed to standalone feature classes?

[VinceAngelo]

Yup, "Lock one, lock them all."  This is fundamental property of feature datasets.

[Anonymous User]

Thank you George. That might just be the ticket.

I will look into it later, as things are a bit insane a the moment.

Doug

[George_Thompson]

Understand and good luck!