Check constraint violation

[Laura]

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.

[Robert_LeClair]

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

[Laura]

How do I get to the tables log?

[Robert_LeClair]

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.

[Laura]

[Robert_LeClair]

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?

[Laura]

Sure does 

[Robert_LeClair]

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.

[Laura]

Still fails

[Robert_LeClair]

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?