my question/post related to https://community.esri.com/t5/arcgis-survey123-questions/quot-the-insert-statement-conflicted-with-t... and https://community.esri.com/t5/arcgis-survey123-blog/st-kilda-penguin-release-3-1/bc-p/1051542
My apology for essentially triple posting - I just would really appreciate some help/advice/suggestions.
Here my problem again:
I still struggle with BUG-000117394 "The INSERT statement has conflicted with the FOREIGN KEY constraint" error (see attached screenshot).
I followed the following work flow:
I initially created the survey using Survey123 3.9, but I re-published using the latest version. Any ideas what I am doing wrong? One thing I am not entirely sure about is: I might have added the attribute index to the GlobalDs AFTER creating the relationship classes. would that matter at all?
Thanks a lot for the help.
My advice would be to not use GlobalIds. I use my own keys and it all works perfect.
See all of my reasons in this post. https://community.esri.com/t5/arcgis-collector-questions/related-tables-for-offline-data-collection/...
Yes Esri says to use them, but in the real world there are lots of ways it fails. Esp when moving data around. Hope that helps.
Thanks a lot for that info - that's certainly good to know and keep in mind. I actually ended up just creating a GUID field in the survey for each point, line, and polygon layers, so that the relationship class could be set up on three fields instead of just one.