I am having issues with the ArcGIS Online Feature Writer.
The error I am getting is ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'Feature Service Name (replaced for this message)'. The error code from the server was '1000' and the message was: 'Cannot insert duplicate key row in object 'user_****.service_id_Feature Service Name (replaced for this message)' with unique index 'rowidIndex'. The duplicate key value is (<NULL>). The statement has been terminated.'
I am comparing two feature services with the same schema, writing the new records to the second. I want to have a feature service as raw data (coming in from Survey123 for ArcGIS) and allow users to QA in the second feature service and make any edits.
It's a pretty simple workbench but for some reason the rowid isn't being passed to the editable feature service.
I have a feeling that because AGOL creates this for you that the rowid is global and so the first feature is successfully added with a rowid of NULL but the second feature is not allowed because it is also NULL.
Any ideas for this. @LauraAtSafe I've seen you've had some good answers for AGOL questions here before. Added a screenshot of the workbench.
Cheers,
Andrew