Friends Asking Friends Fundraising Group Summary Business Process fails intermittently

Friends Asking Friends Fundraising Group Summary Business Process failed to complete with the following error:

Attempting to set a non-NULL-able column's value to NULL.
Warning: Null value is eliminated by an aggregate or other SET operation.
BBERR_ORIGINAL_ERROR:681
BBERR_ORIGINAL_PROCEDURE:USP_FAFGROUP_CALCULATE_GROUPSANDMEMBERS
BBERR_ORIGINAL_LINE_NUMBER:46

 
This issue is addressed by clearing the execution plan cache and forcing a recompile of the stored procedure.  Contact support to have this done.  

Environment

 Blackbaud Internet Solutions
 3.0
 3.0.516.64

Was this article helpful?