SQL Curves null out queries

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We do not use Modern User Experience (UX) and would like to remove the SQL Curves data, as it's slowing down job performance. How can we do that? 

Environment

Release : 15.9.1+

Component : CLARITY TIME SLICING

Resolution

Please run the SQL Curves removal queries below:

update niku.prassignment
set odf_nk_prestcurve =null,
odf_nk_practcurve =null,
odf_nk_etccost_curve =null,
odf_nk_actcost_curve =null

commit

update prteam
set odf_nk_alloccost_curve =null,
odf_nk_hardallccost_curve =null,
odf_nk_odf_pralloccurve =null,
odf_nk_odf_hard_curve =null

commit

update fin_cost_plan_details
set odf_nk_billing_cost =null,
odf_nk_billing_revenue =null,
odf_nk_cost =null,
odf_nk_revenue =null,
odf_nk_units =null,
odf_nk_cost_variance =null,
odf_nk_revenue_actual =null,
odf_nk_units_variance =null,
odf_nk_cost_actual=null,
odf_nk_units_actual=null,
odf_nk_revenue_variance =null

commit

The queries may run for a long time before completing on large dataset.

Note: This will remove all the SQL Curves data in Modern UX: i.e. Staffing, Assignments, Financial data in the TSV. Classic UI is not affected. To be run with caution as it removes slice data.

Additional Information

See also: Enable or disable the SQL Curve feature toggle