Notifications

7 views

Description

When creating external Project dependencies, the dependencies do not complete and result in annotation errors stating: This relationship cannot be created as it creates a recursive relationship

Release or Environment

London+

Cause

Invalid entries in planned_task_rel_planned_task table (where Successor = empty) on existing Project tasks or on a Project, in general, may cause this issue. To ensure Project hygiene, these type of Planned Task relationship records should be removed where possible. Note: This should always be tested on a sub-production when possible (or clone down to a sub-prod to test first)

Resolution

  1. Navigate to planned_task_rel_planned_task.list
  2. Filter for: parent_top_task.numberSTARTSWITH(parent-project#1-here) AND external=true
    3. Delete the records where Successor = EMPTY
    4. Filter for: parent_top_task.numberSTARTSWITH(parent-project#2-here) AND external=true
    5. Delete the records where Successor = EMPTY

Article Information

Last Updated:2020-07-20 06:50:10
Published:2020-07-20
Pasted image.png