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?
Release : 15.9.1
Component : CA PPM DATA WAREHOUSE
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