MVL Values are not populated completely in DWH tables

Products

• Clarity PPM On Premise

Issue/Introduction

Steps to Reproduce :-

1. 1. Configure an MVL attribute with Project Object.
   2. Populate 400 - 500 values in the MVL attribute.
   3. Run the Load Datwarehouse Job in Full Mode

Expected Results :- The attribute column in DWH tables of this object should be populated with the 400 - 500 values
Actual Results :- The attribute column in DWH stores a truncated version of the values.

 

 

Environment

Release : 16.0.3

Cause

This is caused by the limitation of VARCHAR/VARCHAR2 data type. They can only store data worth 4000 bytes. 

 

Resolution

To prevent the failure of DWH job, if the combined values exceed 4000 bytes we are capping the values to 3995 bytes. Any value exceeding this will not be stored in the DWH tables.

This is not a defect and is working as expected.