nesting level exceeded (limit 32)

  • 13 March 2019
  • 2 replies

Userlevel 3
Badge +11
I want to set some role rights on a specific table but I keep getting this error:
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

What is the cause of this error? Or, where do we exceed a limit?

Best answer by Anne Buit 14 March 2019, 08:43

View original

2 replies

Userlevel 7
Badge +5
Hi Hugo,

The cause of this might very well be a circular look-up reference. Check out the look-up table and look_up column for dagboek_id in the table dagboek. If there is a look-up configured, keep following down the chain. If you end up going in circles, you've found the problem.

Feel free to create a ticket for this issue. An error like this should not occur. There is a good chance this problem is resolved in the upcoming release but we'd like to check it out anyway.
Userlevel 3
Badge +11
It was indeed a problem with the reference. Thanks for the help.