DWH shows duplicated data for Multi Valued lookups

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

DWH shows duplicated data for Multi Valued lookups

STEPS TO REPRODUCE:
1. Administration > Data Administration > Lookups
2. Create a Dynamic query lookup:
   id:     Z_DWH_LINKED_TASKS
   query:
    SELECT DISTINCT @SELECT:T.PRID:PRID@,
            @SELECT:ri.id:id@,
            @SELECT:T.PRNAME:TASK_NAME@,
            @SELECT:T.PREXTERNALID:TASK_ID@,
            @SELECT:T.LAST_UPDATED_DATE:LAST_UPDATED_DATE@
    FROM PRTASK T
    inner join inv_investments inv on inv.id = t.prprojectid
    inner join RIM_RISKS_AND_ISSUES ri on ri.pk_id = inv.id
            WHERE 
            ri.id = @WHERE:PARAM:USER_DEF:INTEGER:ri_id@
            AND @FILTER@   
3. Administration > Studio > Objects > Risk object
4. Create a Multi Valued lookup attribute linked to the lookup above: DWH Linked tasks (z_dwh_linked_tasks)
5. Include the field in the DWH
6. Run the Load DWH job
7. On a project, create a couple of tasks TaskA and TaskB
8. On the Risks/Issues/Changes > Create a RiskA 
9. On the Associated Tasks tab, add TaskA 
10. On the Risks/Issues/Changes > Create a RiskB
11. On the Associated Tasks tab, add TaskA and Task B
12. Pull the custom attribute (DWH Linked tasks (z_dwh_linked_tasks)) to the Risk list view 
13. You see the associations done
14. Run the Load DWH job
15. Query the DWH
    select z_dwh_linked_tasks, z_dwh_linked_tasks_key
    from dwh_rim_risk
    where z_dwh_linked_tasks is not null

Expected Results: DWH shows data correctly.
Actual results: DWH shows duplicated data

Environment

Clarity 16.1.1 

Cause

This is caused by DE68873

Resolution

This is currently being analyzed by Engineering