Error : The INSERT statement conflicted with FOREIGN KEY constraint FK_ALTERNATELOOKUPID_ALTERNATELOOKUPIDTYPECODEID. The conflict occurred in database XXXXX, table dbo.ALTERNATELOOKUPIDTYPECODE, column ID.

Users may encounter the following error : The INSERT statement conflicted with FOREIGN KEY constraint "FK_ALTERNATELOOKUPID_ALTERNATELOOKUPIDTYPECODEID". The conflict occurred in database "XXXXX", table "dbo.ALTERNATELOOKUPIDTYPECODE", column 'ID' when running the Merge Two Constituents process.
This error is caused by the Constituent Merge Configuration not being completely setup.
1) Navigate to Constituents > Duplicates > Constituent Merge > Merge Configurations (tab)
2) Open the merge configuration that is generating the issue for editing.
3) Scroll down to Lookup ID in the Merge Tasks pane and click on it.
4) Verify that the Alternate Lookup ID Type field is filled out and save.
5) Run the Merge Two Constituents Process again and confirm if it completes properly.

Environment

 Blackbaud CRM
 4.0
 4.0.173.51
Warning
Maintenance in Progress: During this period, you can view your data, but you can’t add, edit, or delete data.

Was this article helpful?