search cancel

Incremental Load Data Warehouse not updating "Current" on custom Status Report Object Intact Status Report


Article ID: 241687


Updated On:


Clarity PPM SaaS


The name of the object is

And the attribute that we are having issues with is “current”


The Full Load updates it, but the Incremental does not.


Release : 16.0.1

Component : Clarity Data Warehouse


The Is Current flag on Intact Status Reports object is being modified by Processes > Gel Scripts via a direct sql update.

Because the last modified timestamp is not updated, the Load Data Warehouse does not pick up these changes.

If you are updating database tables/objects through direct database updates, please be sure to update the Last Modified Date column, so the changes are picked up by the Incremental Load Data Warehouse