Data Warehouse Job Fails If Custom Attributes Are Created With Same ID as out of the box seeded attribute

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The out of the box: Created By attribute has been enabled in the DWH for all objects and is internally referenced as DWH_CREATED_BY in PPM and DWH meta data. If a custom attribute is created with the same ID, then it updates the out of the box seeded meta data attribute and causes the data warehouse job to fail.

STEPS TO REPRODUCE:

1. Log into Clarity Classic UI, navigate to Administration >>  Studio >> Objects and access the Task object
2. Create a custom calculated string attribute with the name and ID as dwh_created_by
   • Configure the calculated attribute as: Concat(created_by)
   • API enable the attribute
   • Enable Include in the Data Warehouse
3. The following alert message is displayed on GUI: "ODF-0917: Unable to make attribute dwh_created_by Data Warehouse enabled. An attribute with same code is already marked for deletion from Data Warehouse"
4. Run the Data Warehouse Full load job

Expected Results :-

The load data warehouse - full load job completes successfully

Actual Results :-

The load data warehouse job fails with the following error: "ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INV_TASK. column "dwh_created_by_caption" does not exist"

Environment

Clarity 16.4.2

Cause

DE202222

Resolution

This issue is under review by the Engineering Team