Project Tasks Duplicated

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A project suddenly started to show duplicated tasks.

Environment

Release : 16.0.2

 

Resolution

To fix the issue, delete the records from the following tables:

1. Backup table: prj_baseline_details 

2. Obtain list of specific tasks and baseslines :

select * from prj_baseline_details where object_type = 'TASK'
and object_id in (select prid from prtask where prprojectid = 5xxxxxx)

-- the 5xxxxxx is the internal ID for the bad project

The duplicates should be seen with the correct baseline and the bad baseline.

3. Run delete statement:

delete from prj_baseline_details where baseline_id = <baseline_id_of_wrong_baseline>
and object_type = 'TASK'
and object_id in  (select prid from prtask where prprojectid = 5xxxxxx);

commit;