Performance of Load Data Warehouse job is slower than expected

Products

• Clarity PPM On Premise

Issue/Introduction

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  

Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component: