In ArcGIS Pro, I have a published a map service as a feature layer service to our ArcGIS Portal. I have published it as the owner and Admin with enable editing permissions etc. The layer source comes from an SDE with SELECT, INSERT, UPDATE, DELETE privileges.
In FME Desktop 2025.1, I have a FeatureWriter using the new Esri ArcGIS Feature Service format. I have it successfully connected to our Portal via OAuth (safe.esri-agol) and with the the writer settings for Feature Operation set to Insert and feature type handling set to Truncate Existing. See image below.
When I run the workbench, after a period of time, it outputs back an error:
ArcGISFeatureServiceWriter: Feature Service 'Sample Layer(7ea7230cca1f4aeb9316ed1735cca5c2)' does not support feature operation 'INSERT'. Its owner may have disabled inserting or editing features. Writes may fail if the current user is not the owner or administrator.
This process used to work at some point when it was using the old format Esri ArcGIS Portal Feature Service (ARCGISFEATURESERVICE). But even that stopped working afterwards. So I’ve switched to the new format as mentioned above.
Any insight would be greatly appreciated.
Thank you.
UPDATE
Resolved:
It was a permissions on the back-end DB. The user that was connecting to the table in the SDE through ArcGIS Pro did not have all the privileges assigned. When it was publishing to the Portal, it was publishing with the SELECT only permissions. Thus, FME writer wasn’t able to fulfill the truncate existing operation when re-inserting back the records to the feature service layer.