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.

Data missing in DWH in FACTS tables and on reports due to Time zone mismatch


Article ID: 128030


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


Significant data is missing in some of the reports and in the Data Warehouse (DWH). The FACTS tables do not have most of the data. The jobs run as expected.


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


Release: Any
Component: Data Warehouse (DWH)


  1. Ensure that the time/date between the Application server and the database server is the same up to the second. This is a requirement for Data Warehouse to work in order to match the dates between database and application.
  2. Once the times are synced up, run Load Data Warehouse - Full Load and check the data again.

Note: If you are using a time sync service to sync the server to the correct time, ensure the service is up and running.

Additional Information

More detail and discussion in Communities thread: Data Warehouse Completes, but is Incomplete

See also: