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.

Error - The DWH Date Different than the Transactional Database Date

book

Article ID: 217290

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When running the Load DWH Job, it fails with: 

DWH Time Abort - The Data Warehouse Date is Different than the Transactional Database Date

Checked the database time between Clarity and Data Warehouse and it matches, what can be done to fix this.

Environment

Release : Any

Resolution

  1. Go to Administration - Health Report (it may take a moment to run)
  2. Look in Database and Data Warehouse what the timezone is. In Phoenix UI you may have to scroll right to be able to compare the dates.
  3. You can then adjust the time/timezone manually and see if it displays correctly.
  4. If any changes on the application server, a restart may be necessary. 
  5. Then run Load Data Warehouse - Full Load

Additional Information

  • The time between app server, database server and DWH server should match, ideally to the second. This is required for the Load Data Warehouse job to run correctly. 
  • Over 10 seconds difference could trigger this error message
  • In order to ensure consistency it's recommended to not set time manually on servers rather use NTP for clock synchronization