Error: Data could not be saved. Cannot insert duplicate key row in object 'dbo.RELATIONSHIP' with unique index 'UIX_RELATIONSHIP_RELATIONSHIPCONSTITUENTID_RECIPROCALCONSTITUENTID_RELATIONSHIPTYPECODEID_RECIPROCALTYPECODEID'.

When attempting to merge two constituents, a user may receive Error:  Data could not be saved.  Cannot insert duplicate key row in object 'dbo.RELATIONSHIP' with unique index 'UIX_RELATIONSHIP_RELATIONSHIPCONSTITUENTID_RECIPROCALCONSTITUENTID_RELATIONSHIPTYPECODEID_RECIPROCALTYPECODEID'. The duplicate key value is (GUID, GUID, GUID).  Uncommittable transaction is detected at the end of the batch. The transaction is rolled back
This issue was caused by a data conversion problem.  If you are experiencing a similar issue, review  How to identify data conversion issues in Blackbaud CRM for more information. 

Environment

 3.0.516, patch 37

Was this article helpful?