Error: The process completed successfully, but an exception occurred while updating the search constituent table - when merging constituents in Altru

When attempting to run the constituent merge process in Altru you may encounter this error message: The process completed successfully, but an exception occurred while updating the search constituent table.  Run the Refresh search constituent global change to bring the table back up to date.  Please report this error to Blackbaud support:  The EXECUTE permission was denied on the object 'UFN_REGULAREXPRESSIONMATCH', database 'database string', schema 'dbo'.
BBERR_ORIGINAL_ERROR:229
BBERR_ORIGINAL_PROCEDURE:
BBERR_ORIGINAL_LINE_NUMBER:1
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. Click Constituents > Duplicates > Constituent Merge
  2. Click on the Merge process
  3. Click start process

Environment

 Altru Arts & Cultural

Was this article helpful?