A custom MVL lookup field is intermittently blank for some projects in Data Warehouse whilst populated in Clarity PPM
The lookup was on Investment, Project and Portfolio object
Release :
Component :
We found the Portfolio Sync job was running at the time Load Data Warehouse job - Full was.
To resolve the issue:
Set Load Data Warehouse job to be incompatible with Portfolio Sync job.This will ensure the last_updated_date on the fields that are also added on Portfolio object will not be updated whilst DWH job is running.