search cancel

Clarity : (MSSQL) Incremental Load DWH job hangs and doesn't get completed 15.7.1

book

Article ID: 189103

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Executing the incremental DWH job hangs for more than 500 minutes. Previous issue, DE48981 was fixed in PPM 15.6, however, this is reproduced on MSSQL in 15.7.1 with the same steps to reproduce. 


STEPS TO REPRODUCE: 

1. In an MSSQL environment, Run Load Data Warehouse - Full 
2. Run Load Data Warehouse - Incremental 
3. Note it takes 10-15 min 
4. Now create a project, assign 3 resources to 3 tasks, assign ETC 
5. Run Incremental again 


Expected Results: Job to run just a bit slower than previously. 
Actual Results - Job hangs for 500+ minutes. 

Cause

This is Defect DE52582

Environment

Release : 15.7.1

Component : CA PPM DATA WAREHOUSE

Resolution

This is addressed in 15.8 version.