The Incremental Load DWH job slow on DWH_CMN_MV_LOOKUP table

book

Article ID: 145375

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

STEPS TO REPRODUCE :

1. Login to Clarity PPM.
2. Create a Multi Value Lookup (MVL) attribute and include it in DWH.
3. Populate values to the Attribute.
4. Run DWH Full Load. It completes and you see that values are populated for the MVL Attribute.
5. Go back to investment where MVL attribute is configured and remove the values(Nullify). 
6. Run DWH Incremental Load.

Expected Results: Job completes within a reasonable amount of time. 
Actual Results : Incremental Job times out after running for 11 hours as 600 mins is the Time-out that's set.

Cause

This is a defect DE50332 / DE58254

Environment

Clarity PPM 15.8, 15.8.1,15.9, 15.9.1

Resolution

This is fixed in 15.9.2

Workaround for lower releases: Run the Full Load DWH job