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.

Load DWH performance on DWH_INV_TASK_HIERARCHY when run Incrementally

book

Article ID: 199367

calendar_today

Updated On:

Products

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

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

Cause

This is caused by DE57828

Environment

Release : 15.8. 15.8.1, 15.9, 15.9.1, 15.9.2

Component : CLARITY DATA WAREHOUSE

Resolution

Fixed in Clarity 15.9.3

Additional Information

See also KB: Data Warehouse (DWH) known issues