'String or binary data would be truncated' error when running DWH job

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We are running Load Data Warehouse job - Full and hitting this error message:

INFO  2021-06-09 01:01:47,383 [dwh_mssql_error_handling UUID: 27b0dfaa-1887-4714-8357-dbe6b6d7bb30] dwh.event  - Error for table 'DWH_RDM_PICKLIST_LN' - Error Number 8152 'String or binary data would be truncated.'

It may happen on other tables as well.

Environment

Release : Any on SQL Server

Component : CA PPM DATA WAREHOUSE

Resolution

This is an issue with data length. Check the corresponding Clarity view, and compare to attribute length in DWH_META_COLUMNS. Anything that's out of bounds, has to be corrected.