FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation

Article translations Article translations
Article ID: 318053 - View products that this article applies to.
This article was previously published under Q318053
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 101588 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

If you try to execute a complex query that has several joins and an execution plan cost of several hundred seconds, it may result in the following floating operation exception that is not valid:
Error: 0, Severity: 19, State: 0
Process %p generated fatal exception c0000090 EXCEPTION_FLT_INVALID_OPERATION. SQL Server is terminating this process.
This problem occurs during query compilation so it is possible to receive the message if you try to view the execution plan of the complex query.

When you experience this problem, you see the following stack dump in the SQL Server error log file:

SQL Server 7.0 Service Pack 3 Stack Dump

   Short Stack Dump 
   -------------------------------------------------------------------------
   0x7800256d Module(MSVCRT+256d) (ftol+1c) 
   0x00474138 Module(sqlservr+74138) (CTaskContext::SetTaskLimit+e6) 
   0x004730f2 Module(sqlservr+730f2) (CTask_OptInputs::Perform+7be) 
   0x004702d7 Module(sqlservr+702d7) (CMemo::ExecuteTasks+144) 
   0x00470023 Module(sqlservr+70023) (CMemo::OptimizeQuery+480) 
   0x0046daf1 Module(sqlservr+6daf1) (COptContext::PexprSearchPlan+35f) 
   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) 
   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) 
   0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 
   0x77f04ef0 Module(KERNEL32+4ef0) (lstrcmpiW+be) 
   -------------------------------------------------------------------------
				

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 7.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
301511 INF: How to Obtain the Latest SQL Server 7.0 Service Pack


NOTE: Because of file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.

Release Date: May 25, 2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft SQL Server 7.0 Service Pack 4.

Properties

Article ID: 318053 - Last Review: October 24, 2013 - Revision: 2.4
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbdownload kbbug kbfix kbsqlserv700presp4fix KB318053

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com