Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

(1) ShareShare
ReportReport
Posted on by 98

Dynamics GP 2018 - Web Client

On Sales All-In-One Viewer (coming from Transaction by Customer), if you uncheck the document, and re-check it, you get:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

*This post is locked for comments

  • bnschulz Profile Picture
    15 on at
    RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

    Mariano

    Thanks for your post. It is happening in the remote desktop client. My user is accessing GP through a terminal server. I honestly did not catch that Daniel's original issue was in the web client.

    Another difference is that we are getting the issue when we check the document the first time, not just when we uncheck and recheck the document. It is also intermittent, with some documents not resulting in an error and others resulting in the error message. In one case, it is every document related to a particular customer, with another customer, one document gets the error, other documents do not.

    I just thought anything Daniel found may be relevant to my case. Any thoughts then?

  • Mariano Gomez Profile Picture
    26,225 on at
    RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

    Is this problem web client specific? Do you get the same error when running in Desktop mode?

  • bnschulz Profile Picture
    15 on at
    RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

    Daniel

    I am encountering the same error. Did you find a solution for this? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans