On running Load Data Warehouse (DWH), 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
This is an issue due to a change in attribute size length that wasn't reflected in Data Warehouse. It may not be noticeable at first if the data in the field still falls within the original size of the attribute.
Release : Any
Component : Data Warehouse (DWH)
This should work to recreate the field in Data Warehouse with the correct length.
It's suggested that when the attribute size is changed:
This should ensure the size updates correctly before you run into any errors on the Load Data Warehouse job.