search cancel

DWH table counts Inconsistent in DWH_INV_ASSIGN_PERIOD_FACTS

book

Article ID: 202980

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

We run a full run of the data warehouse job every hour for reporting. Recently, the job has resulted in lower than expected numbers for the data warehouse tables (such as : DWH_INV_ASSIGN_PERIOD_FACTS).

We have made everything incompatible with the job and paused every job except for time slicing.

What can help fix this, and is there anything we can run to verify what the counts should be from the transactional database?

Environment

Release : 15.8.1

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

Restart App and BG services

For script options, some queries are available in KB: Data Discrepancies in Actuals, Estimates or Allocation

Additional Information

If on a Clarity version lower then 15.6, see also: Assignments in Report Incorrect: DWH_INV_ASSIGN_PERIOD_FACTS issue