Error: Data could not be saved. Cannot insert the value NULL into column 'SOURCECONSTITUENTID', table 'SiteID_EC_30.dbo.REVENUERECOGNITIONDEFAULT'; column does not allow nulls. INSERT fails.

When attempting to edit a constituent relationship, a user may receive Error:  Data could not be saved.  
Cannot insert the value NULL into column 'SOURCECONSTITUENTID', table 'dbo.REVENUERECOGNITIONDEFAULT'; column does not allow nulls. INSERT fails.
This was a data/conversion issue as the relationship had the matching gift check box marked but no entry in the REVENUERECOGNITIONDEFAULT table.  The easiest fix would be to edit the relationship, uncheck the box 'The organization will match contributions for this relationship', save the relationship.  Edit the relationship and mark the box if necessary.

Environment

 Blackbaud CRM
 3.0
 516.60

Was this article helpful?