Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

JordanMiller4 — Wed, 27 Sep 2017 11:56:15 GMT

I'm trying to add coded values to a new created domain using Arcpy in ArcCatalog but I keep getting this strange error. The domain gets created but the coded values generate an error. I used this exact python tool for a local file geodatabase with no issues so I don't understand why there would be problems with an enterprised geodatabase.

Software:

ArcGIS Desktop version: 10.3.1

Enterprise Geodatabase version: 10.3.1

SQL 2012

Code:

import arcpy
from arcpy import env

domName = "test"
gdb = "GIS.sde"

env.workspace = "C:\Users\jnmiller\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog"
arcpy.CreateDomain_management(gdb, domName, "Test Materials", "TEXT", "CODED")

domDict = {"CI":"Cast iron", "DI": "Ductile iron", "PVC": "PVC", \

"ACP": "Asbestos concrete", "COP": "Copper"}

for code in domDict:
arcpy.AddCodedValueToDomain_management(gdb, domName, code, domDict

Error: Why does this list every single domain already created in the database?

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

FC_Basson — Thu, 24 Mar 2022 07:01:46 GMT

I found that the arcpy command syntax was the issue.

Replace the following arcpy commands:
arcpy.CreateDomain_management with arcpy.management.CreateDomain
arcpy.AddCodedValueToDomain_management with arcpy.management.AddCodedValueToDomain

See the syntax here: https://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/create-domain.htm

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

Cristian_Galindo — Wed, 25 May 2022 13:45:35 GMT

It does not make sense, because the example in the same documentation states:

# Process: Create the coded value domain arcpy.CreateDomain_management("montgomery.gdb", domName, "Valid pipe materials", "TEXT", "CODED") #Store all the domain values in a dictionary with the domain code as the "key" and the #domain description as the "value" (domDict[code]) domDict = {"CI":"Cast iron", "DI": "Ductile iron", "PVC": "PVC", \ "ACP": "Asbestos concrete", "COP": "Copper"} # Process: Add valid material types to the domain #use a for loop to cycle through all the domain codes in the dictionary for code in domDict: arcpy.AddCodedValueToDomain_management(gdb, domName, code, domDict[code]) # Process: Constrain the material value of distribution mains arcpy.AssignDomainToField_management(inFeatures, inField, domName)

are those, two different syntaxes for the same implementation? or are two different implementations?

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

FC_Basson — Thu, 26 May 2022 07:58:53 GMT

Same kind of question here: https://community.esri.com/t5/python-questions/arcpy-management-lt-gp-tool-gt-vs-arcpy-lt-gp-tool/td-p/66673. So I guess it is the same implementation, but with different syntax. The old syntax broke my GP tool that I created in Pro, but changing it to the new syntax made it work.

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

Cristian_Galindo — Fri, 27 May 2022 09:32:17 GMT

I understand that now your GP tool work....How, if the the implementation and the tool are the same, the syntax breaks that, moreover, when the errors shows, that something was executed, therefore it was not something related with python syntax.

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

FC_Basson — Fri, 27 May 2022 09:54:11 GMT

Well, I'm also not sure why the "modern" version of the syntax resolved my issue, but that was the only way I could get the tool to work. What I also found was the autocomplete for the commands in the Python console in Pro automatically selects the modern syntax as specified in the parameters for the tool in all the docs. Hopefully, someone from Esri can give us more insight into the issue.

topic Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example in ArcGIS Collector Questions

Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example

Re: Cannot add coded values to Domains for SDE Enterprise Geodatabase using .py Example