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

Removing unique constraint in ArcGIS Online.

BrookeNix1

I'm trying to remove the unique constraint from a field in ArcGIS Online. I unchecked the box to remove the unique constraint, AGOL says is is deleting the index. It never deletes. How do I make this setting stick?

After waiting awhile I receive this error.

Validation failed: Field does not contain unique values. Remove duplicates and try again

Find more posts tagged with

Accepted answers

All comments

KellyGerrow

Hi Brooke,

There was an issue that has been resolved with the call that was being made to update the service definition. This has been fixed. Can you try again and verify if you get a speedier response?

If there are duplicate values in the field, you will need to remove the duplicate values if you want to assign the unique constraint.

Thanks,

Kelly

BrookeNix1

Thank you Kelly, I was able to eventually get it updated.

NathanKoski

Hi Kelly,

I have been getting this similar error only when trying to add a unique index in the field's settings. I have verified that there are no duplicates, but it still claims there are. Is this the same issue that you are referencing?

Thanks,

Nate

KellyGerrow

Can you share the layer? Are there perhaps 2 null or blank fields?

RichardSiller

Hi Kelly,

I'm having the same issue - the layer can be found here: https://swt.maps.arcgis.com/home/item.html?id=4d94870d0f184cb7809eb9be51edc024 and the field is SWT_Code.

All the values are unique and there are no blanks. When trying to mark the field as unique, I get the following error:

"Validation failed: Field does not contain unique values. Remove duplicates and try again"

Thanks,

Richard

KhaledHassen

Hi Richard,

You will need to turn on schema changes on the view you have.

https://services1.arcgis.com/byI4kn9uGfeTFbS1/ArcGIS/rest/services/Scottish_Wildlife_Trust_reserve_boundaries___with_web…

To do this, you will need to go the admin API of the view:

https://services1.arcgis.com/byI4kn9uGfeTFbS1/ArcGIS/admin/rest/services/Scottish_Wildlife_Trust_reserve_boundaries___with_website_text/FeatureServer/updateDefinition

Then use the following json:

{

"sourceSchemaChangesAllowed" : true

}

Then add the index you need. I think this should resolve your issue. If not pl. let me know.

Khaled Hassen

Online Feature Service Dev Lead.

Mike Minami

Richard,

The question for me is why does this layer have SourceSchemaChangesAllowed set to false? Can you tell us more about your layer? How did you publish it? Is it editable? If so, what are the edit settings? I see that there is one view layer, how have you configured that layer?

The few layers of mine I looked at don't have that property set to false, so I'm wondering if some layer configuration set it that way.

thanks,

Mike

RichardSiller

Hi Both,

Thanks very much for your help. I tried to set SourceSchemaChangesAllowed to true for both the source feature service and the view layer but whilst the updating process appeared to work, the change didn't seem to apply.

Given the problem was the view layer, I ended up just deleting it, setting the unique property and then recreating the view.

I really should have thought that the view was getting in the way - it's not the first time it's caused me problems and is in fact the very reason I wanted to set the unique property in the first place. The source layer gets updated regularly and I used to just do a full update. The view layer now prevents this but I was advised that appending with a unique identifier should work instead.

I originally published via zipped shapefile and the view is the output of a join. I wanted to display some descriptive popup text for each feature but the maximum string length of a shapefile was a constraint. I ended up just joining the polygons to a CSV file containing the text.

Thanks again,

Richard

JenAmes

I'm having this issue as well, that I'm trying to make a field unique, but receiving the error that there are duplicates. There are not duplicates, and I've gone through and checked for any null/empty/blank options in the list and there are not. I have not entered any data yet, as it has yet to be collected, is this possibly why?

The data is meant to be used in a publicly viewable app for residents to find where the banner of their military veteran family member has been hung in town. The banners have not been hung yet, but I'm setting up the data for our public works crew to select names rather than manually typing them in, leading to a lot of potential spelling mistakes. I need to be able to enable search on the name field for the map/application so residents can easily find their banner, but I can't seem to do this and thought making the Name field unique would fix this, but I can't make it unique. I saw a solution later in this thread of adding code to the JSON, but either I don't know where the right place is to enter it in the JSON or I did it wrong, because the addition was rejected.

Jens_Dalsgaard_3-1754894145451.png

Cesar_Aguilera

hello i'm having a similar issues but the problem is that i can't enable the option for unique values, show an error that said that i have duplicate value, i take a screenshot for the console in chrome, i saw in the conversation some ask for that.

arcgis online error.png

dclone

@MikeMinami I'm currently still having issues assigning unique fields on a feature service I have tried the walkaround but still not working. You help is needed.Thanks

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.