Error: An error occurred during the merge process. The merge could not be performed - when merging constituent records

You may receive the following error when trying to merge constituents from Admin - Merge Constituents function

An error occurred during the merge process. The merge could not be performed.
General ODBC Error [Microsoft][ODBC SQL Server Driver][SQL Server]Internal error: An expression services limit has been reached.
Please look for potentially complex expressions in your query, and try to simplify them.
Native error: 8632
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

1. Go to Admin - Merge Constituents - select any pairs below (there are more records that have the same issue, these are just examples).
2. Select all info to merge e.g. move everything from left to right and click on Merge. Delete source constituent is untick.
3. Also tried to merge only Biographical Information and same error.

The Merge From record could potentially be a solicitor, checked that this solicitor is not an assigned solicitor for any records. 
The solicitor could be on some gifts, have deleted the solicitor from gift records and try the merge again still can't merge with same error.

Environment

 Citrix
 Raiser's Edge
 7.94

Was this article helpful?