Internal Error Server Stack Limit Has Been Reached
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Msg 8631 Internal error: Server stack limit has been reached on SQL Server 2012 from T-SQL script that runs on SQL Server 2008 R2 SQL Server > Transact-SQL Question 0 Sign in to vote I have an Script mostly that is generated by SSMS which works with-out issue on SQL Server 2008, https://support.microsoft.com/en-us/kb/2972996 but when I attempt to run it on a new fresh install of SQL Server 2012 I get an Msg 8631. Internal error: Server stack limit has been reached. Please look for potentially deep nesting in your query, and try to simplify it. The script itself doesn't seem to be all that https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5f1a4eae-6400-46e5-850e-425451de1346/msg-8631-internal-error-server-stack-limit-has-been-reached-on-sql-server-2012-from-tsql-script?forum=transactsql deep or nested. The script is large 2600 lines and when I remove the bulk of the 2600 lines, it does run on SQL Server 2012. I'm just really baffled why something that SQL Server generated with very few additions/changes AND that WORKS without issue in SQL Server 2008 R2 would suddenly be invalid in SQL Server 2012 I need to know why my script which is working great on our current SQL Server 2008 R2 servers suddenly fails and won't run on an new SQL Server 2012 server. This script is used to create 'bulk' Replications on a large number of DBs saving a tremendous amount of our time doing it the manual way. Below is an 'condensed' version of the script which fails. I have removed around 2550 lines of specific sp_addarticle statements which are mostly just copy and pasted from what SQL Management Studio 'scripted' for me went I
MembersRegister Login Server stack limit has been reached Everything about backing up to tape Post a reply 7 posts • Page 1 of 1 Server stack limit has been reached by macademy » Thu Feb 05, 2015 3:28 pm people like this post https://forums.veeam.com/tape-f29/server-stack-limit-has-been-reached-t26126.html When trying to browse the media pools I occasionally see this:We're running 8.0.0.917 and usually http://stackoverflow.com/questions/8583462/sql-error-expression-services-limit-reached keep it the application open on the server.Closing and relaunching the application clears the error and everything works fine, but after a while the error will occur again.Not a major issue, just annoying when it happens. macademy Enthusiast Posts: 27 Liked: 3 times Joined: Mon Nov 10, 2014 4:07 pm Full Name: Ian Cullen Private message Top Re: Server stack limit has internal error been reached by Dima P. » Thu Feb 05, 2015 11:11 pm people like this post Hello Ian,Could you please send this information to support team - it looks like media pool UI is misbehaving. Thank you in advance. Dima P. Veeam Software Posts: 4741 Liked: 329 times Joined: Mon Feb 04, 2013 2:07 pmLocation: SPb Full Name: Dmitry Popov Private message Top Re: Server stack limit has been reached by macademy » Mon Feb 09, 2015 internal error server 9:45 am people like this post I'll log this the next time it happens, thanks. macademy Enthusiast Posts: 27 Liked: 3 times Joined: Mon Nov 10, 2014 4:07 pm Full Name: Ian Cullen Private message Top Re: Server stack limit has been reached by Dima P. » Mon Feb 09, 2015 10:19 pm people like this post Ian,Once you get a confirmation - fire it directly to support and please do not forget to mention the case ID in this post. Thanks. Dima P. Veeam Software Posts: 4741 Liked: 329 times Joined: Mon Feb 04, 2013 2:07 pmLocation: SPb Full Name: Dmitry Popov Private message Top Re: Server stack limit has been reached by macademy » Thu Apr 16, 2015 1:22 pm people like this post I've opened a support case for this: 00880187 macademy Enthusiast Posts: 27 Liked: 3 times Joined: Mon Nov 10, 2014 4:07 pm Full Name: Ian Cullen Private message Top Re: Server stack limit has been reached by Dima P. » Mon Apr 20, 2015 6:07 pm people like this post Hello Ian,Any luck with suggested update 2? Dima P. Veeam Software Posts: 4741 Liked: 329 times Joined: Mon Feb 04, 2013 2:07 pmLocation: SPb Full Name: Dmitry Popov Private message Top Re: Server stack limit has been reached by ryderr » Thu May 21, 2015 12:30 pm 1 person likes this
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL: Error, Expression services limit reached? up vote 7 down vote favorite 3 "Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them." Has anyone seen this before and found a good workaround? I managed to get around this issue by splitting my SQL query into two parts essentially and writing the first SQL select query to a temp table and the second part, a new SQL select statement selects from the temporary table and uses alot of CROSS APPLY operator to Calculate cascading computed columns. This is an example of how the second part looks but I'm using alot more Cross Applys to produce new columns which are calculations: Select * from #tempTable cross apply ( select HmmLowestSalePrice = round(((OurSellingPrice + 1.5) / 0.95) - (CompetitorsLowestSalePrice) + 0.08, 2) ) as HmmLowestSalePrice cross apply ( select checkLowestSP = case when adjust = 'No Room' then 'No Room' when OrginalTestSalePrice >= CompetitorsLowestSalePrice then 'Minus' when OrginalTeslSalePrice < CompetitorsLowestSalePrice then 'Ok' end ) as checkLowestSP cross apply ( select AdjustFinalNewTestSP = case when FinalNewTestShipping < 0 Then NewTestSalePrice - (FinalNewTestShipping) when FinalNewTestShipping >= 0 Then NewTestSalePrice end ) as AdjustFinalNewTestSP cross apply ( select CheckFinalSalePriceWithWP = case when round(NewAdminSalePrice, 2) >= round(wholePrice, 2) then 'Ok' when round(NewAdminSalePrice, 2) < round(wholePrice, 2) then 'Check' end ) as Check