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