SUMMARY: Load Data Warehouse Job failing with ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_CMN_PERIOD_LN. value too long for type character varying(32) Where: PL/pgSQL function inline_code_block line 24 at RAISE.
STEPS TO REPRODUCE:
1. Navigate to Administration/Setup/Entities/Fiscal Time Periods
2. Update Period Name to "January 1, 2022 - January 31, 2022", basically making the length greater then 32 characters for Monthly Period Type for Start Date:1/1/2022 and End Date:1/31/2022
3. Run Load Data Warehouse Job and notice it will fail with error on DWH_CMN_PERIOD_LN value too long for type character varying(32)
Expected Results: It should allow length for period type to be greater then 32 as UI in Classic user can save it.
Actual Results: Load Data Warehouse job is failing
Release : 16.0.0
Component : CLARITY DATA WAREHOUSE
DE64255, Fixed in 16.0.2.
Workaround: Shorten the period name to be less then 32 characters