Load Data Warehouse incremental job is failing, even when the full load is run. The error noticed in the bg-dwh.log is as below.
ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INV_IDEA. value too long for type character varying(90)
Where: PL/pgSQL function inline_code_block line 24 at RAISE
1. Find all columns that are defined as varchar(90) in the DWH schema against DWH_INV_IDEA table using the query below
where lower(table_name) = 'dwh_inv_idea'
2. Find the source column on the PPM side using DWH_META_COLUMNS table
3. Find data that is more than 90 characters long using a query such as the one below
select investment_key, some_varchar_column
where length(some_varchar_column) > 90
4. Act upon the data. Analyze why this mismatch happened.