search cancel

Data for MVL lookup attributes missing in DWH starting in 16.0

book

Article ID: 229550

calendar_today

Updated On:

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.

Cause

DE63339 / DE63349 

Environment

Release : 16.0.0

Component : CLARITY DATA WAREHOUSE

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.