April 16, 2009 at 12:36 pm
I am getting following error while inserting in to partition view. I already gave the more range to the partion function but still getting an error.
Msg 4457, Level 16, State 1, Line 1
The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions.
The statement has been terminated.
April 16, 2009 at 2:18 pm
I just found that there is a null value in the partion filed which is giving a problem. I already have default constraint on the parttioned field that if it is null then store default value.
When I try to insert directly into the table it is working fine but when I try to insert into view then it is givving me the error.
April 16, 2009 at 2:38 pm
Looks like it is a default constraint issue. There is a default constraint in the table and when it's try to insert null values it throw following error. There is a
I don't know why I am getting an error if there is a default constraint on POST_PD field.
Cannot insert the value NULL into column 'POST_PD', table 'IDX.dbo.TRANSAC_LIVE'; column does not allow nulls. INSERT fails.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply