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!
@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.
markatsafe wrote:
@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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.