ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Time Slicing Job running longer on rollover (MSSQL)

book

Article ID: 218075

calendar_today

Updated On:

Products

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

Issue/Introduction

Time Slicing job is running longer since the upgrade to 15.9.1.1/15.9.2 on rollover, especially quarterly. 

Steps to Reproduce:

  1. On a large MSSQL database run a quarterly rollover (monthly also has an issue but quarterly is the slowest)

Expected Results: The Time Slicing job to complete within time

Actual Results: The Time Slicing is very slow and can take up to a day to ru

Environment

Release : 15.9.1.1, 15.9.2

Component : CLARITY TIME SLICING

Resolution

This is DE61494, fixed in 16.0

Workaround: Disabling SQL curves can help some but not by much. Reducing the amount of time slice requests can also help.

Additional Information

See also Time Slicing job slow performance - troubleshooting