Error: Data could not be saved. Cannot insert the value NULL into column 'SOURCECONSTITUENTID', table '326_d75c5f0c-9c2e-4d11-a77d-ea9d013c0d39.dbo.REVENUERECOGNITIONDEFAULT'; column does not allow nulls. INSERT fails - when editing a relationship

You may receive the following error when trying to edit an existing relationship on a constituent's record: 

Data could not be saved.  Cannot insert the value NULL into column 'SOURCECONSTITUENTID', table 'XXXX.dbo.REVENUERECOGNITIONDEFAULT'; column does not allow nulls. INSERT fails.
If this does not resolve the issue, chat with support with the following information:   
  • The exact steps to duplicate the issue (click by click).

Steps to Duplicate

Steps to duplicate:
  1. Click constituents > Constituent search
  2. Type in the affected record and click search
  3. Select the constituent
  4. Click on the relationships tab
  5. Click the drop down arrow next to the affected relationship and click edit
  6. Change the relationship drop down to former employee and click save

Environment

 Altru Arts & Cultural

Was this article helpful?