Data Warehouse Job Fails with Invalid Object Name 'dwh_inv_status_report_ln'

Document ID : KB000124499
Last Modified Date : 14/01/2019
Show Technical Document Details
Issue:
The DWH_INV_STATUS_REPORT table in the Data Warehouse schema is missing most of the Status Report attributes and the Load Data Warehouse (Full Load) job fails with the following error: 

Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'dwh_inv_status_report_ln'. 
Resolution:
The DWH_META_COLUMNS and DWH_META_TABLES tables in the PPM schema may need to be updated if the IS_DELETED column is currently set to 1.  

Use the following two queries: 
  1. update DWH_META_Columns set is_deleted =0 where src_table_name = 'dwh_cop_prj_statusrpt_v ' and is_deleted =1 
  2. update DWH_META_tables set is_deleted =0 where dwh_table_name = 'dwh_inv_status_report_ln'