Duplicate tasks are visible in UI

Products

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

Issue/Introduction

There are duplicate tasks visible in UI however in database tasks are not duplicated.

The impact of the same is below 

• Load Data warehouse job will fail
• The task are seen duplicated in Classic UI 
• In MUX task grids are not loading and error is shown

Environment

Any Clarity Release 

Cause

This is due to a baseline reference for the task is cross linked to multiple investments and can be found by running the below query

SELECT
    bd.ID AS baseline_detail_id,
    bd.BASELINE_ID,
    bd.OBJECT_TYPE,
    bd.OBJECT_ID AS task_id,
    t.PRID AS task_prid,
    t.PRNAME AS task_name,
    t.PRPROJECTID AS task_project_id,
    task_project.NAME AS task_project_name,
    task_project.CODE AS task_project_code,
    b.ID AS baseline_id,
    b.PROJECT_ID AS baseline_project_id,
    baseline_project.NAME AS baseline_project_name,
    baseline_project.CODE AS baseline_project_code,
    b.NAME AS baseline_name,
    b.CODE AS baseline_code
FROM
    PRJ_BASELINE_DETAILS bd
    INNER JOIN PRJ_BASELINES b ON bd.BASELINE_ID = b.ID
    INNER JOIN PRTASK t ON bd.OBJECT_ID = t.PRID
    INNER JOIN INV_INVESTMENTS task_project ON t.PRPROJECTID = task_project.ID
    INNER JOIN INV_INVESTMENTS baseline_project ON b.PROJECT_ID = baseline_project.ID
WHERE
    bd.OBJECT_TYPE = 'TASK'
    AND b.PROJECT_ID != t.PRPROJECTID
ORDER BY
    t.PRPROJECTID,
    b.PROJECT_ID,
    bd.OBJECT_ID;

Resolution

• Execute the query in cause section 
• Pick up the Baseline ID and navigate to Classic UX --> Properties --> Baseline and replace the Baseline ID in the browser UI example https://nu#action:projmgr.baselineRevisionList&id=11102977
• From the query check the baseline Name and update the baseline by Actions --> Update Baseline, this will run the Job "Update Earned Value Totals" job and fix the baseline
• Repeat the steps for all the impacted projects and upon fixing the data no errors like Load Data warehouse failure or duplicate data in UI will be seen.