Performance of Load Data Warehouse job is slower than expected

Article Id: 38917
Status: Published
Updated On: 14-02-2018 07:54
Legacy Id: TEC1996475
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
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: