Why suddenly 'Incremental Load Data Warehouse Job' has started failing

Blog Post created by PEMARI-Gaurav.Gupta on Apr 6, 2017

We have seen that suddenly Incremental Load Data warehouse job has started failing for some of our clients which are running on CA PPM 14.3 and SQL Server.If you check the logs, it says 'DWH_X_INV_PLAN_PER_FACTS_MV' view doesn't exist.

We noticed that even if you do not change anything this view gets missing after few incremental run of Data Warehouse Job.

The recreation of the view on DWH database fixes the issue.


I have attached the script for the reference.