Data missing in Data Warehouse in FACTS tables and on reports
Article ID: 128030
Updated On:
Products
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS - Application
Clarity PPM On Premise
Issue/Introduction
We found significant data missing in some of the reports. The FACTS tables do not have most of the data. The jobs run as expected.
Cause
The times between Database and Application are mismatched by more than 15 sec.
This can be seen in Administration - Health Report - Database
Parameter Application and Database Timezone Match
This can be seen in Administration - Health Report - Database
Parameter Application and Database Timezone Match
This parameter should indicate red if over 15sec, and so far it doesn't, this is logged as DE48031
Environment
Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:
Component:
Resolution
Ensure that the time/date between Application server and Database server is the same up to the second.
If you are using a time sync service to sync the server to the correct time, ensure the service is up and running.
Once the times are synced up, run Load Data Warehouse - Full Load and check the data again.
If you are using a time sync service to sync the server to the correct time, ensure the service is up and running.
Once the times are synced up, run Load Data Warehouse - Full Load and check the data again.
Additional Information
More detail and discussion in Communities thread:
https://communities.ca.com/thread/241782487-data-warehouse-completes-but-is-incomplete
https://communities.ca.com/thread/241782487-data-warehouse-completes-but-is-incomplete
Feedback
Powered by
