book
Article ID: 189103
calendar_today
Updated On:
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.
Environment
Release : 15.7.1
Component : CA PPM DATA WAREHOUSE
Resolution
This is addressed in 15.8 version.