Error: "Cannot insert the value NULL into column 'CONSENTPREFERENCECODE', table [Database] dbo.BATCHCONSTITUENTSOLICITCODE'; column does not allow nulls. INSERT fails"

When importing solicit codes into a constituent update batch in an environment on Service Pack 14 or later, you might encounter the error, "Cannot insert the value NULL into column 'CONSENTPREFERENCECODE', table [Database] dbo.BATCHCONSTITUENTSOLICITCODE'; column does not allow nulls. INSERT fails". This error is thrown regardless of whether the solicit code has the consent type "EU Consent".
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Steps to Duplicate

1) Using a constituent update batch, import solicit codes mapped to the Solicit codes collection field.
2) Do not map the Preference field in the collection field.
3) Notice that records are rejected with the error, "Cannot insert the value NULL into column 'CONSENTPREFERENCECODE', table '[Database]dbo.BATCHCONSTITUENTSOLICITCODE'; column does not allow nulls. INSERT fails".

Environment

 Blackbaud CRM
 4.0
 4.0
 4.0.180.1600
 4.0.178.0

Was this article helpful?