nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Content Management

Data and services

Accepted answers

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

Support was able to resolve this issue. Somehow this feature layer still had some "ghost" views associated to it. I had deleted all of the views that were created from the feature layer yet when I viewed the REST Services Directory, layers details page>click view next to URL on bottom right. Here it was showing views associated to the feature layer. When clicking on the view, it could not be found.

ESRI had to remove the "View" on their end to fix the issue.

Not sure how this happened. The views were created from the details page of the feature layer, using the Create View Layer option. The views were also deleted within AGOL and permanently deleted from the recycle bin.

REST Services View Home.png

REST Services Views.png

All comments

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.

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

KGalluccio

ESRI had to remove the "View" on their end to fix the issue.

REST Services View Home.png

REST Services Views.png

AustinAverill

I figured this is what was happening when that previous script didn't work.

tikola

And my addon for this is that permanently remove View solved issue - not just moving the view in recycle bin. So no need for support to do this - just empy AGOL trash bin.

ToddJohnson

Did you check that the joined view was deleted from the newly added recycle bin? I found that when deleting a joined view to unlock the scheme or when attempting to delete an account with content/groups, I have to check that the recycle bin is empty as well.

tikola

And now I have edited domain lists without really breaking the joined view. There was actually add fields button available but I did not had a need for that button. These instructions did the trick:

https://support.esri.com/en-us/knowledge-base/problem-unable-to-edit-the-domain-values-of-a-hosted-fe-000030265

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.