Tasks invisible in Gantt Chart Due to Unique Constraint Error

Document ID : KB000092384
Last Modified Date : 11/06/2018
Show Technical Document Details
Issue:
When I launch the gantt chart for some projects, none of the project tasks are appearing in the chart (the chart is completely blank). When I try to filter for all tasks, I get a SQL error:

ORA-00001: unique constraint (schema.TEMP_WBS_GLOBAL_PK) violated
Resolution:
The gantt is unable to display tasks because there is more than one task with the same WBS sort value on this project. 

To reset the tasks WBS sort on the project tasks to where the sort value will be unique, there are three options: 

1. Open the affected project in OWB and without making any changes, save the project back to PPM. 
2. Open the affected project in MSP and without making any changes, save the project back to PPM. 
3. Xog the affected project out ,and without making any changes, xog it back in to PPM. 

The tasks will now show on the PPM gantt as expected. 
Additional Information:
KB000029082: Blank Gantt / Missing Tasks for a project in PPM