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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.