Microsoft KB Archive/318053

= FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation =

Article ID: 318053

Article Last Modified on 8/5/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q318053



BUG #: 101588 (SQLBUG_70)



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: The following hotfix was created prior to Microsoft SQL Server 7.0 Service Pack 4.

The following files are available for download from the Microsoft Download Center:

Intel (x86): Download Intel SQL Server 7.0 patch (s70996i.exe) now

Alpha: Download Alpha SQL Server 7.0 patch (s70996a.exe) now

The S70996i.exe (Intel x86) file contains the following files:   Date           Size             File name --  23-May-2001    5,054,736 bytes  Sqlservr.exe 14-Jan-2001   586,000 bytes    Sqlsort.dll The S70996a.exe (Alpha) file contains the following files:

  Date           Size              File name --  23-May-2001    11,664,656 bytes  Sqlservr.exe 14-Jan-2001   593,169 bytes     Sqlsort.dll Release Date: 25-May-2001

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.

Keywords: kbdownload kbbug kbfix kbsqlserv700presp4fix KB318053

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.