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

How do you release a schema lock to update a domain field when a service is published? Error 000464

APaulsen

I have a service published to our Portal. I stopped the service and still unable to tweak one character in a domain. I have also tried right clicking on the geodatabase, going to properties, connections, removing connections, though no avail. Direction??

Find more posts tagged with

Accepted answers

APaulsen

George,

I was able to get it to work by right clicking on the database through the catalog page and going to domains. For some reason having those features from that dbo owner connect in a map, I received that error.

All comments

George_Thompson

Can you see if there are any locks on the underlying tables?

https://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-sql-server/manage-geodatabase-locks.htm

How are you connecting to the EGDB? As the data owner or the Enterprise Geodatabase Admin?

https://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-sql-server/privileges-sqlserver.htm

The geodatabase administrator (the sde user) in an sde-schema geodatabase must be added to the processadmin fixed server role and granted VIEW DEFINITION privileges on the database to drop geodatabase connections. The Create Enterprise Geodatabase geoprocessing tool grants this role and privilege to the sde user. You can revoke this privilege and remove the user from the processadmin role after geodatabase creation but, if you do, the sde user will not be able to disconnect users from the geodatabase.

Geodatabase‌

APaulsen

I believe as the data owner.

gdb.JPG

George_Thompson

Ok, just saw the screenshot sorry about the other message.

I think that you would have to be connected as DBO (SYSADMIN or Db_Owner) in your case.

You also need to look at the locks tab and try to see what is locked and how it is locked (exclusive/schema/etc.)

APaulsen

George,

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.