Data Warehouse Table Not Properly Updating Custom MVL Attributes

Products

• Clarity PPM SaaS

Issue/Introduction

At times the incremental job runs records in the associated Data Warehouse language tables (_LN) are removed. 

STEPS TO REPRODUCE:

1. Create a multi valued lookup type attribute on an object and include it it DWH 
   • For this example it was created on the Risk Object
2. Run the Full Load
3. Run the Incremental Load
4. Add a new entry on the lookup 
5. Run the Incremental Load

Expected Results: All the records are in the two related tables: object table and _LN table. 

 

Actual Results: Records are removed from the _LN table.  

 

Workaround: Run Full Load. 

 

Environment

Release : 16.0.1.1

Component : Clarity Data Warehouse

Cause

When values are added to the multi valued lookup the incremental data warehouse job is not recognizing these and removing the values for the object's associated _LN table.

Values are also nulled out from   DWH_CMN_MV_LOOKUP.DISPLAY_VALUE

Resolution

Resolved in 16.1.0 and 16.0.3.1. It was originally tracked as DE65445.