I have a partitioned view that is schemabound to the underlying tables. There is a job that runs every minute that has a step which is supposed to update the view. When the job runs, that step fails with the following error message:
UNION ALL view 'sl' is not updatable because a partitioning column was not found. [SQLSTATE 42000].[Error 4436]. The step failed.
This is the code for the view:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE view [dbo].[sl]
with schemabinding
as
select proj_num, barcode, sale_status, previous_call_time, area_code,
zip, fico, tape_num, call_cnt, phone, the_data, blocked, first_call, first_color,
sched_date, spoke_to, sched_name, sched_note, sched_type
from dbo.screen_list_6654 (nolock)
union all
select proj_num, barcode, sale_status, previous_call_time, area_code,
zip, fico, tape_num, call_cnt, phone, the_data, blocked, first_call, first_color,
sched_date, spoke_to, sched_name, sched_note, sched_type
from dbo.screen_list_6656 (nolock)
Any thoughts on what could be causing the problem?
UNION ALL view 'sl' is not updatable because a partitioning column was not found. [SQLSTATE 42000].[Error 4436]. The step failed.
This is the code for the view:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE view [dbo].[sl]
with schemabinding
as
select proj_num, barcode, sale_status, previous_call_time, area_code,
zip, fico, tape_num, call_cnt, phone, the_data, blocked, first_call, first_color,
sched_date, spoke_to, sched_name, sched_note, sched_type
from dbo.screen_list_6654 (nolock)
union all
select proj_num, barcode, sale_status, previous_call_time, area_code,
zip, fico, tape_num, call_cnt, phone, the_data, blocked, first_call, first_color,
sched_date, spoke_to, sched_name, sched_note, sched_type
from dbo.screen_list_6656 (nolock)
Any thoughts on what could be causing the problem?