Load DWH Full - When to run to prevent failures

book

Article ID: 224741

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

There are times the Load Data Warehouse (DWH) job Full Load needs to run versus Incremental to prevent job failures. This article covers the scenarios when the full load should be run

Resolution

Run the full load DWH after any of the below:

1. Upgrade (release or patch)

  • Upgrade or installation of a patch on Clarity. See Data Warehouse Required section in End Here: Common Steps After All New Installs and Upgrades where this is referenced along with other recommended steps.

2. Attribute deletion (or removal from DWH)

  • Deletion of an attribute in Studio
  • Unselecting the Include in the Data Warehouse option for the attribute in Studio. You cannot re-enable the attribute for inclusion in the data warehouse unless at least this job has completed one run.

3. Time Slice Date changes

  • Change to time slice dates to include a larger timeframe.

4. First Day of Work Week setting change

  • Change of the First Day of Work Week in Administration->Project Management->Settings

5. Data Warehouse Option changes in System Options

Change to any of the settings in General Settings -> System Options -> Data Warehouse Options including:

  1. Addition of a new language. Running an incremental load of this job does not update the data warehouse with the new language.
  2. Change to the Entity for fiscal periods.

Additional Information

The job is not required to be run after changing a lookup. See After changing Lookup values - Load DWH full or incremental where this is referenced.

For other post-upgrade recommendations see: Upgrade best practices (pre / post upgrade) for Clarity

Attachments