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

Update Domain

aoshea_gs

I am getting the following message: Failed to update one of the domains. Must be the owner to perform this operation. I am logged in as the data owner. I have also tried as the sde user and get the same message. Any ideas?

タグ付けされた投稿をもっと見る

Accepted answers

All comments

TimDine

I'd like to update the owner of a domain using an update query in Oracle. Does anyone have an update query for oracle which will change the Owner text node value for a given item name?

RandyKreuziger

What if the owner has left the company? Is there a way to change the owner of a domain?

baohuachu3

I would double-check to make sure who the owner of the domain is. Take a look at the following link for the correct query:

http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_java_help/index.html#//0092000013v7000000.htm

Note: The SQL Server query is for a repository owned by the DBO schema. If your schema is owned by SDE, you will need to update the dbo owner to sde. Ex:
--SQL Server
SELECT items.Name AS "Domain Name",
 items.Definition.value('(/*/Owner)[1]','nvarchar(max)') AS "Owner"
FROM sde.GDB_ITEMS AS items INNER JOIN sde.GDB_ITEMTYPES AS itemtypes
ON items.Type = itemtypes.UUID
WHERE itemtypes.Name IN ('Coded Value Domain', 'Range Domain')

After execute the sql above I found the domain's owner is "ADMAG001". This is one user of SqlServer.
The domains are created by import. All new created domain is "DBO". The new create domains can be updated and deleted.
Can we update the owner of domain to "DBO" and then can update/delete the domains?
If yes ,the sql is as this :
update sde.GDB_ITEMS set items.Definition.value('(/*/Owner)[1]','nvarchar(max)') ='DBO'

EyadHammad

thanks for the tip,

i was unable to configure SQL to run this query though i applied all the recommendations and settings provided in the help (http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_java_help/index.html#/Configuring_the_Oracle_listener_to_use_ST_Geometry_and_ST_Raster/0092000001s6000000/ ). it used to be an easy thing when needing to query the domain owner .. or other similar attributes ..

JakeSkinner

I would double-check to make sure who the owner of the domain is. Take a look at the following link for the correct query:

http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_java_help/index.html#//0092000013v7000000.htm

Note: The SQL Server query is for a repository owned by the DBO schema. If your schema is owned by SDE, you will need to update the dbo owner to sde. Ex:

--SQL Server
SELECT items.Name AS "Domain Name",
 items.Definition.value('(/*/Owner)[1]','nvarchar(max)') AS "Owner"
FROM sde.GDB_ITEMS AS items INNER JOIN sde.GDB_ITEMTYPES AS itemtypes
ON items.Type = itemtypes.UUID
WHERE itemtypes.Name IN ('Coded Value Domain', 'Range Domain')

EyadHammad

i am facing the same problem. the data-owner is not being able to modify his domains, nor any other user can. please help

jaythyen

Has this been resolved? I'm receiving the same error (with ArcSDE 10). The only "fix" I could find was for ArcSDE 9.1 and older, and it fixes the owner column of the GDB_Domains table in SQL (which is not very helpful with the newer version).

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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