Hello, I'm attempting to write records from a file geodatabase to a hosted feature service on ArcGIS Online. The feature service already exists and is populated with records, the writer is set to update. When running the translation I get the error message (the object names have been removed): ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in '---'. The error code from the server was '1000' and the message was: 'The UPDATE statement conflicted with the FOREIGN KEY constraint "---". The conflict occurred in database "---", table "---", column 'GlobalID'. Any idea what is causing this error? Thanks!
Question
File Geodatabase to AGOL Foreign Key Constraint
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
@firegis On the surface it would look like your AGOL feature class is participating in a relationship and the related table is not getting updated correctly or you foreign key has the wrong value.
@firegis On the surface it would look like your AGOL feature class is participating in a relationship and the related table is not getting updated correctly or you foreign key has the wrong value.
Thanks for the reply! That's correct, the feature classes have an established relationship (one to many) based on the GlobalID. Nothing in the translation is specifically altering either the primary key or foreign key, and both should be updating. I have not been able to find any documentation regarding writing records with relationships to AGOL, or anyone else that has encountered this issue. Any other ideas? Thanks.