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

Environment

 Blackbaud CRM
 4.0

Was this article helpful?