Custom Investment's Tasks are included in DWH, even though Object is excluded

Products

• Clarity PPM SaaS
• Clarity FedRAMP
• Clarity PPM On Premise

Issue/Introduction

A custom Investment Object was created in Clarity, and excluded from the DWH. The Tasks created for the Investment do sync into the DWH which is causing some issues with dangling references.
 

STEPS TO REPRODUCE - 

1. Within Studio, create a new Investment. Do not check the option to include in the DWH.
2. Create a new item for the new Investment, and create a Task for it.
3. Run the Load Data Warehouse job to sync the information from Clarity into the DWH.

EXPECTED RESULTS:

The Tasks for this Investment shouldn't be anywhere in the DWH, as the Investment isn't included.

ACTUAL RESULTS:

Within the DWH the table dwh_inv_task_hierarchy includes the reference to the created Task, which includes a reference to the ID of the custom Investment, which doesn't exist in the DWH.

Environment

Clarity 16.3.3, 16.4.0

Resolution

This is resolved in 16.4.1.

It was originally tracked as DE180070.