Disable SQL Curve data leaves the DWH *_CRV_FACTS tables

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Disabling Include Sql Curve Data does not remove the DWH *_CRV_FACTS tables. The delete flag is never propagated to the DWH (DROP_FLAG=0) because the corresponding _CRV_FACTS rows are not in the Clarity DWH_META_TABLES when the cleanup runs

STEPS TO REPRODUCE:
1. On an environment with SQL Curve data enabled, check the tables with query:
2. In Clarity:
select * from DWH_META_TABLES where upper(dwh_table_name) like '%CRV%'
• dwh_rdm_roadmap_item_crv_facts
• dwh_inv_team_crv_facts
• dwh_fin_plan_crv_facts
• dwh_fin_benefit_plan_crv_facts
• dwh_tme_entry_crv_facts
• dwh_inv_investment_crv_facts
• dwh_res_resource_crv_facts
• dwh_inv_task_crv_facts
• dwh_inv_assignment_crv_facts
• dwh_tme_sheet_crv_facts
3. In DWH:
select * from DWH_META_TABLES where upper(dwh_table) like '%CRV%'
• DWH_FIN_BENEFIT_PLAN_CRV_FACTS
• DWH_FIN_PLAN_CRV_FACTS
• DWH_INV_ASSIGNMENT_CRV_FACTS
• DWH_INV_INVESTMENT_CRV_FACTS
• DWH_INV_TASK_CRV_FACTS
• DWH_INV_TEAM_CRV_FACTS
• DWH_RDM_ROADMAP_CRV_FACTS
• DWH_RDM_ROADMAP_ITEM_CRV_FACTS
• DWH_RES_RESOURCE_CRV_FACTS
• DWH_TME_ENTRY_CRV_FACTS
• DWH_TME_SHEET_CRV_FACTS
4. Now go to Clarity Classic – Administration – System Options
5. Disable Include Sql Curve Data
6. Save and make sure that the job Load SQL Curves in Completed in Job – Log
7. Run the SQL queries again

Expected Results: All the *CRV tables to be cleaned up as SQL Curve data is disabled
Actual Results: Only Clarity database *CRV tables are removed, the ones in the DWH database are still present, although not used

Environment

Clarity 16.4.2, 16.4.3

Cause

DE209287

Resolution

Fixed in Clarity 16.5.0

Workaround: The tables may be dropped manually by DBA if required. Otherwise, ignore the tables in DWH