Time Slicing Sync Job Performance on table fin_cost_plan_details

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Time Slicing Sync takes an average of 2-3 minutes to run. Provided that it’s incompatible with Time Slicing, that can create a bottleneck and stop important slices from being up to date

STEPS TO REPRODUCE

On a large customer dataset with many calendars, schedule the below jobs:

1. Time Slicing job – every 1 min
2. Time Slicing Sync job – every 5 minutes
3. Observe the jobs and the timings

Expected Results: Time Slicing Sync to be running within reasonable time

Actual Results: Time Slicing Sync is running for 2-3 min average, sometimes longer and keeps Time Slicing job in Waiting status and important slices are not getting updated

Environment

Clarity 16.1.x, 16.2.x, 16.3.0, 16.3.1

Cause

DE166275

Resolution

DE166275, converted to user story

We are adding a general improvement to the query for all tables including fin_cost_plan_details, prteam, prassignment etc.