When creating an External Dependencies, the dependency results in failure and displays error: This relationship cannot be created as it creates a recursive relationship - Support and Troubleshooting

When creating an External Dependencies, the dependency results in failure and displays error: This relationship cannot be created as it creates a recursive relationship 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 Navigate to planned_task_rel_planned_task.list 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