After 15.9 install DWH is failing with error "The Data Warehouse Date is Different than the Transactional Database Date."

book

Article ID: 210031

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Everything else in the upgrade is complete, however the Load DWH job fails with the message of 

"The Data Warehouse Date is Different than the Transactional Database Date."

The DWH users job ran successfully.

Sysdate command on the niku and dwh schemas matched except for a few seconds. Why is this error message appearing?

 

Environment

Release : 15.9.1

Component : CA PPM DATA WAREHOUSE

Resolution

ETL is comparing the ppm time (including time zone) with the dwh. This time is used to determine which records will be brought over to dwh based on last updated date/time, so it is important they match otherwise you will be having data discrepancies. More information is here