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.

SQL Curves null out queries

book

Article ID: 213811

calendar_today

Updated On:

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