Load DWH performance on DWH_INV_TASK_HIERARCHY when run Incrementally

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse (DHW) Incremental job is taking a long time to complete even though no data has been modified. Most of this time is spent on DWH_INV_TASK_HIERARCHY.

STEPS TO REPRODUCE:

1. On a large dataset (with no users in the system), run a Full Load of Data Warehouse
2. Now run an Incremental Load

Expected Results: The Incremental job to complete within a reasonable time

Actual Results: The Incremental job is taking 40 min to 1h although no data has been modified. Most of this time is spent on DWH_INV_TASK_HIERARCHY

Environment

Release : 15.8. 15.8.1, 15.9, 15.9.1, 15.9.2

Cause

This is caused by DE57828

Resolution

Fixed in Clarity 15.9.3

Additional Information

See also KB: Data Warehouse (DWH) known issues