fixed ISSUE-50697: Prevent db transaction from being kept open if cycle is detected in hierarchy

Now when a cycle is detected in a hierarchy, an exception is thrown to show a proper message to the user