Slow Update Earned Value and Cost Totals Performance with SQL Curve on (DE60061)

book

Article ID: 210316

calendar_today

Updated On:

Products

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

Issue/Introduction

DE60061 Slow Update Earned Value and Cost Totals Performance with SQL Curve on (starting 15.9.1)

After upgrade to 15.9.1, we notice the job takes much longer than before. 

This is related to the new feature SQL Curves. 

STEPS TO REPRODUCE:

  1. On a pre-15.9.1 environment, run Update Earned Value and Cost Totals job. Note the time it takes
  2. Upgrade to 15.9.1
  3. Run Update Earned Value and Cost Totals job again

Expected Results: The job to run within reasonable time
Actual Results: The Update EV and Cost Totals job is significantly slower on 15.9.1 when SQL Curves are enabled (which is the default option). If we disable SQL curves switching the toggle 'TSV_AGGREGATION_FEATURE_20550' to '0' then it starts working fast again 


Workaround: None for customers who use Modern UX as we cannot just disable Time Slices in Modern UX.
If you don't use Modern UX yes, switch the toggle 'TSV_AGGREGATION_FEATURE_20550' to '0' as workaround. You will have to switch it back when you start using Modern UX

Environment

Release : 15.9.1

Component : CA PPM FINANCIAL MANAGEMENT

Resolution

This is DE60061, in review by Engineering

Additional Information

This defect can also affect Time Slice job performance.

When the workaround is implemented, the 'Time Slicing Group By' job will no longer be visible in Clarity user interface