DWH incremental load job performance issue after turning on the Include Sql Curve Data under System Options.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise
• Clarity FedRAMP

Issue/Introduction

For the past week DWH incremental load job has been taking 60-65 mins. This job is scheduled to run every four hours. The full load runs once overnight and only takes about 18 mins. Previously the incremental load was taking only 10-15 mins. Only change we did recently was turning on the Include Sql Curve Data.

Steps to Reproduce: 

1. Choose an environment with the larger number of investments.

2. Make sure "Include Sql Curve Data" is enabled under System Options.

3. Run Load Data Warehouse job in Incremental mode.

4. Notice job took more then 4 times longer then Full Load.

Expected Results: It should not take that long to execute the job.

Actual Results: It is taking much longer for the job to run.

Environment

Clarity 16.3.3

Cause

DE178164

Resolution

This issue is fixed in:

• Clarity 16.4.0 Patch 1 (16.4.0.1)
• Clarity 16.4.1