Attributes are not appearing in PPM_DWH database when selected and enabled in Bulk from Attributes' List

book

Article ID: 36856

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

Issue:    

Attributes that were selected to be included in the Data Warehouse may not show up in the associated DWH tables.

This may happen if you select to include the attributes from the attributes list page.
Steps to Reproduce:
  1. Create a custom object or use an OOTB object
  2. Enable if for data warehouse on the properties page  
  3. On the object’s attribute list page select attributes using the checkbox and then select Include in Data Warehouse  
  4. Click Save  
  5. Run Load Data Warehouse – Full Load

Expected Result:  The selected attributes will show in the data warehouse.

Actual Result: The selected attributes do not show in the data warehouse.

Environment:    

Applies to all 14.2 supported PAS environments for specified releases.  

Cause:

Caused by CLRT-78422

Resolution:

Resolved in CA PPM 14.3 

Workaround:

  1. Open each attribute properties page 
  2. Uncheck Include in Data Warehouse 
  3. Save and Return (Do this for all affected attributes) 
  4. Run Load Data Warehouse – Full Load 
  5. Open each attribute properties page 
  6. Check Include in Data Warehouse 
  7. Save and Return (Do this for all attributes that were unchecked) 
  8. Run Load Data Warehouse – Full Load 

Additional Information:

Reference CA PPM Resolved Defects Index for CA PPM 14.3

 

Environment

Release: ESPCLA99000-14.2-Clarity-Extended Support Plus
Component: