Large String and Rich Text Attributes Truncated to 1000 Characters in the Data Warehouse

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The rich-text format field is cutoff/truncated in the DWH.

Steps To Reproduce:
1. Create 2 new Project custom attributes, one large string and another rich text
2. Enable both attributes for DWH
3. Populate data for a Project with 5000 characters for each attribute in Clarity
4. Run DWH full load
5. Query DWH database using query tool to view the character truncation in each attribute at 1000 characters

Expected: The matching amount of characters from the transactional database should be in the DWH

Actual: Only 1000 characters are available in the DWH

 

Environment

16.4.2

Cause

DE209290

Resolution

This is under Engineering review.