search cancel

Incremental DWH Job Failing since Refresh

book

Article ID: 213157

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

After a data refresh was performed for an environment, the Incremental Data Warehouse Load job is failing. The Full job works successfully.

 

Environment

Release : SAAS

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

The Data Warehouse needed to be restored with a clean database. Once completed the following jobs need to be run:

Load Data Warehouse Access Rights
Load Data Warehouse (Full Load option)

Then you may proceed with the Incremental Load Data Warehouse job

Additional Information

Reference

When to rebuild the Data Warehouse (DWH) database