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
In few cases, where special characters are present in the Lookup Values, we observed that the MVL job fails. This is due to DE68155
DE68155 is addressed in 16.1.2 and 16.1.1.1