Tables are not deleting in DWH after removing Custom investment type objects from DWH

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Excluding a Custom Investment Object from the Data warehouse (DWH) leaves an orphan table in the Data warehouse schema

Steps to Reproduce: 

1. Login to Clarity using administration rights
2. Navigate to Administration --> Studio --> Objects
3. Create a customer Investment object (ex: Custom Epic (dwh_z_odf_custom_epic))
4. Include the custom Investment object (ex: Custom Epic (dwh_z_odf_custom_epic)) in the Data Warehouse by checking INCLUDE IN THE DATA WAREHOUSE
5. Navigate to Reports and Jobs and run the Load Data warehouse job as Full Load
6. Wait for the Load Data warehouse job to be completed. You will then see a table dwh_z_odf_custom_epic table created in the Data Warehouse schema
7. Navigate back to Administration --> Studio --> Objects --> Custom Epic (dwh_z_odf_custom_epic)
8. Uncheck INCLUDE IN THE DATA WAREHOUSE under the object properties page
9. Navigate again to Reports and Jobs and run the Load Data warehouse Job as Full Load
10. Wait for the Load Data warehouse job to complete

Expected Results: The table dwh_z_odf_custom_epic should get deleted upon excluding an object from the Data Warehouse.

Actual Results: The table dwh_z_odf_custom_epic remain in the Data Warehouse schema.

Environment

Release : 15.9.2, 15.9.3

Component : CLARITY DATA WAREHOUSE

Cause

DE61727 

Workaround (On Premise only)

1. Connect to the Clarity Database
2. Run the below update 
   
   UPDATE DWH_META_TABLES SET IS_DELETED = 1
where DWH_TABLE_NAME = 'dwh_z_odf_custom_epic'
   
   
3. Run the Load Data warehouse in Full Load 

Resolution

Fixed in Release 16.0.0 

Additional Information

See also: Data Warehouse (DWH) known issues for Clarity