ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 219136

calendar_today

Updated On:

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

Cause

This is due to defect DE61727

Environment

Release : 15.9.2, 15.9.3

Component : CLARITY DATA WAREHOUSE

Resolution

Fixed in 16.0

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

Additional Information

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