DWH full load is leaving a Constraint on DWH_TMP_TSV_CHANGES in Disabled State(Oracle)

Products

• Clarity PPM On Premise

Issue/Introduction

When a Load Datawarehouse Full Load job is run, few table constraints are Disabled and Re-enabled after the data load is complete.

One particular constraint on table DWH_TMP_TSV_CHANGES is not being re-enabled. Even if DBA enables the constraint manually, it gets Disabled on the next run of Load Datawarehouse. 

Environment

Clarity PPM 16.4.0

Cause

DE179687

Resolution

This is fixed in 16.4.2

Additional Information

This is currently not causing any issues with the Data warehouse job functionality.