Duplicated Tasks on a project

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We have found a few projects where a task appears as duplicated. Observations on the clarity UI:

• The duplicated task in Gantt
• A global AG grid loading error on the task Grid view

What can be the cause of this?

Environment

16.2.3 and supported releases

Cause

A baseline reference for the task is invalid

Resolution

A possible reason for a task to appear as a duplicate can be related to the task holding an invalid baseline reference. Here are two possible scenarios around the same:

1. There are two projects: Project A with Task A and Project B with Task B 
    Both projects have a baseline.
    Project B baseline contains a reference to Project A Task A
    (A project baseline should only contain references to tasks on the same project. It should never reference a task on a different project)
2. A project that contains a task has two baselines
    At DB level both baselines are set as current.

Tables that you want to check at DB level:
PRTASK table PRID references
PRJ_BASELINES table against the PROJECT_ID references
PRJ_BASELINE_DETAILS tables against BASELINE_ID references. On this last table look at the OBJECT_ID value that refers to the PRID on the PRTASK table.

If you are unsure on how to look at this, please contact support