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
- Create 2 new Project custom attributes, one large string and another rich text
- Enable both attributes for DWH
- Populate data for a Project with 5000 characters for each attribute in Clarity
- Run DWH full load
- 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
Resolution
DE169216 in review by Engineering
Feedback
Was this article helpful?
thumb_up
Yes
thumb_down
No