Skip to main content

Unable to view company organisational tree - 'Failed to load tree data' error

What to do if you get the error message: Failed to display the screen The statement terminated. The maximum recursion 10 has been exhausted before statement completion .....

Written by Terence Cassidy
Updated this week

The full error message:
Failed to display the screen
The statement terminated. The maximum recursion 10 has been exhausted before statement completion
Details : Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
Organisational chart error.

This would be caused by the same company being a parent and a child so it creates a loop that SQL identifies and populates the error.

A circular reference that causes this error needs to be resolved by the support team - please contact us via the MyAccess portal and reference the title of this article and provide details of which organisation was being looked at.

Did this answer your question?