topic Re: Character limit for domain names? in ArcGIS Pro Questions

Character limit for domain names?

JoshMakesMaps — Mon, 28 Oct 2024 18:22:19 GMT

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.

Re: Character limit for domain names?

CodyPatterson — Mon, 28 Oct 2024 19:42:27 GMT

Hey @JoshMakesMaps

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

Cody

Re: Character limit for domain names?

DanPatterson — Mon, 28 Oct 2024 20:48:31 GMT

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

Re: Character limit for domain names?

JoshMakesMaps — Mon, 28 Oct 2024 23:25:45 GMT

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

Re: Character limit for domain names?

JoshMakesMaps — Mon, 28 Oct 2024 23:27:15 GMT

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

Re: Character limit for domain names?

fklotz — Tue, 04 Feb 2025 01:21:02 GMT

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.

Re: Character limit for domain names?

Bud — Sat, 08 Feb 2025 05:12:38 GMT

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

Re: Character limit for domain names?

SSWoodward — Mon, 10 Feb 2025 23:45:39 GMT

@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. 🙏

Re: Character limit for domain names?

Bud — Mon, 10 Feb 2025 18:05:37 GMT

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

Re: Character limit for domain names?

SSWoodward — Mon, 10 Feb 2025 18:17:03 GMT

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?

Re: Character limit for domain names?

Bud — Fri, 14 Feb 2025 02:28:54 GMT

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