topic Re: Append data Using ArcGIS Pro in ArcGIS Online Questions

Append data Using ArcGIS Pro

NadimHammoud — Wed, 05 Jan 2022 07:55:52 GMT

Hello,

I've been trying to append a feature layer to a feature layer on ArcGIS online which worked.

however, when I'm appending the repeated table to the repeated table I'm getting this error.

any idea on how to fix this?

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds

General function failure [Error code: 1000. Description: The INSERT statement conflicted with the FOREIGN KEY constraint "REL_FK_service_7312cd40fb0a4e609ecafdeba8404f00_SIZE_NUMBER_CLASS_0". The conflict occurred in database "db_17295", table "user_17295.service_7312cd40fb0a4e609ecafdeba8404f00_MEHE_AUDIT_SURVEY_FULL_V2022", column 'globalid'.

Re: Append data Using ArcGIS Pro

Roxana_ElenaUrdea — Wed, 05 Jan 2022 09:06:07 GMT

Hi,

I thing the issue is related to your inputs that seem to be in a sde database and not in a geodatabase. I can read a foreign key constraint that is violated when trying to append features because you are duplicating them.

Regards,

Re: Append data Using ArcGIS Pro

NadimHammoud — Wed, 05 Jan 2022 09:23:20 GMT

Hi Roxana,

the table is m appending to has 0 records.

while the origin table is a repeated table generated from a published data collection survey with no duplicate Object ID or Global ID.
any idea how to solve the issue?

Re: Append data Using ArcGIS Pro

Roxana_ElenaUrdea — Wed, 05 Jan 2022 09:31:03 GMT

Start again by creating a brand new target feature class. Use create feature class tool and set your origin tables as template. Check the output of this operation - feature class properties and assure it does not have key constraints. Then try again the append operation.

Re: Append data Using ArcGIS Pro

IanGallo — Wed, 16 Nov 2022 22:34:03 GMT

Hi @NadimHammoud any luck with this issue? I'm running into the same thing.

Re: Append data Using ArcGIS Pro

BethanyCrenshaw1 — Wed, 31 May 2023 20:26:22 GMT

I am having the same issue. I have tried multiple ways to add data into a feature service that is associated with a Survey123 Form. I get the following error when I use append and copy/paste in ArcGIS Pro. See attached error message: General Function Failure Error code: 100 The INSERT statement conflicted with the FOREIGN KEY constraint.

Re: Append data Using ArcGIS Pro

JohannaKraus2 — Tue, 02 Jul 2024 15:42:12 GMT

i'm also running into this, did you find a work around?