Data missing in Data Warehouse in FACTS tables and on reports

Document ID : KB000128030
Last Modified Date : 26/02/2019
Show Technical Document Details
Issue:
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 parameter should indicate red if over 15sec, and so far it doesn't, this is logged as DE48031

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.
Additional Information:
More detail and discussion in Communities thread:
https://communities.ca.com/thread/241782487-data-warehouse-completes-but-is-incomplete