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)
Article ID: 218075
Updated On:
Products
Clarity PPM On Premise
Clarity PPM SaaS
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:
- 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
Feedback
Yes
No
Powered by
