Character limit for domain names?

[JoshMakesMaps]

Is there a character limit for domain names in geodatabases? Does it differ between file geodatabases (GDBs), enterprise geodatabases, and mobile geodatabases?

I searched online, but none of the web pages for GDB limitations mention domain names.

[CodyPatterson]

Hey @JoshMakesMaps 

I just tested it on an Enterprise Geodatabase, and it appears that the limit is 255 characters.

Cody

[JoshMakesMaps]

Thanks for testing on enterprise. I'll be able to test on a FGDB and mobile GDB then.

[DanPatterson]

file geodatabase 64 characters

File geodatabase size and name limits—ArcGIS Pro | Documentation

mobile  31 chars

Mobile geodatabase size and name limits—ArcGIS Pro | Documentation

I am sure the list goes on

[JoshMakesMaps]

Those appear to be for Field Names, not necessarily Domain Names.

[fklotz]

Domain names in File Geodatabases appear to accept 160 characters. If you attempt to enter more than 160 characters an error message can be seen stating: "Error 160277: The row contains a bad value. [GDB_Items], The row contains a bad value. [Field length exceeded. Field: Name. Value: redacted]"

I did not find the documentation on this length limitation, unless it is related to the "Feature class or table name length—160 characters" here File geodatabase size and name limits—ArcGIS Pro | Documentation

 Illegal characters in domain names are ' and ` as per Introduction to attribute domains—ArcGIS Pro | Documentation. With this in mind, I tested the creation of some interesting domain names such as "Domain #1", "This is my domain!" and "D0m@!n N@m3 G03$ H343" - ArcGIS Pro did not complain about these.  This is not a recommendation to use silly domain names, just an observation.  

[Bud]

Esri Case #03829144 - Domain name length limits

The character limit for a domain name does seem to be (based on testing) 255 characters.  In a file geodatabase, when the 256th character is entered, the software simply removes it and only uses the first 255 characters.

However, when testing in Oracle and SQL Server, adding the 256th character causes a crash.  I've tested with 3 Oracle databases (at 3 different versions all over Pro 2.x) and one SQL Server database.  I 've also tested with Pro 3.3x and 3.4x with the same results.

I will be logging a bug for this...

Idea: Indicate that domain name is too long

[Bud]

BUG-000174199: Inputting a domain name with length greater than 255 characters causes Pro 3.4 to crash.

[SSWoodward]

@Bud  Where is that quote taken from?  Interested to know what the supplied domain name is.  I do not see a crash when adding a domain with a 256 characters in my SQL or Oracle DB's and would like to reproduce. 

I see the expected truncation behavior going back to 3.0.

Update:

Thanks for opening this support case @Bud.  After investigating further, It is not workspace specific, and is only reproducible when adding the same very long named domain, twice, without saving, inside the domains view. Looks like a bug with the domains view itself and not the actual domain functionality of the workspace.  We're taking a deeper look.  Much thanks to users like all of you here for sharing your questions and experiences with us. 🙏

[Bud]

@SSWoodward The quote is from Esri Case #03829144 - Domain name length limits (Esri Canada Support - open case).