topic Re: Append tool doesn't work after adding Global-ID's to generate attribute rules in ArcGIS Pro Questions

Append tool doesn't work after adding Global-ID's to generate attribute rules

Lila — Mon, 13 Sep 2021 10:47:37 GMT

Dear community, I have a problem with some global Id's. I am working with a SDE database. Now I had to add some attribute rules with arcade expressions for a table. For this reason I had to generate some global id's. The problem is, since I added these ID's, it is not possible to add new features from other datasets. Regardless of whether they also have Global ID's or not. I have run some minimalized examples with or without Global ID, with only two fields in the source table or all the same fields as in the target fields.I also checked the environment settings in the Append tool and flipped the switch to keep the object ID's. But nothing worked.
I always got this error message: " 000597: Failed to insert input record with FeatureID <value>". I hope someone has a solution for this problem. Thanks a lot.

Re: Append tool doesn't work after adding Global-ID's to generate attribute rules

JoeBorgione — Mon, 13 Sep 2021 14:01:37 GMT

If you google 'ESRI Error 000597', you get this return. Check the data you are appending for null values in fields where the target data does not allow null values.

Re: Append tool doesn't work after adding Global-ID's to generate attribute rules

Lila — Wed, 22 Sep 2021 09:44:31 GMT

Dear JoeBorgione, thank you for your answer. Unfortunately this doesn't solve my problem. I already checked all field settings. How i wrote before, i did some checks with the same feature class and the same field settings, just without Global IDs. It always worked without these IDs. Because of that I guess the problem lies in these.

Re: Append tool doesn't work after adding Global-ID's to generate attribute rules

tiztrain — Mon, 05 Feb 2024 06:59:29 GMT

@Lila did you ever figure this out cause I am having the same problem