Append data Using ArcGIS Pro

Question

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

append.JPG

JohannaKraus2 · Answer

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

BethanyCrenshaw1 · Answer

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.

Cannot_Paste_into_a_Feature_Service_that_is_part_of_a_survey123_form.png

IanGallo · Answer

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