topic Re: Update and insert in Feature Layer is stuck in infinite loop in ArcGIS Online Questions

Update and insert in Feature Layer is stuck in infinite loop

StijnSchoutenTheGISLord — Wed, 01 Nov 2023 09:07:44 GMT

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

Drop my file (second feature, see below)

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 ] ] ] } } ] }

Re: Update and insert in Feature Layer is stuck in infinite loop

bbollin — Wed, 01 Nov 2023 14:16:45 GMT

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

Re: Update and insert in Feature Layer is stuck in infinite loop

StijnSchoutenTheGISLord — Wed, 01 Nov 2023 14:30:16 GMT

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 😄

Re: Update and insert in Feature Layer is stuck in infinite loop

bbollin — Wed, 01 Nov 2023 14:45:56 GMT

@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

Re: Update and insert in Feature Layer is stuck in infinite loop

StijnSchoutenTheGISLord — Wed, 01 Nov 2023 15:12:54 GMT

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?

Re: Update and insert in Feature Layer is stuck in infinite loop

bbollin — Wed, 01 Nov 2023 16:01:59 GMT

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

Re: Update and insert in Feature Layer is stuck in infinite loop

StijnSchoutenTheGISLord — Wed, 01 Nov 2023 16:30:35 GMT

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?