search cancel

Data Warehouse missing allocation data(DE61021)

book

Article ID: 215586

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Incremental load:  project allocation data is missing.  Scenario is Project was missed in full load, incremental load finds the project and loads it, but there is allocation data missing. 

STEPS TO REPRODUCE:

  1. Set up a project in Clarity, ensure it has team, tasks, allocation etc.
  2. Run Time Slicing
  3. Now run Load Data Warehouse - Full
  4. Query the DWH database and note the project is in the database in DWH_INV_INVESTMENT and DWH_INV_PROJECT
  5. Now start Load Data Warehouse - Full again
  6. In a minute go and edit the project (any field), click save

(if a small sandbox, edit all available projects in Modern UX grid)

  1. Upon completion, note the project is missing from DWH in DWH_INV_PROJECT
  2. Run Load Data Warehouse - Incremental and check the tables

Expected Results: The project and all project data to be added to DWH

Actual Results: The project is added but some data is missing. For example, we can see a difference by running the queries below against Clarity and DWH:

On Clarity:
select  team_key, sum(ALLOC_HOURS) from dwh_inv_team_per_facts_v
group by  team_key

On Data Warehouse:
select  team_key, sum(ALLOC_HOURS) from DWH_INV_TEAM_PERIOD_FACTS
group by  team_key

The entries are not in Data Warehouse

Environment

Release : 15.8+

Component : CA PPM DATA WAREHOUSE

Resolution

Workaround: Run the Full Load again

This is DE61021, fixed in 15.9.3 (addressed by a user story)