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
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.
KB000029082: Blank Gantt / Missing Tasks for a project in PPM