Enable or disable the SQL Curve feature toggle

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The SQL Curves are a new feature introduced in Clarity 15.9.1, along with a new job: Time Slicing Group By (Renamed Time Slicing Sync job in 15.9.2). 

How can this feature be disabled?

Environment

Release : 15.9.1+

Resolution

1. Check if this feature is enabled

Note: This is always enabled by default starting 15.9.1

Run the following query:

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

Important:

• This feature should typically only be disabled if recommended by Broadcom support as a workaround for an issue.
• There have been a number of issues fixed in later GA releases, so it's recommended to upgrade to the latest GA release where possible to avoid any issues / prevent the need of disabling this feature.
• If using the Modern User Experience, it is not recommended to disable this as doing so can impact some data displayed. 

To temporarily disable the feature, run the below command. 

admin toggle-feature TSV_AGGREGATION_FEATURE_20550 0

3. Enable the OOTB SQL Curves feature

Disabling of the SQL curve feature is a temporary workaround, so once your issue is resolved, run the below command to re-enable the feature.

admin toggle-feature TSV_AGGREGATION_FEATURE_20550 1

4. Restart service or flush the Clarity cache

This step is required after enabling/disabling 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

Note: Upgrading an environment may automatically enable the option if it was disabled - please verify upon upgrade

Additional information on Time Slicing Group by job: 'Time Slicing Sync' job purpose