Load DWH job fails after Enable Plan Actuals is set to 1

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After enabling DWH Plan Actuals toggle, and running Update Financial Plan Actuals job, Load Data Warehouse fails with ERROR: cannot change data type of view column "transaction_class" from character varying to character varying(2100)

 

STEPS TO REPRODUCE:

1. Set up Clarity with PG and DWH
2. Ensure Load DWH Full is running successfully
3. Now enable  Enable Plan Actuals Toggle for Financial Period Plan Facts
   • updatedwh_settings set enable_plan_actuals = 1;
   • commit
4. Run Update Financial Plan Actuals job to completion
5. Run Load Data Warehouse – Full Load

 

Expected Results: the job to complete Successfully

Actual Results: Load DWH job fails with error

2025/02/12 14:30:23 - Refresh Matl View - ERROR: cannot change data type of view column "transaction_class" from character varying to character varying(2100)

  Where: SQL statement "CREATE OR REPLACE VIEW dwh_fin_plan_virtual_v

 

Environment

Clarity 16.3.0, 16.3.1

Cause

DE166204

Resolution

Fixed in 16.3.2