Load DWH Fails With Time-Varying Attribute After Switching Include SQL Curve Data

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Custom Time-Varying attribute causes Load Data Warehouse (DWH) Full Load failure after SQL Curves are re-enabled, with error: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_RDM_ROADMAP_ITEM_CRV_FACTS. column 'z_attribute' does not exist

Steps to Reproduce:

1. Create at least one Roadmap with at least one Roadmap Item.
2. Go to Administration > System Options > Data Warehouse. Check 'Include SQL Curve Data'. Save and wait for completion.
3. Run a Full Load Data Warehouse job.
4. Go to Administration > System Options > Data Warehouse. Uncheck 'Include SQL Curve Data'. Save and wait for completion.
5. Go to Studio > Objects > Roadmap Item > Attributes > New Attribute. Configure:
   Name/Attribute ID/API Attribute ID: z_attribute
   Data Type: Time-Varying
   Time-varying Data Units: Money (this is a Time-Varying/SQL Curve attribute type)
   Currency Code Location: Currency
   Check 'Include in Data Warehouse'
   Save.
6. Go to Administration > System Options > Data Warehouse. Check 'Include SQL Curve Data'. Save and wait for completion.
7. Run the Load Data Warehouse job using a Full Load.

Expected Results: Load Data Warehouse job succeeds. 

Actual Results: Load Data Warehouse job fails. The DWH job log contains:
(PostgreSQL): ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_RDM_ROADMAP_ITEM_CRV_FACTS. column "z_attribute" does not exist.
(Oracle): ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_RDM_ROADMAP_ITEM_CRV_FACTS). SQLERRM : ORA-00904: "Z_ATTRIBUTE": invalid identifier

Environment

Clarity 16.4.2

Cause

DE203596

Resolution

This issue is under review.