Error: Cannot insert the value NULL into column 'ID', table dbo.RELATIONSHIPCONFIGURATION; column does not allow nulls. INSERT fails – when importing into Enhanced Revenue Batch

An Import process and .csv file can be used to import constituent revenue into the database.  When importing revenue for a married constituent, and the relationship is deleted prior to committing the batch, the error results.
This error can occur if a spouse is brought into batch and that spouse is then removed (before the batch is committed).  As a workaround, the row will need to be deleted and re-entered on a new row.

Steps to Duplicate

  1. Go to Administration functional area
  2. Select Import
  3. Select Generate import header file and populate with Finder number, Date, Revenue type, Payment type, Application, Designation, New/edit constituent Last\org\group\household name, New/edit constituent First name, and save the file
  4. Go to Administration
  5. Select Import
  6. Add
  7. Select Revenue>Enhanced revenue batch
  8. Enter a Name
  9. Import the file from above
  10. Go to Map fields tab
  11. Select Auto-map
  12. On the "New/edit constituent" collection field select Map collection field
  13. Select Auto-map
  14. Start process (after import processes, do not commit batch yet)
  15. Go to the constituent record
  16. Select Remove spouse and enter whatever information
  17. Save
  18. Go back to the batch and attempt to commit it
  19. Observe error


 Blackbaud CRM

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.