laptop and a wrench

Bug

Truncating a feature layer with a relationship fails with the error: "There are no primary or candidate keys in the referenced table 'NAME' that match the referencing column list in the foreign key 'NAME'. Could not create constraint or index. See previous errors." if the relationship field are missing a unique index.

ArcGIS Online
Bug ID Number BUG-000181475
SubmittedDecember 5, 2025
Last ModifiedDecember 9, 2025
Applies toArcGIS Online
Version foundOctober 2025
Operating SystemWindows Server
Operating System Version2022
StatusIn Product Plan

Workaround

Create a unique index for the primary key field in the layer settings in ArcGIS Online.

Steps to Reproduce

Bug ID: BUG-000181475

Software:

  • ArcGIS Online

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options