Update data to a writer

To export the data I use a writer ARCGISFEATURESERVICE.

Should I use instead the AGOL.ARCGISFEATURESERVICE or there no difference between them ?

I create a writer with a SHP format and the data are correct so I don’t understand why it’s not the same in my ARCGISFEATURESERVICE !

Thanks a lot !

Hi ​@guimor33 

If I understand correctly, you are looking to update the data in your feature service. Try Insert and then “Truncate Existing” in the table handling/feature handling. This will clear the table of records and write the new records. If you wish to keep and update existing then we have to handle in a different way.

Let us know if this works! Good luck and hope that helps!

Hello !

I work on different point which represent different electrical substation. My “script” show the constraint within a 10km radius around the point. And at the same time my “script” show some agricultural field which are based on some type of culture. Sometimes I ask the “script” to indicate me the type of field like the category 18/19/16/25 and somethimes I juste want the category 18.

I use a WHERE CLAUSE in the “script”  where I noted the name of the electrical substation I want to work on. So when I want to use the “UPDATE”, it’s only on this area auround the elecctrical substation I noted.

So everytime I don’t want all my data to be updated but just the electrical substation I ask the script to run on.

When I UPDATE I got this error actually : 

ArcGIS Feature Service Writer: Feature Service 'https://gis.qenergy.eu/arcgis/rest/services/FR_Prospection/Prospection_solaire_nationale_FME_poste_…' does not support writer mode 'UPSERT'. Its owner may have disabled inserting or editing features. Writes may fail if the current user is not the owner or administrator

Python Exception <WriterModeNotSupported>: FMEException: 928232: ArcGIS Feature Service Writer: Feature Service 'https://gis.qenergy.eu/arcgis/rest/servvices/FR_Prospection/Prospection_solaire_nationale_FME_poste_source/FeatureServer' does not support writer mode 'UPSERT'. Its owner may have disabled inserting or editing features. Writes may fail if the current user is not the owner or administrator

Is it a error that mean I got a problem with the parameter in ArcGIS feature service ? My administrator must change something to allow me to UPDATE ?. Or it’s a parameter in FME to change ?

I hope my explanation are clear (I’m not sure). But I can give you more details if needed !

Thanks a lot and have a goord day !

The error message mentions that the Feature Service  does not support writer mode 'UPSERT'. So that is probably what goes wrong.

Aside from that, UPSERT will not delete existing records. UPSERT will only determine whether to UPDATE existing records, or INSERT new records.

So if the "18/19/11" data is already there, it will remain there. UPSERTing with "11” will only update or insert "11” records, it will not remove "18” and "19" records.

As ​@crutledge suggests above,

Try Insert and then “Truncate Existing” in the table handling/feature handling. This will clear the table of records and write the new records.

​@guimor33 ArcGIS Server logs generated while the workspace runs might provide a clearer indication than the FME-side message on its own. You will likely need someone with ArcGIS Server credentials to reach them at https://<your-server-domain>/server/manager/log.html. On the Server Manager log page, set the Log Filter from Warning to Verbose, then press the Query button (visual example). Re-run the workspace and read the verbose entries for that run; the logs will tell you whether the service rejected the request on capability, permissions, or data issue.

If the ArcGIS Server message is also too ambiguous to troubleshoot, then I think submitting a support ticket to investigate further might be warranted. 

Hope this help!