Merged Constituent have Relationships that cannot be deleted

Has anyone else encountered an issue with deletion Relationships, after Constituents have been merged ?

We have an instance where a Spouse (wife) and Daughter records were merged, so on the Husband's record there is now an Daughter and Spouse Relationship.

Neither one can be deleted. Attempting to delete throws the following error:

Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint "FK_RELATIONSHIP_RELATIONSHIPSETID". The conflict occurred in database "36917p", table "dbo.RELATIONSHIP", column 'RELATIONSHIPSETID'. The statement has been terminated.

Categories