ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 217190

calendar_today

Updated On:

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.