Error: Data could not be saved. Cannot insert duplicate key row in object 'dbo.PHONE' with unique index 'UIX_PHONE_CONSTITUENTID_PHONETYPECODEID_NUMBER'. The duplicate key value is (a783f9d9-5304-4346-933a-cb9d11a84a5d, 54b60747-941a-4b12-bc1c-6ae85a8

When merging two constituents the user gets the following error:  Data could not be saved.   Cannot insert duplicate key row in object 'dbo.PHONE' with unique index 'UIX_PHONE_CONSTITUENTID_PHONETYPECODEID_NUMBER'. The duplicate key value is (a783f9d9-5304-4346-933a-cb9d11a84a5d, 54b60747-941a-4b12-bc1c-6ae85a85f046, (510) 475-6040).

This was caused by converted data - specifically a duplicate phone number on the source constituent record.  Removing the duplicate number allows the merge to process without error.

Environment

 2.9.1001, patch 78

Was this article helpful?