Attributes missing from Data Warehouse

book

Article ID: 36065

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Issue:    

In PPM Version 14.2 attributes may not appear in the Data Warehouse if you select ‘Include in Data Warehouse’ from the attribute list page instead of the specific attribute properties page.

This can happen for attributes on stock objects as well as custom objects.

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 job, Load Data Warehouse – Full Load

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

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

Cause:    

Caused by CLRT-78422  Affects 14.2

Resolution:    

Resolved in CA PPM 14.3

Workaround:    

  1. Open each attribute properties page 
  2. Uncheck Include in Data Warehouse
  3. Save and Return
  4. Repeat steps (Do this for all affected attributes)
  5. Run Load Data Warehouse – Full Load
  6. Open each attribute properties page
  7. Check Include in Data Warehouse
  8. Save and Return
  9. Repeat steps (Do this for all attributes that were unchecked)
  10. 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: