DWH Tables and Logs not Updating - Load DWH job seems to be frozen (no errors)

book

Article ID: 208518

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The DWH Audit page is showing the updated date/times of 2/4 8 pm PT, and the DWH Log last updated on 2/4 8:20 pm PT.

The Data Warehouse does not seem to have run or completed for the past 12 hours.

Cause

A small fetch size is currently configured.

This will be increased in upcoming maintenance to avoid performance issues.

Environment

Release : 15.9, 15.9.0.1

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

This is being tracked under defect: DE59761