Enable or disable the SQL Curve feature Toggle

book

Article ID: 210730

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

The SQL Curves are a new feature introduced in Clarity 15.9.1, together with a new job Time Slicing Group By

How can this feature be disabled?

Environment

Release : 15.9.1+

Component : CA PPM TIME SLICING

Resolution

1. How to check if this feature is enabled (this is always enabled by default starting 15.9.1):

select enabled from CMN_FEATURES where code ='TSV_AGGREGATION_FEATURE_20550'
  • ENABLED =1 means the feature is enabled
  • ENABLED =0, means the feature is disabled

2. Disable the OOTB SQL Curves feature:

BEGIN

CMN_FEATURE_TOGGLE_SP('TSV_AGGREGATION_FEATURE_20550', '0');

END;

commit

3. Enable the OOTB SQL Curves feature:

BEGIN

CMN_FEATURE_TOGGLE_SP('TSV_AGGREGATION_FEATURE_20550', '1');

END;

commit

4. Restart service or flush the Clarity cache after enabling / disabling

This steps is required for the setting change to be completely taken into account

Note: Disabling the SQL Curves feature will also make the Time Slicing Group By job not visible in Administration - Reports and Jobs

Additional Information

Here is additional information on Time Slicing Group by job: Time Slicing Group By job - what it does?