SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Job Failed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kallushashi
Starting Member

India
11 Posts

Posted - 11/19/2012 :  08:46:55  Show Profile  Reply with Quote
Hi
I am getting following error please help me regarding this any one please

Executed 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

United Kingdom
206 Posts

Posted - 11/19/2012 :  08:55:36  Show Profile  Reply with Quote
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.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1908 Posts

Posted - 11/19/2012 :  11:09:48  Show Profile  Visit jackv's Homepage  Reply with Quote
Either filter out the data with NULLs or change the value or change the column to allow NULLs

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 11/20/2012 :  03:05:20  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 11/20/2012 :  07:23:57  Show Profile  Reply with Quote
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
Go to Top of Page

kallushashi
Starting Member

India
11 Posts

Posted - 11/26/2012 :  05:56:05  Show Profile  Reply with Quote
Thanks every one for the reply i got the solution.

shashi
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000