topic Re: failed to delete domain from dataset,the domain is used as default domain in Data Management Questions

failed to delete domain from dataset,the domain is used as default domain

JoseSanchez — Tue, 19 Oct 2010 14:33:25 GMT

How can I remove domaisn from a SDE instance? I am getting the following error emssage:

"failed to delete domain from dataset, the domain is used as default domain "

Please advice

Re: failed to delete domain from dataset,the domain is used as default domain

NickKenczka — Wed, 15 Jun 2011 13:54:38 GMT

How can I remove domaisn from a SDE instance? I am getting the following error emssage:

"failed to delete domain from dataset, the domain is used as default domain "

Please advice

Jose,

Did you ever figure this one out? I'm having the same issue as we speak

Re: failed to delete domain from dataset,the domain is used as default domain

claystevens — Thu, 27 Oct 2011 20:49:21 GMT

Same problem. Does anybody have any solutions?

Re: failed to delete domain from dataset,the domain is used as default domain

HenrikSvenningsen — Fri, 28 Oct 2011 05:38:59 GMT

If you are using the domain on af dataset or feature class, then you can't delete it. You'll have to find where you are using it (i think there is a script for that) an change that before you can delete.

Re: failed to delete domain from dataset,the domain is used as default domain

NanaDei — Fri, 28 Oct 2011 23:29:02 GMT

SQL from the following link can be used in finding which feature classes are using a specific domain in an ArcSDE 10 geodatabase.

--
http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Discovering_domain_usage/009300001647000000/

The following queries can be used with a 93 sde geodatabases.
----
1. This sql lists all the domains that have been applied at the feature class level:

SELECT DO.owner domain_Owner, FI.defaultdomainname domain_Name,OC.owner Object_Owner,OC.name Object_Name,FI.fieldname Field_Name
FROM sde.gdb_objectclasses OC,sde.gdb_fieldinfo FI, sde.gdb_domains DO
WHERE OC.id=FI.classid AND DO.domainname=FI.defaultdomainname
AND FI.defaultdomainname IS NOT NULL
ORDER BY domain_Owner, domain_Name,Object_Owner,Object_Name

2. This sql lists all the domains that have been applied at the subtype level:

SELECT DM.owner domain_Owner,DM.domainname domain_Name,OC.name Object_Name,ST.subtypename Subtype_Name,AR.fieldname Field_Name
FROM sde.gdb_domains DM,sde.gdb_objectclasses OC,sde.gdb_subtypes ST,sde.gdb_attrrules AR,sde.gdb_validrules VR
WHERE (AR.domainname=DM.domainname) AND (AR.ruleid=VR.id) AND (VR.classid = OC.id) AND(AR.subtype=ST.subtypecode)
ORDER BY domain_Owner,domain_Name,Object_Name,Subtype_Name
============

Thanks