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