FIX: Exception Access Violation Encountered During Compile of Hash Match Team Plan

This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 236753 (shiloh_bugs)
During query compilation, SQL Server may encounter an exception access violation (AV) when the plan selection involves a complex Hash Match Team. The access violation will look similar to the following:
0056701F Module(sqlservr+0016701F) (CBndOutputs::RemapValrefs(class CRemapContext *,int)+0000000A)
00703A1C Module(sqlservr+00303A1C) (CXteHashMatch::CreateInputScan(class IMemObj *,class CVRTable...
004A8B35 Module(sqlservr+000A8B35) (CXteHashMatch::CreateBailoutPlan(class CRemapContext *,class ...
004A70B6 Module(sqlservr+000A70B6) (CXteHashMatch::IntermediateCompile...
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack


NOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.

The English version of this fix should have the following file attributes or later:
   File name     Platform   ----------------------   S80217i.exe   Intel				
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the above files may also contain additional files.
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
More information
The conditions required to encounter this situation occur rarely; it requires a significantly complex Hash Match Team query.

A key to this issue is that the exception is encountered during the compile phase. To determine whether you are encountering this issue, enable the 'set showplan_all on' option and execute the query. Because the error occurs during the compile phase, the exception is encountered before the showplan results are returned.

Article ID: 278698 - Last Review: 01/16/2015 21:00:38 - Revision: 4.0

  • Microsoft SQL Server 2000 Standard Edition
  • kbnosurvey kbarchive kbbug kbfix kbqfe kbsqlserv2000sp1fix KB278698