Large string and rich text attributes are truncated to 1000 characters in the Data Warehouse for all DB vendors.
search cancel

Large string and rich text attributes are truncated to 1000 characters in the Data Warehouse for all DB vendors.

book

Article ID: 282105

calendar_today

Updated On: 04-25-2025

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

Actual Behavior: 1000 characters in each attribute was populated in DWH

Expected Behavior: 4000 characters in each attribute is populated in DWH

Environment

16.3.0, 16.3.1, 16.3.2 

Cause

DE169216

Resolution

DE169216 in review by Engineering