Unable to add field to hosted feature layer, possible causes?

[KGalluccio]

I have a hosted feature layer which I am unable to add a field.  In AGOL>Data>Fields, the add field button is not available.  If I open the feature layer in Pro, add the field and try to save, I get an error "Unresolved errors found in *Fields: <feature layer name>.

I know that if the hosted feature layer has a joined view you cannot add additional fields.
I have deleted all of the joins, (total of 2), and permanently deleted them from the recycle bin, yet the Add Fields button is still not available.

What other reasons would cause the Add Field button in a hosted feature service to be available?

Link to hosted layer:

Albany County Tax Parcels 2024 - Overview

[AustinAverill]

The schema is locked because of the AC_Tax_Parcels_In_Buffer_Join_2024 joined view.

I've built these couple functions to help address the need to edit the schema of layers with a joined view. 

You can unlock the schema of the layer using the api and make your edits and then re-lock it.

[AustinAverill]

The code to unlock would look something like this.

from arcgis.gis import GIS
from arcgis.features import FeatureLayerCollection

joined_view_id = #put layer id for the joined view

joined_view = gis.content.get(joined_view_id
flc = FeatureLayerCollection.fromitem(joined_view)

unlock_update = {
    'sourceSchemaChangesAllowed' : True,
    'hasStaticData' : False,
    'lastEditDate' : ''
}

status = flc.manager.update_definition(unlock_update)

Then once you have made any needed changes, you can relock the source schema by running the script with the bool values flipped in the dictionary.

Similarly, you may need update the definition of your joined view following this if you want the joined view to appear with the new field you are adding.

[KGalluccio]

I am using ArcGIS Online, how would i run this code?

Also, I deleted the Joined view, so it not longer has an ID, it no longer exists.

[AustinAverill]

So you've deleted that joined view, but you still are not able to access the functions to add fields in AGOL?

[KGalluccio]

Correct.

[AustinAverill]

That's odd. The service is still showing that is has that view, even though the referenced view doesn't exist. You might need to try updating the definition to reflect that it no longer has a view. The definition should have updated on its own when you deleted the view, but clearly not this time.

from arcgis.gis import GIS
from arcgis.features import FeatureLayerCollection

url = "Your agol org url"
un = "your agol username"
pw = "your agol password"

gis = GIS(url, un, pw)

fs_id = "42aea2183c5544bfb4deca8b0d01d0c8"
item = gis.content.get(fs_id)
flc = FeatureLayerCollection.fromitem(item)

update_dict = {
    'hasViews' : False,
    'lastEditDate' : ''
}

status = flc.manager.update_definition(update_dict)
print(status)

 You should be able to type your info into the quotes for url, un, pw and run this in an AGOL NoteBook.

[KGalluccio]

Thanks for the help.

Where in AGOL do you see that the service is still showing that it has a view?

I ran the above code in a AGOL NoteBook and it showed success but I still do not have the option to add any fields.  See screen shots attached.  Removed UN and PW for obvious reasons.

[AustinAverill]

Attached is the rest service page, which can be accessed from the link at the bottom right of the item details page. You can see it still is showing that it has views for some reason. That was the only trick in my bag. Might need to reach out to support. 

[KGalluccio]

Thanks for all your help.  I will reach out to support.