Data for MVL lookup attributes missing in DWH starting in 16.0

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Since upgrading to 16.0, none of the values for the custom multivalue lookup (MVL) attributes are showing in the Data Warehouse (DWH), they are blank in DWH_INV_INVESTMENT

Out of the Box (OOTB) multi-value lookups work as expected. The Load DWH job runs with no issues or errors (both Incremental and Full).

STEPS TO REPRODUCE: 

1.  Create a static lookup with a few values
   • Lookup Name:  Company Stats
   • Lookup ID:  R_COMPANY
   • Static List - Alphanumeric
   • Values:  
     • ABC
     • DEF
     • GHI
2. Create a MVL type attribute on the investment object
   • ID:  r_company
   • Name:  Company Stats
   • Type:  MVL
   • Alias: c_Company
   • Include in DWH
3. On the Ideas (or any investment type) add some of the values for this attribute
    - This can be done from the list page by adding the new attribute to the list view.
4. Run the Load Data Warehouse  job- Full Load
5. Create an ad-hoc view for the associated domain or check the associated _ln table for the values.  You can filter for the investment_key

Expected Results: Values are available in the ad-hoc and also in the associated _LN tables, i.e. DWH_INV_INVESTMENT and DWH_INV_INVESTMENT_LN

Actual Results: Values are not showing.

Environment

Release : 16.0.0

Component : CLARITY DATA WAREHOUSE

Cause

DE63339 / DE63349 

Resolution

On Premise: Fixed in 16.0.1 and patched in 16.0.0.1.

GCP: This is fixed in all GCP environments

Workaround: 

If the job is failing refer to this article:

Load DWH fails on DWH_CMN_MVL_LOAD after upgrade to 16.0

The solution here is to exclude the custom attributes from the DWH which use multi-valued lookups until the patch is applied.