Performance of Load Data Warehouse job is slower than expected

Document ID : KB000038917
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

We have a very large dataset and the performance for the Load Data Warehouse job is very slow. The 'Full Load' takes 11 hours and the incremental load takes 5-8 hours. 

Steps to Reproduce:

  1. Login to the application
  2. Navigate to Available Jobs list
  3. Run the 'Load Data Warehouse' with with the 'Full Load' option selected

Expected Result: The job should complete in a more reasonable amount of time

Actual Result: The job completed after 11 hours

Cause:

Caused by CLRT-79355

Resolution: 

Resolved in CA PPM 14.3 Generic Patch #5 

Additional Information: 

Reference TEC1696455 : PPM 14.3 Generic Patch available to resolve reported issues