Custom Investments have the column 'name' loaded in the DWH

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There is an issue with custom objects that are investment extensions. When a new custom object is set up in studio as an investment extension, the field 'name' is inserted into dwh_meta_columns. For an investment extension, this is wrong.

There should be no 'name' column because the name is pulled from inv_investments.  For a custom object that is NOT an investment extension, 'name' should and does get inserted into dwh_meta_columns.

Steps to Reproduce: 

1. Classic, Administration, Studio: Objects -- Create a new object and choose Investment Extension 
2. Check the 'Include in the Data Warehouse' Boolean field on the Object Properties 
3. Query the 'dwh_meta_columns' table for the new object.  You will see 'name' as one of the columns in the table schema 

Expected Results: 'Name' should not be a column.  The name is already stored in dwh_inv_investment

Actual Results: You will see 'name' as one of the columns in the table schema. 

Cause

DE62302 

Environment

Release 15.9.3 

Resolution

• Fixed in Release 16.0.0
• Fixed in Release 15.9.3 Patch #1 (15.9.3.1) 

Additional Information

• Reference 16.0.0 Clarity Release Notes > Resolved Defects 
• Reference 15.9.3 Clarity and Jaspersoft Cumulative Patch README Files