Error 515

Severity Level 16

Message Text

Attempt to insert the value NULL into column '%.*s', table'%.*s'; column does not allow nulls. %s fails.

Explanation

This error occurs at run time when an attempt is made to use a null value when inserting or updating a column that does not allow null values.

Note This message differs from the following message, which indicates that the attempt has been detected at compile time.

error 232 : "The column "%*s in table %.*s may not be NULL."

This error can also occur if the table that is the target of an INSERT or UPDATE in a stored procedure or trigger is being dropped and re-created, and one or more of the table column definition(s) have changed from NULL to NOT NULL.

Action

If this error occurs when you are running an UPDATE or INSERT statement, verify that the data inserted or updated matches the column definition for the affected table.

Inserting or updating a column does not allow null values.

Note In a direct UPDATE or INSERT by value, you will get compile error 233 instead of error 515. Usually 515 errors occur in an insert/select or an update statement that uses data in another table.

If this error occurs when a stored procedure or trigger references a table that has been dropped and re-created with different nullability, drop and re-create the affected stored procedure or trigger.

If you are unable to resolve the problem, contact your primary support provider for assistance.