The Incremental Load DWH job slow on DWH_CMN_MV_LOOKUP table
book
Article ID: 145375
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity 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.
Environment
Clarity PPM 15.8, 15.8.1,15.9, 15.9.1
Cause
This is a defect DE50332 / DE58254
Resolution
This is fixed in 15.9.2
Workaround for lower releases: Run the Full Load DWH job