Esri feature service writer: every integer is written as 1 when inserting into an existing AGOL layer

Hi ​@bekir,

Please check the existing feature layer to see if there are any data ranges set on the integer attributes: https://doc.arcgis.com/en/arcgis-online/manage-data/define-attribute-lists-and-ranges.htm

Hi,

We experience the same issue here:

• Problem seems to occur since v3.25.1
• There are no data ranges set on the integer attributes

This is a very serious problem. Especially if you read data from a feature layer and write the data back to the same feature layer, you loose some of you own data.

thanks ​@daveatsafe didn't look at that one, but it's also empty.

the definition is:

    {
      "name" : "equipmentNr", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "EquipmentNr", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 

Hi ​@bekir,

I have tried to reproduce the problem with my own layers, but with no success. Are you able to create a shareable layer that I can write to, or a detailed explanation on how to create a layer that will reproduce the problem?

Hi ​@daveatsafe,

I am creating an debug environment. Do you have an ArcGIS Online user I can share the feature layer with you. 

I will add an ffs and an fmw to here, after I’m done.

Here’s the ffs and fmw.

Hi ​@bekir ,

Thank you for that info! 

I was able to reproduce the problem by forcing the values to strings, and will create a problem report for our development team.

Thanks ​@daveatsafe - will start implementing this workaround to production now :)

The workaround is nice if you only have a few workbenches to change. But we have a lot of workbenches with this problem, so I want to try to revert to an older version of the package on FME Flow.

I followed the manual for removing the 3.25.1 package by manually removing the package from the Engine resource and sub resources as described in https://support.safe.com/hc/en-us/articles/25407389067021-FME-Flow-Troubleshooting-Packages

But when I try to upload a 3.22 version from FME Form to FME Flow I get the following error:
Upload 'safe.esri-agol-3.22.0.fpkg'...
Package access failed - FME Flow encountered an error and reported the following message.
Package safe.esri-agol may not be downgraded from 3.25.1 to 3.22.0.
Request to https://<our_server_url>/fmeapiv4/packages returned status code 422.
 

Also a restart of all the FME Flow services on the server does not help.

The manual upload of packages is not supported in FME Flow 2023.0 and above (that is why I did that via FME Form). But it seems that removing a package manually is also not supported anymore (or at least for this esri-agol package).

Does anybody know how to solve this issue?
How can I revert to an older version of the package on FME Flow?