topic Re: Coded Domain Keeps Disappearing from Domain in Geodatabase Questions

Coded Domain Keeps Disappearing from Domain

KellyAlfaro_Haugen — Tue, 13 Oct 2020 17:16:01 GMT

I manage several multi-user geodatabases (SQL, Versioned, 10.5.1) and have never had a problem with adding a new coded domain value to an existing domain set in any of the databases.

Currently I am having an issue with one of the databases not retaining the new coded domain.

Workflow*:

Add a new coded value, it is there and everything appears fine.

Apply and refresh the database, value is still present.

Close and reopen ArcCatalog, open the database and the value is gone.

I found a similar post at How to add a new code value to existing domain? but the solution did not fit with the issues I am having.

There are no Subtypes, the domain is correctly connected to the field and all the existing codes work correctly.

I am owner and DBA for the database and this same layer happens to be in one of the other databases I manage. The domain applied correctly and with no problems in that database.

Re: Coded Domain Keeps Disappearing from Domain

JoeBorgione — Tue, 13 Oct 2020 18:35:59 GMT

Are you absolutely, positively 100% sure the user you are trying to edit the domain with is the actual owner of the domain? I ask because I was only 99.9% sure and that .1% got me....

Re: Coded Domain Keeps Disappearing from Domain

KellyAlfaro_Haugen — Tue, 13 Oct 2020 20:33:36 GMT

Yes 100%... I am logged into the server, using the account that has sysadmin, and I can change the domains in the other databases, on the same server, with the same permissions and set-up. (Good question though, I went and double checked to make sure)

I also tried doing this via python, which usually works, and it also failed. Even though the code reported success.

Re: Coded Domain Keeps Disappearing from Domain

JoeBorgione — Tue, 13 Oct 2020 21:11:19 GMT

Rats. That's a weird one alright! Something is hanging it up; grasping at straws but when was the last time you did an analyze and compress?

Re: Coded Domain Keeps Disappearing from Domain

KellyAlfaro_Haugen — Tue, 13 Oct 2020 22:35:01 GMT

This is an outlier database so it's been a while. I'll give it a try and see what happens.

Re: Coded Domain Keeps Disappearing from Domain

DanaNolan — Fri, 23 Oct 2020 15:58:52 GMT

Yes, I have, back in 10.4. Nothing worked (reloading from table, typing/copying in everything in the domain, GP append/remove value tools). I did not have the same problem with the domain in my file geodatabases. I had to use a new copy of the domain. After over a year, the problem went away, but I cannot explain why, but I was able to repoint features to the fixed domain with the original standard domain name. Plus the latest version of SDSFIE does not need that domain, so I rarely use it. It is possible that a compress or some other big change fixed it but no one noticed the change.

Re: Coded Domain Keeps Disappearing from Domain

KirstenFrost_Andersen1 — Wed, 02 Feb 2022 23:30:46 GMT

@KellyAlfaro_Haugen Did you ever figuring what was causing this issue for you and how to resolve it? I'm currently having the same issue.

Re: Coded Domain Keeps Disappearing from Domain

KellyAlfaro_Haugen — Thu, 03 Feb 2022 15:15:05 GMT

I ultimately deleted the domain and recreated it from scratch. No clue what happened or why. I have not had the problem since but we have also upgraded the databases in the meantime.

Re: Coded Domain Keeps Disappearing from Domain

KirstenFrost_Andersen1 — Thu, 03 Feb 2022 16:29:51 GMT

Good to know. Thank you for the feedback!