We recently replaced a survey based on a hosted feature service with a new survey (also hosted on AGOL), and we want to merge the old data into the new feature layer and associated tables. The surveys and associated data are virtually identical, consisting of one feature layer and four tables. Using the append tool, I was able to append all records from the old feature layer to the new one without an issue, but when I try to append any of the tables to their respective new version , I get the following error:
ERROR 999999: Error executing function.
General function failure [The INSERT statement conflicted with the FOREIGN KEY constraint "REL_FK_service_49777005691e49229df0a83fcb5485e8_PARTIES_INVOLVED_0". The conflict occurred in database "db_2177", table "user_2177.service_49777005691e49229df0a83fcb5485e8_WHITECARD_17_18", column 'globalid'.
The statement has been terminated.]
Failed to execute (Append).
To troubleshoot, I tried the same append multiple times, with the "Preserve Global IDs" option turned off and on; and removing the globalid field from the field map. No dice.
How can I get these old records into the new tables?
I can do this in an enterprise geodatabase without issue, but not with this hosted survey.