Error: Cannot insert the value NULL into column ''TYPECODE'', table ''@SPLITTYPECODESFILTER''; column does not allow nulls. INSERT fails. Invalid column name ''REVENUESSPLITID''. The statement has been terminated.

After upgrading to version 2.9, user defined smart fields fail to process completely, giving Error:  Error:  Cannot insert the value NULL into column ''TYPECODE'', table ''@SPLITTYPECODESFILTER''; column does not allow nulls. INSERT fails.  Invalid column name ''REVENUESSPLITID''.  The statement has been terminated.

Article Number: 54217

Products:

  • Blackbaud_CRM
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. 

Environment

 2.9.1001, patch 3
 2.9.1001.12

Was this article helpful?

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!