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.
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.
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/
Job Failed
Posted - 11/19/2012 : 08:46:55
