ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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