Load Data Warehouse failed with "value too long for type character varying"

book

Article ID: 208268

calendar_today

Updated On:

Products

Clarity PPM On Premise STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

On running Load Data Warehouse, an error is thrown:

ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_ODF_TEST. value too long for type character varying(60)
  Where: PL/pgSQL function inline_code_block line 23 at RAISE

Environment

Release : Any

Component : 

Resolution

This is an issue due to a change in attribute size length that wasn't reflected in Data Warehouse. To find the issue:

  1. From the query in the bg-dwh.log identify the query that is run
  2. Run the queries on the database to identify the problem field
  3. Remove the field from Data Warehouse
  4. Run a Full Load
  5. Now add the field back to Data Warehouse
  6. Run a Full Load

This should work to recreate the field in Data Warehouse with the correct length.