Help with error 3624.

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: adan sanchez (adan.sanchez_at_kraft.com)
Date: 07/27/04 

Date: Mon, 26 Jul 2004 18:10:12 -0700

I need help for the follow error, that i get when i make a
select in a database.

Error: 3624, Severity: 20, State: 1.
SQL Server Assertion: File: <statutil.c>, line=1845
Failed Assertion = 'resultSize == blobSize'.

The dump is somethin like this.
=========================================

Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 28, PSS = 0x229171a8, EC = 0x22917358
Stack Dump being sent to d:\MSSQL7\log\SQL00021.dmp

===========================================================
==========
       BugCheck
Dump
    
===========================================================
==========
                                                           
                    
This file is generated by Microsoft SQL Server
1792.961
upon detection of fatal unexpected error. Please return
this file,
the query or program that produced the bugcheck, the
database and
the error log, and any other pertinent information with a
Service Request.
                                                           
                    
Computer type is AT/AT
COMPATIBLE.
Current local time is Mon Jul 26 17:03:12
2004
4 Intel x86 level 6, 701 Mhz processor
(s).
Windows NT 5.0 Build 2195 CSD Service Pack
4.
                          

Memory
------
MemoryLoad = 82% TotalPhys = 2559 MB
AvailPhys = 457 MB
TotalPageFile = 4095 MB
                                                     
Dump thread - spid = 28, PSS = 0x229171a8, EC =
0x22917358
Stack Dump being sent to d:\MSSQL7
\log\SQL00021.dmp
***********************************************************
********************
*
                    
* BEGIN STACK
DUMP:
      
* 07/26/04 17:03:12 spid
28
*
                    
* Input Buffer 52 bytes -
                                                      
* S E L E C T * F R O M E I M _ A C C O U N T
2
*
                    
***********************************************************
********************
-----------------------------------------------------------
--------------------
Short Stack
Dump
        
0x77f94956 Module(ntdll+14956)
(RtlUpcaseUnicodeToCustomCPN+66)
0x0078a1d0 Module(sqlservr+38a1d0)
(utassert_fail+1a0)
0x005bb884 Module(sqlservr+1bb884)
(StatMan::Init+13a)
0x004f0788 Module(sqlservr+f0788)
(CTableMetadata::LoadStats+55)
0x00445e21 Module(sqlservr+45e21)
(CTableMetadata::LoadIndex+597)
0x00445121 Module(sqlservr+45121)
(CTableMetadata::GatherIndexes+2ce)
0x004449b0 Module(sqlservr+449b0)
(CTableMetadata::LoadMetadata+16b)
0x0044d5b2 Module(sqlservr+4d5b2)
(CCvtTree::LoadAllMetadata+36)
0x0044b69b Module(sqlservr+4b69b)
(CCvtTree::PqryFromTree+7b8)
0x0044b3be Module(sqlservr+4b3be)
(BuildQueryFromTree+61)
0x0044b25d Module(sqlservr+4b25d)
(CStmtQuery::InitQuery+c9)
0x004f7acc Module(sqlservr+f7acc)
(CStmtSelect::Init+6d)
0x004383ab Module(sqlservr+383ab)
(CCompPlan::FCompileStep+772)
0x0043d00f Module(sqlservr+3d00f)
(CProchdr::FCompile+5d9)
0x0040ec53 Module(sqlservr+ec53)
(CSQLSource::FTransform+234)
0x00456463 Module(sqlservr+56463)
(CSQLStrings::FTransform+159)
0x00458304 Module(sqlservr+58304)
(CSQLStrings::Compile+3f)
0x004581f8 Module(sqlservr+581f8)
(CStmtPrepQuery::CStmtPrepQuery+2a2)
0x004380a7 Module(sqlservr+380a7)
(CCompPlan::FCompileStep+111)
0x0043d00f Module(sqlservr+3d00f)
(CProchdr::FCompile+5d9)
0x0040ec53 Module(sqlservr+ec53)
(CSQLSource::FTransform+234)
0x00456463 Module(sqlservr+56463)
(CSQLStrings::FTransform+159)
0x0040e7b9 Module(sqlservr+e7b9)
(CSQLSource::Execute+11d)
0x00456187 Module(sqlservr+56187)
(language_exec+39c)
0x41061253 Module(opends60+1253)
(execute_event+659)
0x4106144e Module(opends60+144e)
(process_commands+f3)
0x41092a15 Module(ums+2a15)
(ProcessWorkRequests+ed)
0x410932cb Module(ums+32cb)
(ThreadStartRoutine+139)
0x78008454 Module(MSVCRT+8454)
(_unDNameEx+2087)
0x7c57438b Module(KERNEL32+438b)

Relevant Pages

  • Error 3624
    ... database, somebady can help me. ... SQL Server Assertion: File:, ... Stack Dump being sent to d:\MSSQL7\log\SQL00021.dmp ... This file is generated by Microsoft SQL Server ...
    (microsoft.public.sqlserver.odbc)
  • anyone can give solution for this problem
    ... SQL Server is terminating this ... BEGIN STACK DUMP: ... Access Violation occurred reading address ...
    (microsoft.public.sqlserver.mseq)
  • Re: MSDE startup problem
    ... Seems like SQL Server craps out when trying to recover the model database. ... > * BEGIN STACK DUMP: ... SegSs: 000001A7: ...
    (microsoft.public.sqlserver.server)
  • MSDE startup problem
    ... 2004-10-20 15:27:11.88 server Logging SQL Server messages in file 'C:\PROGRAM FILES\Microsoft SQL ... 2004-10-20 15:27:11.90 server SQL Server is starting at priority class 'normal'. ... BEGIN STACK DUMP: ... SegSs: 000001A7: ...
    (microsoft.public.sqlserver.server)
  • Re: Fehlermeldung - was tun?
    ... > ob sich der Fehler bereits behoben wurde und ggf. ... SqlDumpExceptionHandler: Prozess 102 erzeugte eine schwere Ausnahmebedingung ... SQL Server beendet diesen Prozess.. ... BEGIN STACK DUMP: ...
    (microsoft.public.de.sqlserver)