Data Warehouse Load fails when and MVL attribute has many values configured

Products

• Clarity PPM On Premise

Issue/Introduction

STEPS TO REPRODUCE: 
1. Login to Clarity. 
2. Create an Dynamic Query Based Lookup which has more than a 1000 values.
3. Create an MVL attribute on Project object and configure it with Above Lookup and include it for DWH.
4. Configure the Project property page with this lookup.
5. Create a project and select all 1000 values for the lookup.
6. Run the Load Datawarehouse JOB.

 

Expected Results :- DWH load completes Successfully. 
Actual Results :- DWH load Fails

Cause

In few cases, where special characters are present in the Lookup Values, we observed that the MVL job fails. This is due to DE68155

Resolution

DE68155 is addressed in 16.1.2 and 16.1.1.1