A stack overflow occurred in the server while compiling the query

Question

A stack overflow occurred in the server while compiling the query

Van Sever Wouter

SSC Enthusiast

Points: 137
More actions
December 18, 2006 at 1:42 am

#92055

Hello,
When executing a number of queries in batch SQL 2005 throws the following exception:
Msg 565, Level 18, State 1, Procedure proc_calcul, Line 3258
A stack overflow occurred in the server while compiling the query. Please simplify the query.
This occurs when executing a stored procedure of more than 3000 lines. A solution is to chop the stored procedure. Is it possible to write stored procedures of more than 3000 lines?

Viewing 5 posts - 1 through 4 (of 4 total)

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

ijaz SSCommitted Points: 1912 More actions · Answer 1

Hi,

Yeh, it is not the matter of length of stored procedure. It is the problem with the query. You should need to check the specific line mentioned in the error and diagonose the problem. It may be due to missing some clause in your query...

cheers

Van Sever Wouter SSC Enthusiast Points: 137 More actions · Answer 2

We also use with encryption. When we remove the with encryption the problem is also resolved. But we are not allowed to remove with encryption.

MohammedU SSCoach Points: 19644 More actions · Answer 3

Is parallalism enabled? If it is try the same after disabling the parallalism using MAXDOP option..

You may need to call PSS...

Are any stack dump files in sql error logs?

MohammedU
Microsoft SQL Server MVP

Anders Pedersen SSChampion Points: 11410 More actions · Answer 4

Most likely not the answer you are looking for. But at least one other person has run into the problem it seems.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=526047&SiteID=1