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.

A custom MVL field intermittently not updated in Data Warehouse


Article ID: 133417


Updated On:


Clarity PPM On Premise


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


Last Updated Date on the field updated whilst the job is running


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.