FME Workbench ver. 2021.2.3, build 21812
FME Server ver. 2021.2.3, build 21812
Hi Everybody.
Sorry for my Canadian French, I try to be correct as much as possible in English, you may notice some errors on my part.
Yes, I know, we should migrate to FME Form/FME Flow. The steps have been initiated with our supplier but we must wait until the migration from ESRI ArcGIS Desktop 10.8.1 to the ESRI Enterprise 10.9.1 version is completed.
Premises:
- We maintain data that we share on a feature service hosted on ArcGIS Online with a subcontractor (different types, SQL Server, GDB and Shapefiles);
- The address of the feature service must remain constant for the processing of our subcontractor;
- The initial creation of the feature service goes correctly (an FME Workspace process launched manually for creation;
- We must replicate the update autonomously on our FME Server (same version as the FME Workbench, 2023.2.3, build 21812) so that the data is up to date over a 72-hour period.
The update workspace fails due to two errors:
- ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'gocite_BATIMENT'. The error code from the server was '1003' and the message was: 'Operation rolled back.'... Last line repeated 2 times …
- ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'gocite_BATIMENT'. The error code from the server was '1000' and the message was: 'Error converting data type nvarchar to real.'
Our gocite_Batiment data source does not contain a Real type field and the same goes for our feature service hosted on ArcGIS Online following the use of the Creation Workspace.
The structure of the FME Server part is already in place to accommodate the Workspace for the 72-hour update.
Ideas for possible solutions or places to validate that I am not familiar with would be greatly appreciated to adjust the update workspace.
If possible, I will try to respond quickly if you have any questions.
Jean-François.