topic Re: Check constraint violation in ArcGIS Pro Questions

Check constraint violation

Laura — Thu, 26 Jan 2023 17:35:17 GMT

I am trying to give users privileges in Pro and cannot add them so some layers without getting a check constraint violation. I can't open the properties for the specific layer in the Group Layer giving me the error either. I can't seem to find any documentation on this.

Re: Check constraint violation

Robert_LeClair — Tue, 31 Jan 2023 22:18:59 GMT

Hmmm...I would start by running the Diagnose Version Table (Data Management ) GP tool to see if there are any issues with the versioning system tables (A & D's) first. Based upon that, we can start digging deeper....

Re: Check constraint violation

Laura — Wed, 01 Feb 2023 14:22:31 GMT

How do I get to the tables log?

Re: Check constraint violation

Robert_LeClair — Wed, 01 Feb 2023 15:24:07 GMT

So the Diagnose Versions Tables Log is an ASCII file that is the output from the tool. You decide where the output should be written to - say C:\temp for example.

Re: Check constraint violation

Laura — Wed, 01 Feb 2023 15:27:25 GMT

Re: Check constraint violation

Robert_LeClair — Wed, 01 Feb 2023 15:30:13 GMT

Ahhhh...the dreaded 999999 errror code! Instead of writing the log file to your U: drive can you write it to your C: drive instead? Does it error out again?

Re: Check constraint violation

Laura — Wed, 01 Feb 2023 15:33:11 GMT

Sure does

Re: Check constraint violation

Robert_LeClair — Wed, 01 Feb 2023 16:01:47 GMT

Okay - I think I see what's happening in your screen shot. You're missing the Target Version parameter. See attached below for my GP tool. It worked as expected.

Re: Check constraint violation

Laura — Wed, 01 Feb 2023 16:07:24 GMT

Still fails

Re: Check constraint violation

Robert_LeClair — Wed, 01 Feb 2023 16:11:59 GMT

Okay - when I see strange things like this, one thing I do is rename the ESRI folder to ESRI_OLD. There are two ESRI folders to rename. One is in your C:\Users\<your_user_profile>\appdata\local and C:\Users\<your_user_profile>\appdata\roaming. Close ArcGIS Pro, rename the folders, restart and load your *.aprx and try the GP tool again. What is the result? Also are you using your SDE (GDB Administrator) for the input database connection parameter?

Re: Check constraint violation

Laura — Wed, 01 Feb 2023 16:26:19 GMT

Still errors out. I am using the SDE

Re: Check constraint violation

Robert_LeClair — Wed, 01 Feb 2023 17:09:06 GMT

Okay - next idea. Is the data in question in a Feature Dataset or a standalone feature class? If a feature dataset, unregister as versioned (as long as all edits have been emptied via compress), then re-register the FDS as versioned. If this fails, create a new FDS, copy/paste all FC's in FDS1 to the new FDS and try again. What is the result? If standalone - same workflow.

Re: Check constraint violation

Laura — Wed, 01 Feb 2023 19:17:56 GMT

I don't think these specific layers are actually versioned.

Re: Check constraint violation

Robert_LeClair — Wed, 01 Feb 2023 20:10:48 GMT

Okay, then let's try the workflow to create a new FDS, copy/paste the FC's from the old FDS to the new FDS, and try your workflow again. If standalone feature classes, then just make a copy of them and try the workflow on the new copies.