Load DWH fails with Roadmap item custom attributes (GCP)

Products

• Clarity PPM SaaS

Issue/Introduction

When a boolean attribute is present on the roadmap items object that is included for DWH, the full Load DWH job fails.

Calculated fields, money type fields also cause the same failure

STEPS TO REPRODUCE:

1. Create a boolean attribute on the project object
   • Attribute name: boo
   • Attribute ID: boo
   • API Attribute ID: z_boo
   • Include in DWH checked
2. Create a boolean attribute on the roadmap item object
   • Attribute name: boo
   • Attribute ID: boo
   • API Attribute ID: z_boo
   • Include in DWH checked
3. On the Modern UX, go to Roadmaps
4. Create a roadmap
5. On the grid view, add the boolean attribute
6. Add a couple of projects as roadmamp items to the roadmap
7. Sync linked items: ensure matcing custom attributes checkbox is on
8. Run the Load DWH job in full mode

Expected results: The Load DWH job to succeed
Actual results: The Load DWH job fails 

Environment

Clarity 15.8, 15.8.1, 15.9, 15.9.1

Cause

This is caused by DE58927

Resolution

Fixed in 15.9.2

Workaround: Do not include boolean attributes (affected custom attributes) in DWH on the roadmap items object. Exclude the field noted on the log file from DWH

Additional Information

If you encounter this issue, please check all custom attributes included for DWH in the roadmap item object.

The log error, mentions the attribute that causes the issue (below marked in yellow)

This can happen also with money type custom attributes and also calculated ones.

 

This so far is reproduced in Postgress DB only

Error that can be seen on the job failure:
set variables - An error occurred executing this job entry : 
Couldn't execute SQL: CALL DWH_CFG_ADDIN_EXTRAS_SP();
CALL DWH_PROC_NEW_VIEWS_SP();

ERROR: cannot change name of view column "dw_updated_date" to "boo"
  Where: SQL statement "CREATE OR REPLACE VIEW dwh_cmn_scenario_tgt_facts_v AS SELECT f.scenario_key, SUM(CASE WHEN f.attribute = 'totalActualCost' THEN f.attribute_value ELSE 0 END) actual_total_cost, SUM(CASE WHEN f.attribute = 'actualCapitalCost' THEN f.attribute_value ELSE 0 END) actual_capital_cost, SUM(CASE WHEN f.attribute = 'actualOperatingCost' THEN f.attribute_value ELSE 0 END) actual_operating_cost, SUM(CASE WHEN f.attribute = 'benefit' THEN f.attribute_value ELSE 0 END) benefit, SUM(CASE WHEN f.attribute = 'capacity' THEN attribute_value ELSE 0 END) capacity, SUM(CASE WHEN f.attribute = 'actual' THEN attribute_value ELSE 0 END) actual_capacity, SUM(CASE WHEN f.attribute = 'remainingCapacity' THEN attribute_value ELSE 0 END) remain_capacity, SUM(CASE WHEN f.attribute = 'irr' THEN f