Task Timeline view / Gantt not showing tasks "ERROR: duplicate key value violates unique constraint "temp_wbs_global_session_u1"

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Tasks are not showing in Classic Gantt or the Modern User Experience UX Timeline view. This may be noticed for one project. The tasks only show in the New UX grid or board view. They do NOT show up in the timeline view. 

When trying to move tasks in the Gantt the below error is generated. You may instead notice the Gannt is blank, and when filtering in the Gantt, the below error is generated. 

ERROR: duplicate key value violates unique constraint "temp_wbs_global_session_u1" Detail: Key (taskid)=(5152381) already exists. Executed: insert into TEMP_WBS_GLOBAL_SESSION( taskid, projectid, wbssequence, wbslevel, origwbslevel,origwbssequence, par_seq, nnb_seq, origpartask, orignnbtask ) ( SELECT task.prid, task.prprojectid, task.prwbssequence, task.prwbslevel, task.prwbslevel, task.prwbssequence, task.wbs_parseq, task.wbs_nnbseq , PARENTTASK.PRID, NNBTASK.PRID FROM PRTASK TASK LEFT OUTER JOIN PRTASK PARENTTASK ON PARENTTASK.PRWBSSEQUENCE = TASK.WBS_PARSEQ AND PARENTTASK.PRPROJECTID = TASK.PRPROJECTID LEFT OUTER JOIN PRTASK NNBTASK ON NNBTASK.PRWBSSEQUENCE = TASK.WBS_NNBSEQ AND NNBTASK.PRPROJECTID = TASK.PRPROJECTID WHERE TASK.PRPROJECTID = ? ) Derived from statement: insert into @temporary@( taskid, projectid, wbssequence, wbslevel, origwbslevel,origwbssequence, par_seq, nnb_seq, origpartask, orignnbtask ) ( SELECT task.prid, task.prprojectid, task.prwbssequence, task.prwbslevel, task.prwbslevel, task.prwbssequence, task.wbs_parseq, task.wbs_nnbseq , PARENTTASK.PRID, NNBTASK.PRID FROM PRTASK TASK LEFT OUTER JOIN PRTASK PARENTTASK ON PARENTTASK.PRWBSSEQUENCE = TASK.WBS_PARSEQ AND PARENTTASK.PRPROJECTID = TASK.PRPROJECTID LEFT OUTER JOIN PRTASK NNBTASK ON NNBTASK.PRWBSSEQUENCE = TASK.WBS_NNBSEQ AND NNBTASK.PRPROJECTID = TASK.PRPROJECTID WHERE TASK.PRPROJECTID = ? ) Referenced by: Using input: {@temporary@=TEMP_WBS_GLOBAL_SESSION, projectId=5016161} Using dynamic SQL: tag: @temporary@ SQL:TEMP_WBS_GLOBAL_SESSION".

Environment

Release : All Supported

 

Resolution

There are three options to fix the issue below:

Table of Contents

• Using OWB
• Using MSP
• Using XOG

Important: It's not supported to switch scheduler formats for a project (From OWB to MSP or vice versus, so make sure the project is exported in the same scheduler type if it was previously saved back from OWB or MSP)

Using OWB

1. Open the affected project in Open Workbench (OWB
2. Without making any changes, save the project back to Clarity

Using MSP

1. Open the affected project in Microsoft Project (MSP)
2. Without making any changes, save the project back to Clarity

Using XOG

1. XOG the affected project out
2. Without making any changes, xog it back into Clarity

To move an impacted task:

1. Open the project in OWB
2. Save and close OWB
3. Open the Gantt
4. Insert the WBS Sort column
5. Expand All tasks
6. Find the task and move it.

Using Stored Procedure

Have DBA team run the stored procedure called prj_wbs_update_sp(with_project_id_having_issue) Note: SaaS Customer can reach out to Broadcom Support