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.

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?