Error: Cannot insert the value NULL into column 'KEYNAME', table 'name'; column does not allow nulls. INSERT fails. - when validating a batch of imported revenue records.

Within CRM, it is possible to import revenue records into batches.  When validating some of these batches, a user may notice Error:  Cannot insert the value NULL into column 'KEYNAME', table 'name'; column does not allow nulls. INSERT fails.
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1.  Log-in to CRM.
2.  Go to Administration, Import, and run your import process to generate your batch of revenue records. 
3.  Validate your batch and receive Error:  Cannot insert the value NULL into column 'KEYNAME', table 'name'; column does not allow nulls. INSERT fails. 

Environment

 Blackbaud CRM
 3.0

Was this article helpful?