Post reply

Intermittent "nesting level exceeded" error

  • January 18, 2021 at 3:37 pm

    #3834641

    We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)" error and I was just wondering if the circumstances rang a bell with anybody. I'm certainly not expecting any form of in-depth investigation - that's my job.

    Here are the details:

    1. We continually run some automated tests. These call SPs etc. The database has triggers on tables.
    2. These are run on new restores of the same backup file.
    3. Restores are made to 2012, 2014, 2016, 2017 and 2019 instances on a number of different servers (i.e. we are running 2012 on several servers, 2014 on several servers, etc.)
    4. As of about a month and a half ago, we have had occasional instances of the nesting error.

      1. These have only been on 2012 instances - none on 2014, 2016, 2017 or 2019.
      2. They have only been on two particular 2012 instances - but not always on these two instances.
      3. We have five other 2012 instances where it has never happened.

    5. The error is reported in a stored procedure at a line where records are inserted in to a particular table.

      1. The table has a trigger. All that trigger does (apart from read operations) is write to a different table.
      2. That other table has a trigger, but no write operations, other than to itself.

    What's perplexing us is the fact that it's an intermittent failure when there have been no code changes.

    Does this ring a bell with anybody? i.e. mysterious "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)" errors on a 2012 instance?

    Thanks.

  • January 19, 2021 at 4:10 pm

    #3835102

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply