Skip to main content
Planview Customer Success Center

Primary key error in ResourceFeature table when editing resources

SYMPTOM

When doing user administration, e.g. assigning a user to a workgroup, a database error occurs.

ERROR
Violation of PRIMARY KEY constraint 'PK' ResourceFeature'. Cannot insert duplicate key in object 'dbo.ResourceFeature'.


RESOLUTION

This can be an indication that a previous operation didn't terminate correctly. To fix this, toggle the user license type between Changepoint User (=Enterprise user before V2014) and undefined user. In between, save the resource after each step.

If this doesn't help or is not possible, unassign/terminate the resource from its workgroup and then reassign it back.