Load Data Warehouse Incremental slow on DWH_CMN_MV_LOOKUP

book

Article ID: 125142

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

When I run Load Data Warehouse - Incremental, it takes very long time, intermittently. My Full Load runs quite fast. When we check DWH_GATHER_METRICS_V, we see most of the time is taken by  DWH_CMN_MV_LOOKUP.

Cause

The intermittent slowness of DWH_CMN_MV_LOOKUP on Incremental Load was addressed by Development in user story S150853 in PPM version 15.4.1.
 

Environment

Release: CODFSS99000-15.4-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution


To get this issue addressed, plan to upgrade to 15.4.1 or higher (it's best to stay on the most current version).
When you upgrade, the Load Data Warehouse Incremental Load will no longer take that much time on DWH_CMN_MV_LOOKUP.

Until you upgrade, what you could do is schedule a Full Load to run instead, few times per day.