A project suddenly started to show duplicated tasks.
Release : 16.0.2
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;