topic Deleting Coded Value Domains in ArcSDE 10 outside ArcCatalog in Data Management Questions https://community.esri.com/t5/data-management-questions/deleting-coded-value-domains-in-arcsde-10-outside/m-p/472402#M26929 <HTML><HEAD></HEAD><BODY><SPAN>Original User: tomlind</SPAN><BR /><BR /><SPAN>After upgrade from ArcSDE 9.3.1 Oracle 11G to ArcSDE 10 Oracle 11G we encountered a reported bug NIM06359. Coded Value domains missing description causes ArcCatalog and ArcMap to crasch.</SPAN><BR /><BR /><SPAN>We cannot delete the domains in ArcCatalog because it crashes when trying to display database properties-&gt;domains.</SPAN><BR /><BR /><SPAN>We find the corrupt domains in GDB_ITEMS, and related rows in GDB_ITEMRELATIONSHIPS and SDE_XML_DOC1 (definition). Some domains have a null value in GDB_ITEMS.DEFINITION which must be an error?</SPAN><BR /><BR /><SPAN>Is there a possibility to delete the corrupted domains using sql? </SPAN><BR /><BR /><SPAN>What is the role of the tables named DR$XMLDOCIX2_TX$R etc? Are they to be taken into account if deleting rows in GDB_ITEMS?</SPAN><BR /><BR /><SPAN>We have an Esri Incident #912234, but have not really got through yet, so any help or instructions would be appreciated.</SPAN></BODY></HTML> Wed, 30 Mar 2011 14:27:28 GMT Anonymous User 2011-03-30T14:27:28Z Deleting Coded Value Domains in ArcSDE 10 outside ArcCatalog https://community.esri.com/t5/data-management-questions/deleting-coded-value-domains-in-arcsde-10-outside/m-p/472402#M26929 <HTML><HEAD></HEAD><BODY><SPAN>Original User: tomlind</SPAN><BR /><BR /><SPAN>After upgrade from ArcSDE 9.3.1 Oracle 11G to ArcSDE 10 Oracle 11G we encountered a reported bug NIM06359. Coded Value domains missing description causes ArcCatalog and ArcMap to crasch.</SPAN><BR /><BR /><SPAN>We cannot delete the domains in ArcCatalog because it crashes when trying to display database properties-&gt;domains.</SPAN><BR /><BR /><SPAN>We find the corrupt domains in GDB_ITEMS, and related rows in GDB_ITEMRELATIONSHIPS and SDE_XML_DOC1 (definition). Some domains have a null value in GDB_ITEMS.DEFINITION which must be an error?</SPAN><BR /><BR /><SPAN>Is there a possibility to delete the corrupted domains using sql? </SPAN><BR /><BR /><SPAN>What is the role of the tables named DR$XMLDOCIX2_TX$R etc? Are they to be taken into account if deleting rows in GDB_ITEMS?</SPAN><BR /><BR /><SPAN>We have an Esri Incident #912234, but have not really got through yet, so any help or instructions would be appreciated.</SPAN></BODY></HTML> Wed, 30 Mar 2011 14:27:28 GMT https://community.esri.com/t5/data-management-questions/deleting-coded-value-domains-in-arcsde-10-outside/m-p/472402#M26929 Anonymous User 2011-03-30T14:27:28Z