FIX: Fatal Exception "EXCEPTION_FLT_OVERFLOW" Occurs During Query Optimization (276303)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q276303
BUG #: 57435 (SQLBUG_70)

SYMPTOMS

Under certain circumstances, the following EXCEPTION_FLT_OVERFLOW error message may occur during the optimization of a complex query:
SqlDumpExceptionHandler: Process 9 generated fatal exception c0000091 EXCEPTION_FLT_OVERFLOW.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

MORE INFORMATION

The stack dump for this exception displays in the SQL Server error log as follows: 
Short Stack Dump
0x004b3e97 Module(sqlservr+b3e97) (CCardVector::operator*+21)
0x004b035e Module(sqlservr+b035e) (CalculateApply+8c)
0x00457684 Module(sqlservr+57684) (OptimizerUtil::CalculateSelectivity+302)
0x00457357 Module(sqlservr+57357) (CalcCard+29e)
0x0045724a Module(sqlservr+5724a) (GroupCardFromSel+dc)
0x00449f4b Module(sqlservr+49f4b) (ComputeGroupProperties+20)
0x004b025a Module(sqlservr+b025a) (CLogOp_Apply::DeriveGroupProperties+62)
0x00449c1d Module(sqlservr+49c1d) (COpArg::DeriveNormalizedGroupProperties+13)
0x004413b8 Module(sqlservr+413b8) (COptExpr::DeriveGroupProperties+5c)
0x0046f2fa Module(sqlservr+6f2fa) (COptContext::PexprTransformTopLevel+1c5)
0x0046ef9b Module(sqlservr+6ef9b) (COptContext::PexprNormalize+21)
0x0046f071 Module(sqlservr+6f071) (COptContext::PexprNormalize+9f)
0x0046f071 Module(sqlservr+6f071) (COptContext::PexprNormalize+9f)
0x0046f071 Module(sqlservr+6f071) (COptContext::PexprNormalize+9f)
0x0046f071 Module(sqlservr+6f071) (COptContext::PexprNormalize+9f)
0x0046f071 Module(sqlservr+6f071) (COptContext::PexprNormalize+9f)
0x0046dd57 Module(sqlservr+6dd57) (CMemo::NormalizeQuery+173)
0x0046d9de Module(sqlservr+6d9de) (COptContext::PexprSearchPlan+ba)
0x0044b850 Module(sqlservr+4b850) (COptContext::PcxteOptimizeQuery+7ea)
0x0044afe4 Module(sqlservr+4afe4) (CQuery::Optimize+206)
0x0044ab70 Module(sqlservr+4ab70) (CQuery::Prepare+91)
0x00445f4b Module(sqlservr+45f4b) (CCvtTree::PqryFromTree+7eb)
0x00445c74 Module(sqlservr+45c74) (BuildQueryFromTree+60)
0x00445b13 Module(sqlservr+45b13) (CStmtQuery::InitQuery+c8)
0x0046aa97 Module(sqlservr+6aa97) (CStmtSelect::Init+6c)
0x0043676d Module(sqlservr+3676d) (CCompPlan::FCompileStep+771)
0x0043b503 Module(sqlservr+3b503) (CProchdr::FCompile+5d7)
0x00413dbd Module(sqlservr+13dbd) (CSQLSource::FTransform+233)
0x00480033 Module(sqlservr+80033) (CSQLStrings::FTransform+158)
0x00482161 Module(sqlservr+82161) (CSQLStrings::Compile+3e)
0x00482055 Module(sqlservr+82055) (CStmtPrepQuery::CStmtPrepQuery+2a1)
0x00436469 Module(sqlservr+36469) (CCompPlan::FCompileStep+110)
0x0043b503 Module(sqlservr+3b503) (CProchdr::FCompile+5d7)
0x00413dbd Module(sqlservr+13dbd) (CSQLSource::FTransform+233)
0x00480033 Module(sqlservr+80033) (CSQLStrings::FTransform+158)
0x00413923 Module(sqlservr+13923) (CSQLSource::Execute+11c)
0x0047fd57 Module(sqlservr+7fd57) (language_exec+396)
0x41061253 Module(opends60+1253) (execute_event+658)
0x410614a1 Module(opends60+14a1) (process_commands+f2)
0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec)
0x4109326b Module(ums+326b) (ThreadStartRoutine+138)
0x7800bea1 Module(MSVCRT+bea1) (beginthread+ce)
0x77e92ca8 Module(KERNEL32+12ca8) (CreateFileA+11b)
Modification Type:MajorLast Reviewed:3/14/2006
Keywords:kbBug kbfix KB276303
©2004 Microsoft Corporation. All rights reserved.