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
If you experience this issue, chat with support with the following information so support can work with our product engineers:   
  • The exact steps to duplicate the issue (click by click).

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?