Solved

nesting level exceeded (limit 32)

  • 13 March 2019
  • 2 replies
  • 68 views

Userlevel 2
Badge +2
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?
icon

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

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.
View original

2 replies

Userlevel 5
Badge +2
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 2
Badge +2
It was indeed a problem with the reference. Thanks for the help.

Reply