Pages

Apr 2, 2018

Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621).


Cannot insert the value NULL into column '',
  table '';
   column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515)  The statement has been terminated. [SQLSTATE 01000] (Error 3621).


Cause: This error occurs when you try to insert null values in not null and primary key columns. Please check the data which is trying to insert into SQL table.

Fix: fix the source data.