search cancel

Incorrect team allocation start and finish dates in DWH

book

Article ID: 228872

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The Data Warehouse Incremental Load is pushing wrong values into the START_DATE and FINISH_DATE columns of the DWH_INV_TEAM table. As a result, a mismatch arises between Team Allocation Start and Finish dates shown in Clarity, and those shown in DWH / Advanced Reporting / Reports.
STEPS TO REPRODUCE: 
  1. Login to Clarity.
  2. Run DWH Full Load.
  3. Navigate to Home -> Projects -> Team. Modify the start & finish dates for few team records.
  4. Run the DWH incremental Load. 
  5. Validate DWH_INV_TEAM table on DWH schema and you can find that the Start and Finish dates reflect the values in UI.
  6. Navigate to the same project used in step 3 and update any other DWH enabled attribute of the project. Ex :- decription field.
  7. Run the DWH incremental Load. 
 
Expected Results: DWH_INV_TEAM table shows the actual start & finish dates of Team records. 
 
Actual Results: DWH_INV_TEAM table shows the start and finish dates of the investment. 
 

Cause

DE63242 

Environment

Release : 15.9.2, 15.9.3, 16.0.0, 16.0.1 

Component : CLARITY DATA WAREHOUSE

Resolution

Resolved in 16.0.2