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.
BUG-000174199: Inputting a domain name with length greater than 255 characters causes Pro 3.4 to crash.
For others who've participated in this tread, are you all running up on this limit? If so could you share the requirements from your org that lead to a domain name that is longer than 255 characters?
@SSWoodward The quote is from Esri Case #03829144 - Domain name length limits (Esri Canada Support - open case).
@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. 🙏
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...
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
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.
Thanks for testing on enterprise. I'll be able to test on a FGDB and mobile GDB then.
Those appear to be for Field Names, not necessarily Domain Names.
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
Hey @JoshMakesMaps
I just tested it on an Enterprise Geodatabase, and it appears that the limit is 255 characters.
Cody
Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
