We have two versions (Production & Development) of the same process, with their own independent resources, that are not working. Each is a hosted feature layer that was created by and is backed by an sd file. The sd file was created through ArcPro and was initially uploaded to create the hosted services. Then we have a python process that updates the sd files weekly. In short we join non-spatial attributes with a spatial (polygon) layer and that joined result gets pushed to AGOL. We thought it was working, because all indications from the process is that it is working without exceptions/fails etc.
I was given an updated polygon layer. The feature count has decreased and new features have also been incorporated. When I updated the feature class used in Pro, and ran the update process to affect AGOL the process worked without issue. But, when I went to AGOL to check the resulting data I see it has not updated. The update date on the sd file and hosted layer indicate they were updated but the data itself sits at the old feature count and the new polygons are not to be found. So, the data does not change but all indications locally and in AGOL are that things have updated. I have run both the Production and Development processes and each python process succeeds and each set of assets in AGOL show they have been "updated". Except that the data doesn't actually change.
I tried the manual "update" button in AGOL for the sd item and fed it the sd file manually. It acts as though it has succeeded but when I check the hosted feature layer the data has not changed.
I have gone into both Pro projects (prod and dev) and check the feature class in the gdb and also in the only Map in the project. They are once and the same but I didn't want to make an assumption and so I checked "both". The feature class/layer contain the most recent data. So Pro has the correct setup and layer for publishing.
I then altered the python process to output a newly named sd file so that I could create a new item in AGOL as an sd file backing a feature layer. When I check the data in that new item it shows the correct (meaning newest and desired) dataset, which I want and see correctly loaded in Pro as a layer (and backed by the feature class in the project gdb).
The python process indicates it works, the AGOL items themselves show an updated date, the manual "Update" button in AGOL for the sd items appears to "work", but the data in the hosted layers does not change. This is true for both parallel sets of resources (production and dev).
Anyone else encountered this and have tips/ideas?
