Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kallushashi
Starting Member
11 Posts |
 Posted - 2012-11-19 : 08:46:55
|
| Hi I am getting following error please help me regarding this any one pleaseExecuted as user: dbo. Cannot insert the value NULL into column 'category_cat_id', table 'Fine_new.dbo.product_subcategory_index'; column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.shashi |
|
|
Abu-Dina
Posting Yak Master
206 Posts |
Posted - 2012-11-19 : 08:55:36
|
| Not sure what help we can provide? Your table has a column that doesn't allow NULLs and code your SQL Job is running is trying to insert a NULL. You need to provide more information or run the code in SSMS to try and work out which part is causing the problem. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-11-19 : 11:09:48
|
| Either filter out the data with NULLs or change the value or change the column to allow NULLsJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-20 : 03:05:20
|
| this is nothing but a logic issue which only people having clear idea on your environment and code can fix. You could go by guidelines others provided and track down code causing error and see why values are coming as NULLs. Otherwise post some sample data from tables and explain us what you're looking at as output------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-20 : 07:23:57
|
| Either change the def of column to NULL (original def should have been NOT NULL) or insert values instead of NULL to the rows that are NULL |
|
|
|
kallushashi
Starting Member
11 Posts |
Posted - 2012-11-26 : 05:56:05
|
| Thanks every one for the reply i got the solution.shashi |
|
|
|
|
|
|
Job Failed