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

Cannot Delete a version - Error 000386 Locked by database user

Anonymous User

We are up and running with a production parcel fabric and have set up a team of 3 users with child versions from default.

We've been encountering issues with one of the users in particular. When he attempts to validate topology he gets an error message that the version is currently in use. We couldn't figure out a way to get past that issue so we had the user create a new version from default and then try again. He was able to do it once but he ultimately ended up seeing the same message.

He's created a third version and is able to post/reconcile.

When attempting to remove the two previous versions I'm getting this error.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/tool-errors-and-warnings/001001-010000/tool-errors-and-warnings-00376-00400-000386.htm

Where can I go to kill any connections that might be preventing the version from being removed?

The user rebooted both PCs he had been working on that might have had locks but i still cant remove the versions.

ArcGIS Pro 2.6.8 (latest service pack)

ArcGIS Enterprise 10.8.1

Parcel Fabric 3

SQL Server

Find more posts tagged with

Accepted answers

KenGalliher1

Hello,

You can manually inspect and delete connections and locks from the sde geodatabase connection. Right click the .sde connection file and choose Properties > Connections then click the "Show connected users and locks" button.

This will open up the connections and locks dialog. Choose the Locks tab and locate the lock(s) of the problem version. Select the locks you wish to remove, right click the selection and choose Disconnect

Another possible option is to purge the locks using the REST endpoint. Go to the service's VersionManagementServer endpoint and open the purgeLocks page.

Please see the documentation for purgeLock before proceeding:
Purge Lock—ArcGIS REST APIs | ArcGIS Developers

Example:
https://server.domain.com/server/rest/services/MyParcelFabric/VersionManagementServer/purgeLock

Enter the name of the version as owner.version_name and click purgeLock(POST)

All comments

KenGalliher1

Hello,

Another possible option is to purge the locks using the REST endpoint. Go to the service's VersionManagementServer endpoint and open the purgeLocks page.

Please see the documentation for purgeLock before proceeding:
Purge Lock—ArcGIS REST APIs | ArcGIS Developers

Example:
https://server.domain.com/server/rest/services/MyParcelFabric/VersionManagementServer/purgeLock

Enter the name of the version as owner.version_name and click purgeLock(POST)

AmirBar-Maor

If the above doesn't work please contact technical support so they can have a closer look.

Anonymous User

Thank you! That was exactly what I needed. I was able to remove the locks and then could delete the version.

Join the Conversation

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

Quick Links

All Communities
Recent Posts
Followed Content
Community Help

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