Home » Database, SQL

SQL Error: Cannot insert the value NULL into column… column does not allow nulls. INSERT fails.

10 March 2009 Share/Bookmark

Error description:

Cannot insert the value NULL into column ‘SourceId’, table ‘Advisory.dbo.AdvDocSource’; column does not allow nulls. INSERT fails.
The statement has been terminated. The ‘CompanyAdd’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
——————————-

This error occurs because the ‘SourceId’ column in my table is primary key and it is set to not null. i.e. it doesn’t allow null entries. And I have not made it auto increment.

For making a table column auto increment:
- Go to server explorer.
- In Column Properties, go to Identity Specification.
- Go to (Is Identity) and make it ‘Yes’ from the selection list.

You are done. You also have the option for Identity Increment and Identity Seed.

The SQL Query is:
CREATE TABLE [yourTableName](SourceID int IDENTITY(1,1) NOT NULL, …

From Mukesh Chapagain's Blog, post SQL Error: Cannot insert the value NULL into column… column does not allow nulls. INSERT fails.

email

Related posts:

  1. Alter MySQL table to add & drop column & add Foreign Key
  2. Magento: How to select, insert, update, and delete data?
  3. MySQL Database: Foreign Key Understanding and Implementation
  4. 10 Very Useful SQL Queries with JOINS
  5. Displaying all products and new products listing in column/grid layout – Zen-cart
  6. Magento: Solution to “Error: 404 Not Found” in Admin Login Page
  7. ASP.NET Error: A potentially dangerous Request.Form value was detected from the client
  8. Magento: Recoverable Error: Argument 1 passed to Mage_Core_Model_Store :: setWebsite() must be an instance of Mage_Core_Model_Website
  9. ASP.NET Error : An HtmlSelect cannot have multiple items selected when Multiple is false.
  10. Magento: Helper Data not found error

php magento mukesh chapagain

Get New Post by Email
RSS Feed Subscribe RSS Feed
  • Congphuoc Phan

    This error is also happen when we use Import Tool, I have got the same one even when I check Identity in Data Table. Finally I found that, if we check the Identity in Data Table, than we don’t use the checkbox “Enable identity insert” in the Edit Mapping popup window