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

book

Article ID: 210316

calendar_today

Updated On:

Products

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

Issue/Introduction

After upgrading to 15.9.1, the Earned Value and Cost Totals job takes much longer than before. 

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 the 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

Cause

This is DE60061 related to the new feature SQL Curves. 

Environment

Release : 15.9.1,15.9.2

Component : CA PPM FINANCIAL MANAGEMENT

Resolution

This is DE60061, fixed in 15.9.3 and 15.9.2.1

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

Additional Information

This defect can also affect Time Slice job performance and possible cause Java Heap Space error on Update Earned Value and Cost Totals job

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