Datamart rollup job is slow (MSSQL-specific)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Datamart Rollup job takes around 250 minutes to execute each time it runs.

STEPS TO REPRODUCE:

1. Login to the restored customer dataset
2. Run the Datamart rollup job

Expected Results: The Datamart rollup job to execute at a reasonable time
Actual Results: The Datamart rollup job takes around 250 minutes to execute each time

Cause

This is caused by DE77410

Resolution

This is fixed in 16.2.1