Update and insert in Feature Layer is stuck in infinite loop

[StijnSchoutenTheGISLord]

Hello everyone,

After the recent ArcGIS Online update I'm experiencing some issues with the updating of data within a Hosted Feature Layer.

To break down my problem I've created two very simple GeoJson files. One (see below) containing a single feature in a feature collection as my initial upload. I can then create a Hosted Feature Layer successfully. 

Following that, I click the button <Update Data> 

I go through the options, selecting

<Add and Update Features>

Drop my file (second feature, see below)

<Map objectid to objectid>

<Map columns to columns>

And then I just wait. Before the update this didn't take very long. Mere seconds. Now it seems stuck. I've pasted the example below for you to try:

{
"type": "FeatureCollection",
"name": "sql_statement",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "objectid": 2, "bouwjaar": 1992 }, "geometry": { "type": "Polygon", "coordinates": [ [ [ 4.547408637, 51.930894791 ], [ 4.547427509, 51.930850522 ], [ 4.547582231, 51.930875438 ], [ 4.547575922, 51.930890143 ], [ 4.547554904, 51.930886667 ], [ 4.547549566, 51.930899213 ], [ 4.547542251, 51.93091641 ], [ 4.547408637, 51.930894791 ] ] ] } }
]
}

{
"type": "FeatureCollection",
"name": "sql_statement",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "objectid": 1, "bouwjaar": 1990 }, "geometry": { "type": "Polygon", "coordinates": [ [ [ 4.548324754, 51.928070624 ], [ 4.548352657, 51.928001161 ], [ 4.548432828, 51.928013599 ], [ 4.548398513, 51.928099375 ], [ 4.548346466, 51.928091363 ], [ 4.548353023, 51.928075051 ], [ 4.548324754, 51.928070624 ] ] ] } }
]
}

[bbollin]

@StijnSchoutenTheGISLordis it possible for you to include the two files you are testing with here?

[StijnSchoutenTheGISLord]

Hi @bbollin,

Thank you for replying! It seems that the upsert process has finished by now. I don't know if it have gotten slower after the update?
I've pasted the two geojsons in my post but you can also use these larger geojsons in the link here 
Note that the data is from Open Street Maps and can be used freely

The 'init.geojson' is the initial file to create the layer
The 'upsert.geojson' is the file i use to update my layer with

It took me around 40 mins this morning to perform this operation. Two weeks ago it was a couple of mins. It would be very helpful if you also take a look 😄 

[bbollin · Accepted solution]

@StijnSchoutenTheGISLord  I just tried and it worked almost instantly 🙂 perhaps it is your network connection. If this persists or others in your org encounter the same problem reach out to Esri Support and open a bug so we can look into it more

[StijnSchoutenTheGISLord · Accepted solution]

Hi @bbollin ,

It was indeed the network connection! I'm trying it out at home and its fast again 🙂
Thanks for your assistance!

Do you have some pointers/documentation I can forward to the network specialists to fix this issue with our company network?

[bbollin]

I do not, I think your IT department would need to evaluate what's happening there 🙂

[StijnSchoutenTheGISLord]

I've given it some second thought and the weird thing is that I also used the API to update the layer. It had the same issue with slowness but the part of actually uploading the geojson as item was very fast (3 secs). The slow part of upserting (used .append) was fully internal within ArcGIS (40mins +)

After testing it again just a few minutes ago the API and the company connection are just as fast as upserting via the UI. Maybe there was some downtime/disrupted service?