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

1. Use the workaround, if needing to continue using the attribute, e.g.

if <your_attribute> is attribute1, the DWH will have a corresponding attribute attribute1_rtf created.

Then the following query can be used to obtain the full text.

select DWH_GET_PLAIN_TEXT_FCT(attribute1_rtf)
from dwh_inv_project

2. Create a new attribute which will use the new CLOB data type.