Microsoft KB Archive/317089

= BUG: Assertion Occurs When You Try to Run a Query That Uses a Parallel Plan =

Article ID: 317089

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Service Pack 3
 * Microsoft SQL Server 7.0 Service Pack 4

-



This article was previously published under Q317089



BUG #: 102268 (SQLBUG_70)



SYMPTOMS
When you run a SELECT query that uses a parallel plan in SQL Server 7.0 Service Pack 3 or SQL Server 7.0 Service Pack 4, the query may fail with the following assertion:

Server: Msg 3624, Level 20, State 1, Line 1

Location: port.cpp:1348

Expression: hr == S_OK

SPID: 7

Process ID: 105

Connection Broken

The assertion occurs if:


 * The query has multiple joins. -and-


 * The query has aggregate functions in the SELECT clause.

You will see the following stack dump in the SQL Server error log when you experience this problem:

SQL Server 7.0 SP3 Stack Dump
-- Short Stack Dump 0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b) 0x0078a1d0 Module(sqlservr+38a1d0) (utassert_fail+1a0) 0x0066dedb Module(sqlservr+26dedb) (CXPipe::NewRow+aa) 0x0066a2e0 Module(sqlservr+26a2e0) (CQScanXProducer::Open+7f) 0x00669f3f Module(sqlservr+269f3f) (FnProducerThread+1e3) 0x004ad883 Module(sqlservr+ad883) (subproc_main+f4) 0x41092a15 Module(ums+2a15) (ProcessWorkRequests+ed) 0x410932cb Module(ums+32cb) (ThreadStartRoutine+139) 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce) 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 2002-01-24 18:21:51.07 kernel SQL Server Assertion: File: , line=1348 Failed Assertion = 'hr == S_OK'. --



WORKAROUND
To work around this problem you can either:
 * Use the OPTION (MAXDOP 1) hint in the SELECT query. -or-


 * Set the max degree of parallelism configuration option to 1.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.