Tasks not displaying in Timeline view

Products

• Clarity PPM On Premise

Issue/Introduction

In Clarity Modern UX, users experience a problem in the Task Timeline page where all tasks do not get displayed except they filter for specific tasks. 

Step to Reproduce

1. Open Project with a number of tasks
2. Open the Task module on the Project
3. Click to open Timeline view


Expected: All Tasks to be displayed on the Timeline page

Actual: No Tasks are loaded on the page except you filter for specific ones. 

 

Environment

Component : Clarity MUX UI Usability

Cause

This behavior can come about when one of the tasks is an orphan record in PRJ_TASK_DEPENDENCY table.

Resolution

The following query was run SQL statement to determine if there are orphan tasks:

SELECT count(*)  FROM PRJ_TASK_DEPENDENCY ptd WHERE ptd.id IN (
SELECT td.ID FROM PRJ_TASK_DEPENDENCY td 
LEFT JOIN PRDEPENDENCY p ON td.PR_DEPENDENCY_ID  = p.PRID 
WHERE p.prid is NULL );

Check the column 'PARENT_TASK_ID' in the results generated from the query above to see if contains one of the internal ids of the tasks not getting displayed in the Timeline view.

This record must be removed. Contact Technical Support if assistance is required.