Skip to main content
Answer

nesting level exceeded (limit 32)

  • March 13, 2019
  • 2 replies
  • 490 views

Hugo Nienhuis
Superhero
Forum|alt.badge.img+12
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

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.
This topic has been closed for replies.

2 replies

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • Answer
  • March 14, 2019
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.

Hugo Nienhuis
Superhero
Forum|alt.badge.img+12
  • Author
  • Superhero
  • March 14, 2019
It was indeed a problem with the reference. Thanks for the help.