The Project Hierarchy Tab spins and eventually shows a popup with a system error message on a PostgreSQL environment.
STEPS TO REPRODUCE:
Expected Results: The page returns as expected with the list of children in the view.
Actual Results: Depending on the number of children and the number of overall investments, it just spins.
Sometimes it will cause the popup system error message to show up and eventually you may experience a 'service unavailable' message for a few minutes while the system restarts automatically due to an out of memory issue caused by this action.
PostgresSQL /GCP Clarity SaaS Environments
This happens when the Investment Rollup object has a custom attribute configured on the Financial Rollup (Basic) page.
This issue is under review with Sustaining Engineering for a fix
Workaround: Remove all custom attributes from the view by restoring the view to the system default.
Doing this will ensure the attribute is removed from the code generation for the page display.
See also: 198389 - Slow Performance in Clarity - Best Practices / List of Known issues