SQLImage.dll Dump ???

[JayKusch]

Anyone seen this ... or better yet ... have a solution?


this process. . 2003-10-16 15:52:51.54 spid12 Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to e:\MSSQL7\log\SQL00224.dmp 2002-10-15 15:53:08.53 spid12
Error: 0, Severity: 19, State: 0 2003-10-15 15:53:08.53 spid12
SqlDumpExceptionHandler: Process 12 generated fatal exception c0000005

EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. .


I have read that replacing the sqlsort.dll in the mssql7\bin dir may correct it. Have not yet been able to run DBCC CheckDB nor CheckTable. Will be able to accomplish that task during tomorrow mornings downtime.

Thanks

J. Kusch

 

[JamesLean]

Not seen this before myself but I have found this article at MS which may shed some light:

http://support.microsoft.com/defaul...port/kb/articles/q248/7/49.asp&NoWebContent=1

--James

 

[JayKusch]

Thanks James ... say that article too. This article,

http://support.microsoft.com/default.aspx?scid=/servicedesks/bin/kbsearch.asp?Article=269884

is the one I am focusing on right now. I can replicate the stack dump by issuing the convert statment against the NW DB as stated.

When the server in California hits its scheduled downtime, in about an hour, we are going to reinstall SP3. This is an SS7 server by the way.

What concerns me is that currently, the sqlsort.dll that should reside in the mssql7\bin dir is not present.

Will update the forum once we complete our reinstall.

Thanks

J. Kusch

 

[JamesLean]

Certainly looks like that's your problem. FYI, I can also recreate it on both my SQL 7 servers (both SP4).

That article just confirms that it's a problem with SQL 7 - it doesn't actually give you any info on how to fix it. I assume that means that there is no fix (you'll probably find reinstalling SP 3 won't help).

I would try and find out what code is issuing the malformed query and fix it. Simple Profiler trace should do that easily.

--James

 

[JayKusch]

Here is the kicker ... We have identified the rouge SP and it DOES NOT have any Convert or Cast functions being used. The only "high end" functions are a couple of Sums and a Grouped By which are no big deal.

I plan to break the SP down in parts and see if I can identify which subsection of code is the culprit and then maybe I can locate the trouble spot.

Will advise and thanks for the info ...

Thanks

J. Kusch

 

[JamesLean]

Do let us know what the outcome is - I'd be interested to see if it's a SQL Server bug or just a problem specific to your installation.

--James