search cancel

Data warehouse incremental load is pushing wrong START_DATE,FINISH_DATE in DWH_INV_TEAM table

book

Article ID: 228872

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Summary: The Data Warehouse Incremental Load is pushing the wrong START_DATE,FINISH_DATE into the DWH_INV_TEAM table.
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