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.
| Bug ID Number | BUG-000181475 |
|---|---|
| Submitted | December 5, 2025 |
| Last Modified | December 9, 2025 |
| Applies to | ArcGIS Online |
| Version found | October 2025 |
| Operating System | Windows Server |
| Operating System Version | 2022 |
| Status | In 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
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App