Skip to main content
Best Answer

Issues with AGOL Writer Inserts/Updates/Deletes

  • November 24, 2021
  • 2 replies
  • 330 views

rtreecare
Contributor
Forum|alt.badge.img

I've created a workflow to update, delete, and insert new records to an hosted feature service.

The delete and update have been throwing log errors like:

ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in 'Job_Line'. The error code from the server was '1019' and the message was: 'The specified feature could not be updated or does not exist.'

 

In the reader, I'm making sure to include arcgisonline_globalid and arcgisonline_objectid in the format attributes window. These appear in the Joined output for the FeatureJoiner (for updates) and the the Deleted output of ChangeDetector (for deletes).

 

I'm really scratching my head as to how to the OBJECTID's can be incorrect in the writer when the reader is the same online source.

 

The parameters for the Writer have Use GlobalID = No and Preserve GlobalIDs=No.

For the layer, parameters are set to Writer Mode = Update (dont think this matters with fme_db_operations) and Truncate = No.

 

I've tried running without feature cache and get the same issue.

Maybe I could tell what the issue was if I could see the JSON that was constructed for the rest call, but i'm not sure how to do that.

Change Detector

Best answer by virtualcitymatt

Yeah, sounds pretty weird. For me i would isolate one feature to test with. Just before the writer you should inspect the data to make sure that the object id is as you expect it to be.

As for the logging you could try and turn on debug logging in FME, there might be some more information about the request, but just be sure to ignore all the BADNEWS comments these are normal and not errors!

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.

2 replies

virtualcitymatt
Celebrity
Forum|alt.badge.img+47
  • Celebrity
  • Best Answer
  • November 25, 2021

Yeah, sounds pretty weird. For me i would isolate one feature to test with. Just before the writer you should inspect the data to make sure that the object id is as you expect it to be.

As for the logging you could try and turn on debug logging in FME, there might be some more information about the request, but just be sure to ignore all the BADNEWS comments these are normal and not errors!


rtreecare
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • November 29, 2021

Yeah, sounds pretty weird. For me i would isolate one feature to test with. Just before the writer you should inspect the data to make sure that the object id is as you expect it to be.

As for the logging you could try and turn on debug logging in FME, there might be some more information about the request, but just be sure to ignore all the BADNEWS comments these are normal and not errors!

FeatureJoiner had carried an additional objectID from the local revised version.

Thanks.