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.
Release : 15.7.1
Component : CA PPM DATA WAREHOUSE
This is addressed in 15.8 version.