FIX: Fatal Exception "EXCEPTION_FLT_OVERFLOW" Occurs During Query Optimization

This article was previously published under Q276303
This article has been archived. It is offered "as is" and will no longer be updated.
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 Dump0x004b3e97 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)				
error message c0000091
Properties

Article ID: 276303 - Last Review: 10/26/2013 05:27:00 - Revision: 3.0

  • Microsoft SQL Server 7.0 Standard Edition
  • kbnosurvey kbarchive kbbug kbfix KB276303
Feedback