Load Data Warehouse Job failing on DWH_CMN_PERIOD_LN value too long for type character varying(32)

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

Environment

Release : 16.0.0

Component : CLARITY DATA WAREHOUSE

Resolution

DE64255, Fixed in 16.0.2.

Workaround: Shorten the period name to be less then 32 characters