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

Products

• Clarity PPM SaaS

Issue/Introduction

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.

Environment

Release : 16.0.1

Component : Clarity Data Warehouse

Resolution

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