Hi
We have started seeing this problem in TEST and the Load dwh job has failed for the last 5 days.
We have also seen this happen in Production, although the Load dwh job has completed successfully since.
In TEST (using SQL Server Mgt Studio) I can see the view but when I try to select from it I get the following error.
Msg 208, Level 16, State 1, Procedure DWH_X_INV_PER_FACTS_V, Line 123
Invalid object name 'dwh_x_inv_plan_per_facts_mv'.
Msg 4413, Level 16, State 1, Line 115
Could not use view or function 'ppm_test_dwh.ppm_dwh.DWH_X_INV_PER_FACTS_V' because of binding errors.
I still get this error even after running a Full load in TEST which completed successfully,
I do not see this error when trying to read the view in production
Sue Tearle