Footer rows to skip: error

Showing posts with label error. Show all posts

Thursday, March 29, 2012

Field names must be CLS-compliant identifiers.

While creating a report using 'CreateReport' API method for Report Services
2000, I am getting the following error.
//
A field in the data set â'MainDataSetâ' has the name â'Count Borrower Nameâ'.
Field names must be CLS-compliant identifiers.
--> A field in the data set â'MainDataSetâ' has the name â'Count Borrower Nameâ'.
Field names must be CLS-compliant identifiers.
//
The error occurs due to the space on the computed field name. If I
concatinate the words with '_' (for example) then I do not get an error.
I would like know how can I create report that has field with the name like
â'Count Borrower Nameâ', etc?
Thanks.
-SueThe CLS-compliance rule for field names comes from the fact that in vast
majority of scenarios fields in expressions are referenced using the
following syntax: =Fields!FieldName.Value
If a field name is not CLS-compliant (for example "Field Name") then the
syntax above would result in VB compilation error: =Fields!Field Name.Value
is not a valid VB snippet.
RDL does not support field names with spaces. Although if you data source
returns non-CLS-compliant name you designer will build
<Field name="non_CLS_Compliant_Name">
<DataField>non CLS Compliant Name</DataField>
</Field>
"Sue" <Sue@.discussions.microsoft.com> wrote in message
news:E82BA30A-FD8B-48E9-BF24-28EA9408301D@.microsoft.com...
> While creating a report using 'CreateReport' API method for Report
Services
> 2000, I am getting the following error.
> //
> A field in the data set 'MainDataSet' has the name 'Count Borrower Name'.
> Field names must be CLS-compliant identifiers.
> --> A field in the data set 'MainDataSet' has the name 'Count Borrower
Name'.
> Field names must be CLS-compliant identifiers.
> //
>
> The error occurs due to the space on the computed field name. If I
> concatinate the words with '_' (for example) then I do not get an error.
> I would like know how can I create report that has field with the name
like
> 'Count Borrower Name', etc?
> Thanks.
> -Sue
>

Tuesday, March 27, 2012

Field Error

I am getting the following error:
The group expression for the list â'Titleâ' refers to the field â'Title.
Report item expressions can only refer to fields within the current data set
scope or, if inside an aggregate, the specified data set scope.
When I reference the stored procedure in my report, I do not get a field
list. I believe it is because I am trying to build a report that references a
stored procedure using dynamic sql, and I am told that it has to be dynamic
sql by the DBA.
If I am correct in this, question I have is how do I build a report
referencing dynamic sql without getting this error? The stored procedure
works and returns a resultset.You need to manually add the fields to your field list. You can do this by
right clicking with your mouse over the field list.
"Wannabe" wrote:
> I am getting the following error:
> The group expression for the list â'Titleâ' refers to the field â'Title.
> Report item expressions can only refer to fields within the current data set
> scope or, if inside an aggregate, the specified data set scope.
> When I reference the stored procedure in my report, I do not get a field
> list. I believe it is because I am trying to build a report that references a
> stored procedure using dynamic sql, and I am told that it has to be dynamic
> sql by the DBA.
> If I am correct in this, question I have is how do I build a report
> referencing dynamic sql without getting this error? The stored procedure
> works and returns a resultset.
>|||That was easy!!! Thanks a lot...I never would have found that.
"Mike Collins" wrote:
> You need to manually add the fields to your field list. You can do this by
> right clicking with your mouse over the field list.
> "Wannabe" wrote:
> > I am getting the following error:
> >
> > The group expression for the list â'Titleâ' refers to the field â'Title.
> > Report item expressions can only refer to fields within the current data set
> > scope or, if inside an aggregate, the specified data set scope.
> >
> > When I reference the stored procedure in my report, I do not get a field
> > list. I believe it is because I am trying to build a report that references a
> > stored procedure using dynamic sql, and I am told that it has to be dynamic
> > sql by the DBA.
> >
> > If I am correct in this, question I have is how do I build a report
> > referencing dynamic sql without getting this error? The stored procedure
> > works and returns a resultset.
> >

Monday, March 26, 2012

Fetch within a fetch

Is it possible to have fetch within a fetch? I am getting this error message "A cursor with the name 'crImgGrp' does not exist." So i separate the process into two stored procedures?

CREATE PROCEDURE TrigSendPreNewIMAlertP2
@.REID int

Declare @.RRID int
Declare @.ITID int

Declare @.intIMEmail varchar(300)

Declare crReqRec cursor for
select RRID from RequestRecords where REID = @.REID and RRSTatus = 'IA' and APID is not null
open crReqRec
fetch next from crReqRec
into
@.RRID

Declare crImpGrp cursor for
select ITID from RequestRecords where RRID = @.RRID
open crImpGrp
fetch next from crImgGrp
into
@.ITID
while @.@.fetch_status = 0

EXEC TrigSendNewIMAlertP2 @.ITID

FETCH NEXT FROM crImpGrp
into
@.ITID

close crImpGrp
deallocate crImpGrp

while @.@.fetch_status = 0

FETCH NEXT FROM crReqRec
into
@.RRID

close crReqRec
deallocate crReqRec
GO... I'd re-think a different solution than what you want to do.

fetch successful resultset after exception

Ok, here is the deal. In T-SQL, an error is handled depending on its severity. For example, a severity of 15 or less (or is it 10 or less? doesn't matter) will only raise a warning that can be caught through the message event. 16 or higher (or whatever) will cause an exception to be thrown on the .NET side, and 20 or higher causes the connection to be closed.

So far so good.

Now here's my issue: I have a stored procedure that does 2 queries (inside the same SP). Sometimes, the first query will succeed, while the second one will cause an error of severity 16. Again, in .NET that will throw an exception, making me unable to fetch the first resultset (which I require for logging purpose). If the error was, let say, severity 9, I could simply subscribe to the message event to get my error, yet still be able to get the first result set. But unfortunately life isn't perfect, and the error is indeed a severity 16.

Anyone know of a way to be able to get the first result set, even if the second query (within the same SP) completly fails?Why don't you wrap the two SQL statements in a transaction, so that if one fails, all attempted changes will be rolled back. You certainly wouldn't want something to work half-way--it should be an all or nothing deal. If you don't mind it working half-way, then perhaps the SQL should be put into separate calls.|||Well, I answered my own question: nothing is stopping me from accessing the data. If using a datareader, the exception isn't thrown until you move to the resultset that errored out. If using a dataset with multiple tables, the tables that succeeded are filled just fine as normal, and the ones that failed have 0 rows. Not the behavior I expected, but it did the trick.

As to why a non-atomic process is wrapped in a single stored procedure? Its because the SP was made for a relatively limited (in features) scheduling software, and it can only call one SP on the trigger. A bit silly, but I'm not the one who set that up originally, I'm just handling a migration. The requirement here was so that we could log what succeeded so we can give the log away to a supplier or some such.

Anyway, seems like ADO.NET handles that requirement just fine after all. I'm surprised, honestly.

Friday, March 23, 2012

Feedback on Merge Replication Error

dear all,
regarding the problem of not uploading the data from the
subscriber to the publisher though the merge agent is
successfult and the status is no data needed to be merged.
i checked the record in msmerge_contents , it doesn't
exist.
actually i checked with the table nick name and the
rowguid of the row i made modification in.
any help with that?
Thanks
Dalia,
does the trigger exist on the subscriber? If not then perhaps the exchange
type is incorrect.
Regards,
Paul Ibison

Wednesday, March 21, 2012

fcb::ZeroFile(): GetOverLappedResult() failed with error 27.

Hi,
I have a server that is running MSSQL2000 SP4 + 2159 hotfix. Whever I try to
expand a data file by 4 GB - it does not report any error. The windows
explorer shows the new size. But the enterpise manager and sp_helpdb show the
old size and there is an entry in the SQL error log that says..
fcb::ZeroFile(): GetOverLappedResult() failed with error 27.
Has any one come across this before? What is the solution?
Sounds like you have some serious issues with your disk. 27 is an OS error, "Cannot find requested
sector". Is the file compressed? If so, this isn't supported, and things like these are expected
(although I'm not sure whether this particular error message is expected). If not, I'd run a
comprehensive check at the file system/disk level.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:0AD05B12-0C6F-4A1E-9B73-C39BB1BDD360@.microsoft.com...
> Hi,
> I have a server that is running MSSQL2000 SP4 + 2159 hotfix. Whever I try to
> expand a data file by 4 GB - it does not report any error. The windows
> explorer shows the new size. But the enterpise manager and sp_helpdb show the
> old size and there is an entry in the SQL error log that says..
> fcb::ZeroFile(): GetOverLappedResult() failed with error 27.
> Has any one come across this before? What is the solution?

fcb::ZeroFile(): GetOverLappedResult() failed with error 27.

Hi,
I have a server that is running MSSQL2000 SP4 + 2159 hotfix. Whever I try to
expand a data file by 4 GB - it does not report any error. The windows
explorer shows the new size. But the enterpise manager and sp_helpdb show th
e
old size and there is an entry in the SQL error log that says..
fcb::ZeroFile(): GetOverLappedResult() failed with error 27.
Has any one come across this before? What is the solution?Sounds like you have some serious issues with your disk. 27 is an OS error,
"Cannot find requested
sector". Is the file compressed? If so, this isn't supported, and things lik
e these are expected
(although I'm not sure whether this particular error message is expected). I
f not, I'd run a
comprehensive check at the file system/disk level.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:0AD05B12-0C6F-4A1E-9B73-C39BB1BDD360@.microsoft.com...
> Hi,
> I have a server that is running MSSQL2000 SP4 + 2159 hotfix. Whever I try
to
> expand a data file by 4 GB - it does not report any error. The windows
> explorer shows the new size. But the enterpise manager and sp_helpdb show
the
> old size and there is an entry in the SQL error log that says..
> fcb::ZeroFile(): GetOverLappedResult() failed with error 27.
> Has any one come across this before? What is the solution?sql

fcb::ZeroFile(): GetOverLappedResult() failed with error 27.

Hi,
I have a server that is running MSSQL2000 SP4 + 2159 hotfix. Whever I try to
expand a data file by 4 GB - it does not report any error. The windows
explorer shows the new size. But the enterpise manager and sp_helpdb show the
old size and there is an entry in the SQL error log that says..
fcb::ZeroFile(): GetOverLappedResult() failed with error 27.
Has any one come across this before? What is the solution?Sounds like you have some serious issues with your disk. 27 is an OS error, "Cannot find requested
sector". Is the file compressed? If so, this isn't supported, and things like these are expected
(although I'm not sure whether this particular error message is expected). If not, I'd run a
comprehensive check at the file system/disk level.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:0AD05B12-0C6F-4A1E-9B73-C39BB1BDD360@.microsoft.com...
> Hi,
> I have a server that is running MSSQL2000 SP4 + 2159 hotfix. Whever I try to
> expand a data file by 4 GB - it does not report any error. The windows
> explorer shows the new size. But the enterpise manager and sp_helpdb show the
> old size and there is an entry in the SQL error log that says..
> fcb::ZeroFile(): GetOverLappedResult() failed with error 27.
> Has any one come across this before? What is the solution?

Fatal System Error

Whats happening:

Error#: 40002
Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement has
been terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,
Column4, Column5, Column6) VALUES
("","Value1","Value2","Value3","Value4","Value5")'

Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement has
been terminated.

Active Form: frmForm
Form Name:

--
GETID Stored Procedure:
--

CREATE PROCEDURE GETID @.strsql text AS

PRINT cast(@.strsql as varchar(4000))

EXEC(" "
+@.strsql + " select @.@.identity as id")

GO
--

Anyone know what could be causing it? The database has changed - the
frontend code hasn't, so it has to be a database problem. What
happened was a few tables became incorrect so we restored them from a
backup. Everything else seems to work, apart from adding a new record
to this table.
You can edit current records etc..just not add.

Thanks in advance,[posted and mailed, please reply in news]

(lbillson@.netexperts.co.uk) writes:
> Whats happening:
> Error#: 40002
> Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement has
> been terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,
> Column4, Column5, Column6) VALUES
> ("","Value1","Value2","Value3","Value4","Value5")'
> Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement has
> been terminated.
>...
> Anyone know what could be causing it? The database has changed - the
> frontend code hasn't, so it has to be a database problem. What
> happened was a few tables became incorrect so we restored them from a
> backup. Everything else seems to work, apart from adding a new record
> to this table.

It appears that one error message has been lost somewhere. "The statement
has been terminated" is an accompanying message to the real error message.

I don't know what sort of client code you are using, but it seems that
the error handling needs a review. When working with SQL Server it's
essential to get all error message. And particularly the first error
message.

As for what have happened, it seems that the definition of the table has
changed, so that the statement is no longer correct. May be there is one
more column which is not nullable. You could also be running into a
key violation. Or, since you had restored some tables from backup, maybe
you are inserting a non-valid foreign key.

Your best bet is probably to run the query from Query Analyzer.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Fatal Network Error 4014 when writing big BLOB chunks

Using the SqlClient provider I'm trying to write big datachunks of maybe 20 MB each to SQL server to store in BLOBs using blobColumn.Write(...) using .NET 2.0 dbcommand object calling a Stored procedure

CREATE PROCEDURE [dbo].[putBlobByPK]

(

@.id dKey

, @.value VARBINARY(MAX)

, @.offset bigint

, @.length bigint

, @.ModDttm dModDttm OUT

, @.ModUser dModUser OUT

, @.ModClient dModClient OUT

, @.ModAppl dModAppl OUT

)

....

When doing this I can do this exactly 3 times than the application hangs (for ever).

When looking in the SQL Server log, I find the following to errors:

Error: 4014, Severity: 20, Status: 2.

A fatal error occurred while reading the input stream from the network. The session will be terminated.

I don't get this error on the client! OK, the session died.

What may be the problem?

I write big chunks like this to avoid many writes as the data shall be replicated later using peer to peer replication. And the more writes used for writing the total BLOB the more huge becomes the transaction log of the subscriber database.

TIA

Hannoman

After rebooting all machines (client and server) this didn't happen any more. And the client has a problem with a deferred installation - when starting the test application MSI installer tries to install something but isn't successfull. It seems, that this causes the hanging of the client machine.sql

Fatal Exception in SQL Server

Hello,
We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
this error message in event viewer and at the same time the program that
access SQL Server crashes.
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Does anyone have any idea what it is please. Thanks
Andrew> We got a SQL Server (no SP) running on Win 2k SP4.
If this is SQL2000, apply SQL2000 sevice pack 4 + AWE memory hotfix first.
If this SQL2005, open a support case with Microsoft. But I'd strongly
suggest that you run SQL2005 on Windows 2003 SP1.
Linchi
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:%234ZSg%23cLGHA.3756@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
> this error message in event viewer and at the same time the program that
> access SQL Server crashes.
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> Does anyone have any idea what it is please. Thanks
> Andrew|||Thank you for your reply. I already applied SP4 still the same message.
Where can I obtain AWE hotfix please.
Andrew
Linchi Shea wrote:
>> We got a SQL Server (no SP) running on Win 2k SP4.
> If this is SQL2000, apply SQL2000 sevice pack 4 + AWE memory hotfix first.
> If this SQL2005, open a support case with Microsoft. But I'd strongly
> suggest that you run SQL2005 on Windows 2003 SP1.
> Linchi
> "Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
> news:%234ZSg%23cLGHA.3756@.TK2MSFTNGP10.phx.gbl...
>> Hello,
>> We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
>> this error message in event viewer and at the same time the program that
>> access SQL Server crashes.
>> Error: 0, Severity: 19, State: 0
>> SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>> Does anyone have any idea what it is please. Thanks
>> Andrew
>|||You can get the AWE fix here :
http://www.microsoft.com/downloads/details.aspx?FamilyId=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en
But you will need to log a case with Microsoft CSS , because the error you
posted is not sufficient enough , we need at least the stack output from the
AV , and if there was any mini dump created in the log folder during this
time...
So as linchi said please log a case with Microsoft CSS for speedy resolution
HTH
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:uVHDk9cMGHA.3264@.TK2MSFTNGP11.phx.gbl...
> Thank you for your reply. I already applied SP4 still the same message.
> Where can I obtain AWE hotfix please.
> Andrew
> Linchi Shea wrote:
>> We got a SQL Server (no SP) running on Win 2k SP4.
>> If this is SQL2000, apply SQL2000 sevice pack 4 + AWE memory hotfix
>> first. If this SQL2005, open a support case with Microsoft. But I'd
>> strongly suggest that you run SQL2005 on Windows 2003 SP1.
>> Linchi
>> "Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
>> news:%234ZSg%23cLGHA.3756@.TK2MSFTNGP10.phx.gbl...
>> Hello,
>> We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
>> this error message in event viewer and at the same time the program that
>> access SQL Server crashes.
>> Error: 0, Severity: 19, State: 0
>> SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>> Does anyone have any idea what it is please. Thanks
>> Andrew

Fatal exception error in MSSQL2005 SP1

The SQL server was terminated by exception acess violation at 10pm but before
that, I got some dump logs between 8pm to 10pm. Any idea? Thanks in advance
****************SQLDUMP.LOG**************
Memory
MemoryLoad = 90%
Total Physical = 2047 MB
Available Physical = 202 MB
Total Page File = 3947 MB
Available Page File = 2046 MB
Total Virtual = 2047 MB
Available Virtual = 93 MB
***Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\SQLDump0002.txt
SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
*
*******************************************************************************
*
* BEGIN STACK DUMP:
* 07/20/06 20:26:18 spid 70
*
*
* Exception Address = 7C8224B2 Module(ntdll+000224B2)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000003
* Input Buffer 510 bytes -
* select a.currencycode, a.glmasterno, a.loanrefno, a.customerid, a.contra
* cttype, a.NewLoanBaln, a.TtlAccrueInt, substring(b.duedate,5,2) + '/' +
* substring(b.duedate,3,2) + '/' + substring(b.duedate,1,2) as DueDate_Fox
* Pro, b.* from eximbills_drawfm00 a right join (select I.*, P.schedulep
* rincipal as MerchedPrincipal, P.penaltotalinterest as Ppenality from (se
* lect * from (Select *, case when left(duedate,2) > '78' then '19' + d
* uedate else '20' + duedate end as modi_duedate from eximbills_drawfpsf w
* here right(kpsfkey,1) = 'I') z where modi_duedate between '20060603' a
* nd '20060803' and payoutflag <> 'Y') I join (select scheduleprincipal
* , kpsfkey, penaltotalinterest from (Select *, case when left(duedate,
* 2) > '78' then '19' + duedate else '20' + duedate end as modi_duedate fr
* om eximbills_drawfpsf where right(kpsfkey,1) = 'P') x where modi_dueda
* te between '20060603' and '20060803' and payoutflag <> 'Y') P on le
* ft(I.kpsfkey,25) = left(P.kpsfkey,25)) b on rtrim(ltrim(a.loanrefno)) =
* substring(b.kpsfkey,1,12) where rtrim(ltrim(a.recordtype)) <> '009' or
* der by loanrefno, kpsfkey
****************SQLDUMPER_ERRORLOG**************
07/20/06 20:24:58, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges
() failed (00000514)
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4
supplied
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1744
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x02A03570
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr
= 0x00000000
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Dump is associated
with file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt
07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not
used
07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.mdmp
07/20/06 20:25:03, ACTION, sqlservr.exe, Watson Invoke: NoHi stephanie
Have you run this query successfully from query analyser? Have you run DBCC
CHECKDB and made sure that there are no hardware errors or other errors
reported in the event log?
You may want to look at re-writing the query. It is best not not use SELECT
* in production code as you will be selecting more than you are using. Post
DDL and sample data with the expected output from that data if you need help
re-writing this see http://www.aspfaq.com/etiquette.asp?id=5006
John
"stephanie" wrote:
> The SQL server was terminated by exception acess violation at 10pm but before
> that, I got some dump logs between 8pm to 10pm. Any idea? Thanks in advance
> ****************SQLDUMP.LOG**************
> Memory
> MemoryLoad = 90%
> Total Physical = 2047 MB
> Available Physical = 202 MB
> Total Page File = 3947 MB
> Available Page File = 2046 MB
> Total Virtual = 2047 MB
> Available Virtual = 93 MB
> ***Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\SQLDump0002.txt
> SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is
> terminating this process.
> *
> *******************************************************************************
> *
> * BEGIN STACK DUMP:
> * 07/20/06 20:26:18 spid 70
> *
> *
> * Exception Address = 7C8224B2 Module(ntdll+000224B2)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 00000003
> * Input Buffer 510 bytes -
> * select a.currencycode, a.glmasterno, a.loanrefno, a.customerid, a.contra
> * cttype, a.NewLoanBaln, a.TtlAccrueInt, substring(b.duedate,5,2) + '/' +
> * substring(b.duedate,3,2) + '/' + substring(b.duedate,1,2) as DueDate_Fox
> * Pro, b.* from eximbills_drawfm00 a right join (select I.*, P.schedulep
> * rincipal as MerchedPrincipal, P.penaltotalinterest as Ppenality from (se
> * lect * from (Select *, case when left(duedate,2) > '78' then '19' + d
> * uedate else '20' + duedate end as modi_duedate from eximbills_drawfpsf w
> * here right(kpsfkey,1) = 'I') z where modi_duedate between '20060603' a
> * nd '20060803' and payoutflag <> 'Y') I join (select scheduleprincipal
> * , kpsfkey, penaltotalinterest from (Select *, case when left(duedate,
> * 2) > '78' then '19' + duedate else '20' + duedate end as modi_duedate fr
> * om eximbills_drawfpsf where right(kpsfkey,1) = 'P') x where modi_dueda
> * te between '20060603' and '20060803' and payoutflag <> 'Y') P on le
> * ft(I.kpsfkey,25) = left(P.kpsfkey,25)) b on rtrim(ltrim(a.loanrefno)) => * substring(b.kpsfkey,1,12) where rtrim(ltrim(a.recordtype)) <> '009' or
> * der by loanrefno, kpsfkey
>
> ****************SQLDUMPER_ERRORLOG**************
> 07/20/06 20:24:58, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges
> () failed (00000514)
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4
> supplied
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1744
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr => 0x02A03570
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr
> = 0x00000000
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr => 0x00000000
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName => <NULL>
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Dump is associated
> with file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt
> 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not
> used
> 07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
> 07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed:
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.mdmp
> 07/20/06 20:25:03, ACTION, sqlservr.exe, Watson Invoke: No|||The query is working fine with running in query analyzer and there is no
error in dbcc checkdb. I found that there was an error in event viewer about
fatal exception with win32 or c++ when the MSSQL2005 stopped unexpectedly.
SQL Server is terminating because of fatal exception c0000005. This error
may be caused by an unhandled Win32 or C++ exception, or by an access
violation encountered during exception handling. Check the SQL error log for
any related stack dumps or messages. This exception forces SQL Server to
shutdown. To recover from this error, restart the server (unless SQLAgent is
configured to auto restart).
Thanks in advance!
"John Bell" wrote:
> Hi stephanie
> Have you run this query successfully from query analyser? Have you run DBCC
> CHECKDB and made sure that there are no hardware errors or other errors
> reported in the event log?
> You may want to look at re-writing the query. It is best not not use SELECT
> * in production code as you will be selecting more than you are using. Post
> DDL and sample data with the expected output from that data if you need help
> re-writing this see http://www.aspfaq.com/etiquette.asp?id=5006
> John
> "stephanie" wrote:
> > The SQL server was terminated by exception acess violation at 10pm but before
> > that, I got some dump logs between 8pm to 10pm. Any idea? Thanks in advance
> > ****************SQLDUMP.LOG**************
> > Memory
> > MemoryLoad = 90%
> > Total Physical = 2047 MB
> > Available Physical = 202 MB
> > Total Page File = 3947 MB
> > Available Page File = 2046 MB
> > Total Virtual = 2047 MB
> > Available Virtual = 93 MB
> > ***Stack Dump being sent to C:\Program Files\Microsoft SQL
> > Server\MSSQL.1\MSSQL\LOG\SQLDump0002.txt
> > SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005
> > EXCEPTION_ACCESS_VIOLATION. SQL Server is
> > terminating this process.
> >
> > *
> > *******************************************************************************
> > *
> >
> > * BEGIN STACK DUMP:
> >
> > * 07/20/06 20:26:18 spid 70
> >
> > *
> >
> > *
> >
> > * Exception Address = 7C8224B2 Module(ntdll+000224B2)
> >
> > * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> >
> > * Access Violation occurred reading address 00000003
> >
> > * Input Buffer 510 bytes -
> >
> > * select a.currencycode, a.glmasterno, a.loanrefno, a.customerid, a.contra
> >
> > * cttype, a.NewLoanBaln, a.TtlAccrueInt, substring(b.duedate,5,2) + '/' +
> >
> > * substring(b.duedate,3,2) + '/' + substring(b.duedate,1,2) as DueDate_Fox
> >
> > * Pro, b.* from eximbills_drawfm00 a right join (select I.*, P.schedulep
> >
> > * rincipal as MerchedPrincipal, P.penaltotalinterest as Ppenality from (se
> >
> > * lect * from (Select *, case when left(duedate,2) > '78' then '19' + d
> >
> > * uedate else '20' + duedate end as modi_duedate from eximbills_drawfpsf w
> >
> > * here right(kpsfkey,1) = 'I') z where modi_duedate between '20060603' a
> >
> > * nd '20060803' and payoutflag <> 'Y') I join (select scheduleprincipal
> >
> > * , kpsfkey, penaltotalinterest from (Select *, case when left(duedate,
> >
> > * 2) > '78' then '19' + duedate else '20' + duedate end as modi_duedate fr
> >
> > * om eximbills_drawfpsf where right(kpsfkey,1) = 'P') x where modi_dueda
> >
> > * te between '20060603' and '20060803' and payoutflag <> 'Y') P on le
> >
> > * ft(I.kpsfkey,25) = left(P.kpsfkey,25)) b on rtrim(ltrim(a.loanrefno)) => >
> > * substring(b.kpsfkey,1,12) where rtrim(ltrim(a.recordtype)) <> '009' or
> >
> > * der by loanrefno, kpsfkey
> >
> >
> > ****************SQLDUMPER_ERRORLOG**************
> > 07/20/06 20:24:58, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges
> > () failed (00000514)
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4
> > supplied
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1744
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr => > 0x02A03570
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr
> > = 0x00000000
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr => > 0x00000000
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName => > <NULL>
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Dump is associated
> > with file C:\Program Files\Microsoft SQL
> > Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt
> > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not
> > used
> > 07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
> > 07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed:
> > C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.mdmp
> > 07/20/06 20:25:03, ACTION, sqlservr.exe, Watson Invoke: No|||Hi Stephanie
There are a couple of issues logged at:
https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx?SearchQuery=c0000005
they mainly seem to be the 64 bit version. You could try the post SP1 hotfix
on a test server http://support.microsoft.com/Kb/918222 is publically
available and there are others available from PSS see
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
I think the issue may be related to the complexity of the query, so you may
want to try and re-write it or reduce it to find the point when it fails.
You may also want to raise a call with PSS and pass on any dump files that
you have.
John
"stephanie" wrote:
> The query is working fine with running in query analyzer and there is no
> error in dbcc checkdb. I found that there was an error in event viewer about
> fatal exception with win32 or c++ when the MSSQL2005 stopped unexpectedly.
> SQL Server is terminating because of fatal exception c0000005. This error
> may be caused by an unhandled Win32 or C++ exception, or by an access
> violation encountered during exception handling. Check the SQL error log for
> any related stack dumps or messages. This exception forces SQL Server to
> shutdown. To recover from this error, restart the server (unless SQLAgent is
> configured to auto restart).
>
> Thanks in advance!
> "John Bell" wrote:
> > Hi stephanie
> >
> > Have you run this query successfully from query analyser? Have you run DBCC
> > CHECKDB and made sure that there are no hardware errors or other errors
> > reported in the event log?
> >
> > You may want to look at re-writing the query. It is best not not use SELECT
> > * in production code as you will be selecting more than you are using. Post
> > DDL and sample data with the expected output from that data if you need help
> > re-writing this see http://www.aspfaq.com/etiquette.asp?id=5006
> >
> > John
> >
> > "stephanie" wrote:
> >
> > > The SQL server was terminated by exception acess violation at 10pm but before
> > > that, I got some dump logs between 8pm to 10pm. Any idea? Thanks in advance
> > > ****************SQLDUMP.LOG**************
> > > Memory
> > > MemoryLoad = 90%
> > > Total Physical = 2047 MB
> > > Available Physical = 202 MB
> > > Total Page File = 3947 MB
> > > Available Page File = 2046 MB
> > > Total Virtual = 2047 MB
> > > Available Virtual = 93 MB
> > > ***Stack Dump being sent to C:\Program Files\Microsoft SQL
> > > Server\MSSQL.1\MSSQL\LOG\SQLDump0002.txt
> > > SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005
> > > EXCEPTION_ACCESS_VIOLATION. SQL Server is
> > > terminating this process.
> > >
> > > *
> > > *******************************************************************************
> > > *
> > >
> > > * BEGIN STACK DUMP:
> > >
> > > * 07/20/06 20:26:18 spid 70
> > >
> > > *
> > >
> > > *
> > >
> > > * Exception Address = 7C8224B2 Module(ntdll+000224B2)
> > >
> > > * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> > >
> > > * Access Violation occurred reading address 00000003
> > >
> > > * Input Buffer 510 bytes -
> > >
> > > * select a.currencycode, a.glmasterno, a.loanrefno, a.customerid, a.contra
> > >
> > > * cttype, a.NewLoanBaln, a.TtlAccrueInt, substring(b.duedate,5,2) + '/' +
> > >
> > > * substring(b.duedate,3,2) + '/' + substring(b.duedate,1,2) as DueDate_Fox
> > >
> > > * Pro, b.* from eximbills_drawfm00 a right join (select I.*, P.schedulep
> > >
> > > * rincipal as MerchedPrincipal, P.penaltotalinterest as Ppenality from (se
> > >
> > > * lect * from (Select *, case when left(duedate,2) > '78' then '19' + d
> > >
> > > * uedate else '20' + duedate end as modi_duedate from eximbills_drawfpsf w
> > >
> > > * here right(kpsfkey,1) = 'I') z where modi_duedate between '20060603' a
> > >
> > > * nd '20060803' and payoutflag <> 'Y') I join (select scheduleprincipal
> > >
> > > * , kpsfkey, penaltotalinterest from (Select *, case when left(duedate,
> > >
> > > * 2) > '78' then '19' + duedate else '20' + duedate end as modi_duedate fr
> > >
> > > * om eximbills_drawfpsf where right(kpsfkey,1) = 'P') x where modi_dueda
> > >
> > > * te between '20060603' and '20060803' and payoutflag <> 'Y') P on le
> > >
> > > * ft(I.kpsfkey,25) = left(P.kpsfkey,25)) b on rtrim(ltrim(a.loanrefno)) => > >
> > > * substring(b.kpsfkey,1,12) where rtrim(ltrim(a.recordtype)) <> '009' or
> > >
> > > * der by loanrefno, kpsfkey
> > >
> > >
> > > ****************SQLDUMPER_ERRORLOG**************
> > > 07/20/06 20:24:58, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges
> > > () failed (00000514)
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4
> > > supplied
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1744
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr => > > 0x02A03570
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr
> > > = 0x00000000
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr => > > 0x00000000
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName => > > <NULL>
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Dump is associated
> > > with file C:\Program Files\Microsoft SQL
> > > Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt
> > > 07/20/06 20:24:58, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not
> > > used
> > > 07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
> > > 07/20/06 20:25:03, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed:
> > > C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.mdmp
> > > 07/20/06 20:25:03, ACTION, sqlservr.exe, Watson Invoke: Nosql

Fatal exception error in MSSQL2005 SP1

Fatal exception error in mSSQL 2000 sp4

Hi all,

We have intermittent fatal exception error since MSSQL 2000 sp3. We have applied sp4 but the problem still can't be solved. Below is part the the SQLdump. Any advise on it? Thanks in advance!

BEGIN STACK DUMP:
* 05/13/06 11:26:08 spid 0
*
* Exception Address = 05EB8187 (vsnupr + 00021F7C Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000001F0
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* Invalid Address 77F80000 77FFCFFF 0007d000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* KERNEL32 7C570000 7C622FFF 000b3000
* RPCRT4 77D30000 77DA0FFF 00071000
* MSVCP71 7C080000 7C0FBFFF 0007c000
* MSVCR71 7D000000 7D057FFF 00058000
* opends60 41060000 41065FFF 00006000
* SHELL32 782F0000 78534FFF 00245000
* GDI32 77F40000 77F7AFFF 0003b000
* USER32 77E10000 77E6EFFF 0005f000
* SHLWAPI 63180000 631E8FFF 00069000
* msvcrt 78000000 78044FFF 00045000
* COMCTL32 71710000 71793FFF 00084000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* IMM32 75E60000 75E79FFF 0001a000
* sqlevn70 41080000 4108AFFF 0000b000
* NETAPI32 02BF0000 02C3EFFF 0004f000
* Secur32 02C40000 02C4EFFF 0000f000
* NTDSAPI 02C50000 02C60FFF 00011000
* DNSAPI 02C70000 02C93FFF 00024000
* WSOCK32 02CA0000 02CA7FFF 00008000
* WS2_32 02CB0000 02CC3FFF 00014000
* WS2HELP 02CD0000 02CD7FFF 00008000
* WLDAP32 02CE0000 02D09FFF 0002a000
* NETRAP 02D10000 02D15FFF 00006000
* SAMLIB 02D20000 02D2EFFF 0000f000
* AUTHZ 02D80000 02D8FFFF 00010000
* ole32 02FA0000 0308EFFF 000ef000
* XOLEHLP 03090000 03097FFF 00008000
* MSDTCPRX 030A0000 03156FFF 000b7000
* MTXCLU 03160000 0316FFFF 00010000
* VERSION 03170000 03176FFF 00007000
* LZ32 03180000 03185FFF 00006000
* CLUSAPI 03190000 0319FFFF 00010000
* RESUTILS 031A0000 031ACFFF 0000d000
* USERENV 031B0000 03210FFF 00061000
* rnr20 03220000 0322BFFF 0000c000
* iphlpapi 03270000 03282FFF 00013000
* ICMP 03290000 03294FFF 00005000
* MPRAPI 032A0000 032B6FFF 00017000
* OLEAUT32 032C0000 0335AFFF 0009b000
* ACTIVEDS 03360000 0338EFFF 0002f000
* ADSLDPC 03390000 033B2FFF 00023000
* RTUTILS 033C0000 033CDFFF 0000e000
* SETUPAPI 033D0000 0345DFFF 0008e000
* RASAPI32 03460000 03492FFF 00033000
* RASMAN 034A0000 034B0FFF 00011000
* TAPI32 034C0000 034E1FFF 00022000
* DHCPCSVC 034F0000 03508FFF 00019000
* winrnr 039B0000 039B7FFF 00008000
* rasadhlp 039C0000 039C4FFF 00005000
* SSNETLIB 04090000 040A5FFF 00016000
* NTMARTA 040E0000 040FCFFF 0001d000
* WINSPOOL 04110000 0412DFFF 0001e000
* MPR 04170000 0417FFFF 00010000
* security 04430000 04433FFF 00004000
* msafd 04770000 0478DFFF 0001e000
* wshtcpip 047D0000 047D6FFF 00007000
* SSmsLPCn 048F0000 048F7FFF 00008000
* SSnmPN70 04930000 04936FFF 00007000
* mswsock 049D0000 049E1FFF 00012000
* kerberos 04A40000 04A75FFF 00036000
* CRYPTDLL 04A80000 04A8DFFF 0000e000
* MSASN1 04A90000 04A9FFFF 00010000
* rsabase 04DA0000 04DC2FFF 00023000
* CRYPT32 04DD0000 04E56FFF 00087000
* SQLFTQRY 05050000 05075FFF 00026000
* CLBCATQ 05080000 0510FFFF 00090000
* sqloledb 05220000 0529CFFF 0007d000
* MSDART 052C0000 052E3FFF 00024000
* comdlg32 052F0000 0532DFFF 0003e000
* MSDATL3 05330000 05344FFF 00015000
* msv1_0 055D0000 055F0FFF 00021000
* oledb32 05700000 0576FFFF 00070000
* OLEDB32R 05770000 05780FFF 00011000
* xpsqlbot 05790000 05795FFF 00006000
* xpstar 05B00000 05B4CFFF 0004d000
* SQLRESLD 05B50000 05B5BFFF 0000c000
* SQLSVC 05B60000 05B7AFFF 0001b000
* ODBC32 05B80000 05BB9FFF 0003a000
* odbcbcp 05BC0000 05BC5FFF 00006000
* W95SCM 05BD0000 05BDCFFF 0000d000
* SQLUNIRL 05BE0000 05C0CFFF 0002d000
* SHFOLDER 05C10000 05C17FFF 00008000
* odbcint 05D60000 05D76FFF 00017000
* NDDEAPI 05D80000 05D86FFF 00007000
* SQLSVC 05D90000 05D95FFF 00006000
* xpstar 05DA0000 05DA8FFF 00009000
* xplog70 05DC0000 05DCEFFF 0000f000
* xplog70 05DD0000 05DD4FFF 00005000
* msdaora 05DF0000 05E26FFF 00037000
* MSDAORAR 05E30000 05E33FFF 00004000
* ociw32 10000000 1000DFFF 0000e000
* ORA73 05E80000 05ED8FFF 00059000
* CORE35 05EE0000 05F0BFFF 0002c000
* NLSRTL32 05F10000 05F57FFF 00048000
* MSVCRT40 05F60000 05F74FFF 00015000
* MSVCIRT 05F80000 05F91FFF 00012000
* CORE35O 05FA0000 05FC5FFF 00026000
* SQLLib18 05FF0000 06007FFF 00018000
* KG73 06010000 0605AFFF 0004b000
* comsvcs 06060000 061CEFFF 0016f000
* TxfAux 061D0000 06233FFF 00064000
* NLNT 06400000 06419FFF 0001a000
* WINMM 06420000 0644FFFF 00030000
* nttnt 06540000 0654BFFF 0000c000
* msdasql 06730000 06779FFF 0004a000
* MSDASQLR 06780000 06783FFF 00004000
* vfpodbc 06790000 06883FFF 000f4000
* odbccp32 076D0000 076E9FFF 0001a000
* cwbodbc 07C70000 07CE5FFF 00076000
* CWBNL 07CF0000 07D09FFF 0001a000
* cwbrw 07D10000 07D42FFF 00033000
* CwbAb1 07D50000 07D56FFF 00007000
* CWBSV 07D60000 07D7EFFF 0001f000
* CwbCf 07D80000 07D9DFFF 0001e000
* CwbAdNrt 07DA0000 07DB3FFF 00014000
* CwbBb1 07DC0000 07DC8FFF 00009000
* CWBCFTFT 07DD0000 07DD7FFF 00008000
* CWBNL1 07DE0000 07DECFFF 0000d000
* CwbAb 07DF0000 07DFEFFF 0000f000
* CWBCF1 07E00000 07E06FFF 00007000
* CWBNLTRN 07E10000 07E16FFF 00007000
* CwbCo 07E20000 07E57FFF 00038000
* CwbAd 07E60000 07E6CFFF 0000d000
* CwbMsgbx 07E70000 07E7AFFF 0000b000
* CWBNLDLG 07E80000 07E86FFF 00007000
* cwbuireg 07E90000 07E97FFF 00008000
* CwbAd1 07EA0000 07EA7FFF 00008000
* CWBUNPLA 07EB0000 07EE1FFF 00032000
* cwbsof 07EF0000 07F25FFF 00036000
* CwbSy 07F30000 07F39FFF 0000a000
* CWBRC 07F40000 07F51FFF 00012000
* CwbBb 07F60000 07F68FFF 00009000
* CWBUNSSL 07F70000 07F7FFFF 00010000
* MFC42 07F80000 0807AFFF 000fb000
* cwbstp 08080000 08096FFF 00017000
* CWBMSGB 084C0000 084C3FFF 00004000
* cwbcomsg 084D0000 084D4FFF 00005000
* CWBSOMRI 084E0000 084EDFFF 0000e000
* CWBODDLG 084F0000 084F6FFF 00007000
* CWBODMSG 08500000 08505FFF 00006000
* SQLTNSNT 08750000 0877FFFF 00030000
* NSNT 08780000 0879FFFF 00020000
* nasnsnt 087A0000 087C3FFF 00024000
* ntnt 087D0000 087D9FFF 0000a000
* NCRNT 087E0000 08828FFF 00049000
* msadce 08840000 0888CFFF 0004d000
* msadcer 08890000 08894FFF 00005000
* odsole70 09110000 09120FFF 00011000
* MQOA 09270000 092A9FFF 0003a000
* MQRT 092B0000 092CDFFF 0001e000
* MQSec 092D0000 092E3FFF 00014000
* MQUtil 092F0000 0930EFFF 0001f000
* MQDSCli 09310000 09326FFF 00017000
* SQLSRV32 095C0000 09626FFF 00067000
* sqlsrv32 09630000 09645FFF 00016000
* Cwbnetnt 09660000 09666FFF 00007000
* sqlvdi 0A260000 0A26CFFF 0000d000
* adsldp 04720000 04741FFF 00022000
* adsmsext 09EC0000 09ED1FFF 00012000
* sqlmap70 05000000 0502CFFF 0002d000
* MAPI32 05E40000 05E60FFF 00021000
* MSMAPI32 0A320000 0A3E7FFF 000c8000
* GAPI32 0A3F0000 0A407FFF 00018000
* dbghelp 0B540000 0B63FFFF 00100000
*
* Edi: 00000000:
* Esi: 0536AB20: 05DF2B28 00000007 00000001 00001000 05381978 0B1DB
F08
* Eax: 000001F0:
* Ebx: 77E1A7BD: 53EC8B55 A1645756 00000018 F08BC933 0F0C4D39 00008
B85
* Ecx: 00003931:
* Edx: 0B503032: 00000000 00000000 00000000 00000000 00000000 00000
000
* Eip: 05EB8187:
* Ebp: 0B50F98C: 0B50F9B8 05EAFCE3 00000002 00000000 0536AB20 77E1A
7BD
* SegCs: 0000001B:
* EFlags: 00010206: 0057005C 004E0049 0054004E 0073005C 00730079 00650
074
* Esp: 0B50F97C: 00000000 0536AB20 77E1A7BD 000001F0 0B50F9B8 05EAF
CE3
* SegSs: 00000023:
* *****************************************************************************
**
* --
--
* Short Stack Dump
* 05EB8187 Module(ORA73+00038187) (vsnupr+00021F7C)
* 05EAFCE3 Module(ORA73+0002FCE3) (vsnupr+00019AD8)
* 05EC4499 Module(ORA73+00044499) (vsnupr+0002E28E)
* 05EAFB95 Module(ORA73+0002FB95) (vsnupr+0001998A)
* 05EA1959 Module(ORA73+00021959) (vsnupr+0000B74E)
* 05E920A9 Module(ORA73+000120A9) (upiosd+00000063)
* 05E8BA77 Module(ORA73+0000BA77) (oparse+0000007C)
* 10001D88 Module(ociw32+00001D88) (oparse+00000028)
* 05E0EC77 Module(msdaora+0001EC77) (DllRegisterServer+000017B5)
* 780085BC Module(msvcrt+000085BC) (endthreadex+000000BC)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
-
* Location : 05EB8187 Module(ORA73+00038187) (vsnupr+00021F7C)
* Return Addr: 05EAFCE3 Module(ORA73+0002FCE3) (vsnupr+00019AD8)
Frame : 0B50F98C
Parameters:
[1] 00000002:
[2] 00000000:
[3] 0536AB20: 05DF2B28 00000007 00000001 00001000 05381978 0B1DBF08
[4] 77E1A7BD: 53EC8B55 A1645756 00000018 F08BC933 0F0C4D39 00008B85
160 bytes of stack data from 0B50F8EC to 0B50F98C
0B50F8EC: 000B0CE8 0A9E7C98 00000104 08A60048 [.....|......H...]
0B50F8FC: 05490178 08A60048 05490178 08A60040 [x.I.H...x.I.@....]
0B50F90C: 000001B7 00000001 00000000 00000000 [................]
0B50F91C: 00000000 00000000 00000000 00000000 [................]
:::: 2 Duplicate lines detected
0B50F94C: 00000000 0A9E7854 0000001C 77F82A8C [....Tx.......*.w]
0B50F95C: 0A9E7860 00000005 77F82A8C 000B0000 [`x.......*.w....]
0B50F96C: 000B0778 00000005 001761A8 0A9E7838 [x........a..8x..]
0B50F97C: 00000000 0536AB20 77E1A7BD 000001F0 [.... .6....w....]

Hi Stephanie,

What OS are you running on (e.g. Windows Server 2003)?

Is the SQL Server configured for AWE and are you using the /PAE switch?
|||OS is Win2000 SP4 and awe is not enabled. Any advise? Thanks|||Hi Stephanie,

I once had a Win 2K SP4 server that spit out errors like the one you are seeing occasionally.

This server had multiple processors on it but the error seemed to go away after I turned down the degree of parallelism so that it was less than the # of processors on the server.

If you've got multiple processors on the server, you might want to consider doing the same thing (turning down the degree of parallelism) and see if that helps any.
|||

Hi Nate,

Thanks for your advise. we have already turn off the parallelism and use 1 processor only (there are 2 processors in the machine). And I just found that the /PAE is turned on in boot.ini. Probably, it is root cause... Many Thanks for your advise.

|||Ah OK....I've read before that /PAE can cause problems so hopefully turning it off would make things better.

Glad I could be of a little help

Fatal exception error in mSSQL 2000 sp3 and sp4

Hi all,
We have intermittent fatal exception error since MSSQL 2000 sp3a. We have
applied sp4 but the problem still can't be solved. Below is part the the
SQLdump. Any advise on it? Thanks in advance!
BEGIN STACK DUMP:
* 05/13/06 11:26:08 spid 0
*
* Exception Address = 05EB8187 (vsnupr + 00021F7C Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000001F0
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* Invalid Address 77F80000 77FFCFFF 0007d000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* KERNEL32 7C570000 7C622FFF 000b3000
* RPCRT4 77D30000 77DA0FFF 00071000
* MSVCP71 7C080000 7C0FBFFF 0007c000
* MSVCR71 7D000000 7D057FFF 00058000
* opends60 41060000 41065FFF 00006000
* SHELL32 782F0000 78534FFF 00245000
* GDI32 77F40000 77F7AFFF 0003b000
* USER32 77E10000 77E6EFFF 0005f000
* SHLWAPI 63180000 631E8FFF 00069000
* msvcrt 78000000 78044FFF 00045000
* COMCTL32 71710000 71793FFF 00084000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* IMM32 75E60000 75E79FFF 0001a000
* sqlevn70 41080000 4108AFFF 0000b000
* NETAPI32 02BF0000 02C3EFFF 0004f000
* Secur32 02C40000 02C4EFFF 0000f000
* NTDSAPI 02C50000 02C60FFF 00011000
* DNSAPI 02C70000 02C93FFF 00024000
* WSOCK32 02CA0000 02CA7FFF 00008000
* WS2_32 02CB0000 02CC3FFF 00014000
* WS2HELP 02CD0000 02CD7FFF 00008000
* WLDAP32 02CE0000 02D09FFF 0002a000
* NETRAP 02D10000 02D15FFF 00006000
* SAMLIB 02D20000 02D2EFFF 0000f000
* AUTHZ 02D80000 02D8FFFF 00010000
* ole32 02FA0000 0308EFFF 000ef000
* XOLEHLP 03090000 03097FFF 00008000
* MSDTCPRX 030A0000 03156FFF 000b7000
* MTXCLU 03160000 0316FFFF 00010000
* VERSION 03170000 03176FFF 00007000
* LZ32 03180000 03185FFF 00006000
* CLUSAPI 03190000 0319FFFF 00010000
* RESUTILS 031A0000 031ACFFF 0000d000
* USERENV 031B0000 03210FFF 00061000
* rnr20 03220000 0322BFFF 0000c000
* iphlpapi 03270000 03282FFF 00013000
* ICMP 03290000 03294FFF 00005000
* MPRAPI 032A0000 032B6FFF 00017000
* OLEAUT32 032C0000 0335AFFF 0009b000
* ACTIVEDS 03360000 0338EFFF 0002f000
* ADSLDPC 03390000 033B2FFF 00023000
* RTUTILS 033C0000 033CDFFF 0000e000
* SETUPAPI 033D0000 0345DFFF 0008e000
* RASAPI32 03460000 03492FFF 00033000
* RASMAN 034A0000 034B0FFF 00011000
* TAPI32 034C0000 034E1FFF 00022000
* DHCPCSVC 034F0000 03508FFF 00019000
* winrnr 039B0000 039B7FFF 00008000
* rasadhlp 039C0000 039C4FFF 00005000
* SSNETLIB 04090000 040A5FFF 00016000
* NTMARTA 040E0000 040FCFFF 0001d000
* WINSPOOL 04110000 0412DFFF 0001e000
* MPR 04170000 0417FFFF 00010000
* security 04430000 04433FFF 00004000
* msafd 04770000 0478DFFF 0001e000
* wshtcpip 047D0000 047D6FFF 00007000
* SSmsLPCn 048F0000 048F7FFF 00008000
* SSnmPN70 04930000 04936FFF 00007000
* mswsock 049D0000 049E1FFF 00012000
* kerberos 04A40000 04A75FFF 00036000
* CRYPTDLL 04A80000 04A8DFFF 0000e000
* MSASN1 04A90000 04A9FFFF 00010000
* rsabase 04DA0000 04DC2FFF 00023000
* CRYPT32 04DD0000 04E56FFF 00087000
* SQLFTQRY 05050000 05075FFF 00026000
* CLBCATQ 05080000 0510FFFF 00090000
* sqloledb 05220000 0529CFFF 0007d000
* MSDART 052C0000 052E3FFF 00024000
* comdlg32 052F0000 0532DFFF 0003e000
* MSDATL3 05330000 05344FFF 00015000
* msv1_0 055D0000 055F0FFF 00021000
* oledb32 05700000 0576FFFF 00070000
* OLEDB32R 05770000 05780FFF 00011000
* xpsqlbot 05790000 05795FFF 00006000
* xpstar 05B00000 05B4CFFF 0004d000
* SQLRESLD 05B50000 05B5BFFF 0000c000
* SQLSVC 05B60000 05B7AFFF 0001b000
* ODBC32 05B80000 05BB9FFF 0003a000
* odbcbcp 05BC0000 05BC5FFF 00006000
* W95SCM 05BD0000 05BDCFFF 0000d000
* SQLUNIRL 05BE0000 05C0CFFF 0002d000
* SHFOLDER 05C10000 05C17FFF 00008000
* odbcint 05D60000 05D76FFF 00017000
* NDDEAPI 05D80000 05D86FFF 00007000
* SQLSVC 05D90000 05D95FFF 00006000
* xpstar 05DA0000 05DA8FFF 00009000
* xplog70 05DC0000 05DCEFFF 0000f000
* xplog70 05DD0000 05DD4FFF 00005000
* msdaora 05DF0000 05E26FFF 00037000
* MSDAORAR 05E30000 05E33FFF 00004000
* ociw32 10000000 1000DFFF 0000e000
* ORA73 05E80000 05ED8FFF 00059000
* CORE35 05EE0000 05F0BFFF 0002c000
* NLSRTL32 05F10000 05F57FFF 00048000
* MSVCRT40 05F60000 05F74FFF 00015000
* MSVCIRT 05F80000 05F91FFF 00012000
* CORE35O 05FA0000 05FC5FFF 00026000
* SQLLib18 05FF0000 06007FFF 00018000
* KG73 06010000 0605AFFF 0004b000
* comsvcs 06060000 061CEFFF 0016f000
* TxfAux 061D0000 06233FFF 00064000
* NLNT 06400000 06419FFF 0001a000
* WINMM 06420000 0644FFFF 00030000
* nttnt 06540000 0654BFFF 0000c000
* msdasql 06730000 06779FFF 0004a000
* MSDASQLR 06780000 06783FFF 00004000
* vfpodbc 06790000 06883FFF 000f4000
* odbccp32 076D0000 076E9FFF 0001a000
* cwbodbc 07C70000 07CE5FFF 00076000
* CWBNL 07CF0000 07D09FFF 0001a000
* cwbrw 07D10000 07D42FFF 00033000
* CwbAb1 07D50000 07D56FFF 00007000
* CWBSV 07D60000 07D7EFFF 0001f000
* CwbCf 07D80000 07D9DFFF 0001e000
* CwbAdNrt 07DA0000 07DB3FFF 00014000
* CwbBb1 07DC0000 07DC8FFF 00009000
* CWBCFTFT 07DD0000 07DD7FFF 00008000
* CWBNL1 07DE0000 07DECFFF 0000d000
* CwbAb 07DF0000 07DFEFFF 0000f000
* CWBCF1 07E00000 07E06FFF 00007000
* CWBNLTRN 07E10000 07E16FFF 00007000
* CwbCo 07E20000 07E57FFF 00038000
* CwbAd 07E60000 07E6CFFF 0000d000
* CwbMsgbx 07E70000 07E7AFFF 0000b000
* CWBNLDLG 07E80000 07E86FFF 00007000
* cwbuireg 07E90000 07E97FFF 00008000
* CwbAd1 07EA0000 07EA7FFF 00008000
* CWBUNPLA 07EB0000 07EE1FFF 00032000
* cwbsof 07EF0000 07F25FFF 00036000
* CwbSy 07F30000 07F39FFF 0000a000
* CWBRC 07F40000 07F51FFF 00012000
* CwbBb 07F60000 07F68FFF 00009000
* CWBUNSSL 07F70000 07F7FFFF 00010000
* MFC42 07F80000 0807AFFF 000fb000
* cwbstp 08080000 08096FFF 00017000
* CWBMSGB 084C0000 084C3FFF 00004000
* cwbcomsg 084D0000 084D4FFF 00005000
* CWBSOMRI 084E0000 084EDFFF 0000e000
* CWBODDLG 084F0000 084F6FFF 00007000
* CWBODMSG 08500000 08505FFF 00006000
* SQLTNSNT 08750000 0877FFFF 00030000
* NSNT 08780000 0879FFFF 00020000
* nasnsnt 087A0000 087C3FFF 00024000
* ntnt 087D0000 087D9FFF 0000a000
* NCRNT 087E0000 08828FFF 00049000
* msadce 08840000 0888CFFF 0004d000
* msadcer 08890000 08894FFF 00005000
* odsole70 09110000 09120FFF 00011000
* MQOA 09270000 092A9FFF 0003a000
* MQRT 092B0000 092CDFFF 0001e000
* MQSec 092D0000 092E3FFF 00014000
* MQUtil 092F0000 0930EFFF 0001f000
* MQDSCli 09310000 09326FFF 00017000
* SQLSRV32 095C0000 09626FFF 00067000
* sqlsrv32 09630000 09645FFF 00016000
* Cwbnetnt 09660000 09666FFF 00007000
* sqlvdi 0A260000 0A26CFFF 0000d000
* adsldp 04720000 04741FFF 00022000
* adsmsext 09EC0000 09ED1FFF 00012000
* sqlmap70 05000000 0502CFFF 0002d000
* MAPI32 05E40000 05E60FFF 00021000
* MSMAPI32 0A320000 0A3E7FFF 000c8000
* GAPI32 0A3F0000 0A407FFF 00018000
* dbghelp 0B540000 0B63FFFF 00100000
*
* Edi: 00000000:
* Esi: 0536AB20: 05DF2B28 00000007 00000001 00001000 05381978
0B1DB
F08
* Eax: 000001F0:
* Ebx: 77E1A7BD: 53EC8B55 A1645756 00000018 F08BC933 0F0C4D39
00008
B85
* Ecx: 00003931:
* Edx: 0B503032: 00000000 00000000 00000000 00000000 00000000
00000
000
* Eip: 05EB8187:
* Ebp: 0B50F98C: 0B50F9B8 05EAFCE3 00000002 00000000 0536AB20
77E1A
7BD
* SegCs: 0000001B:
* EFlags: 00010206: 0057005C 004E0049 0054004E 0073005C 00730079
00650
074
* Esp: 0B50F97C: 00000000 0536AB20 77E1A7BD 000001F0 0B50F9B8
05EAF
CE3
* SegSs: 00000023:
*
*****************************************************************************
**
*
----
--
* Short Stack Dump
* 05EB8187 Module(ORA73+00038187) (vsnupr+00021F7C)
* 05EAFCE3 Module(ORA73+0002FCE3) (vsnupr+00019AD8)
* 05EC4499 Module(ORA73+00044499) (vsnupr+0002E28E)
* 05EAFB95 Module(ORA73+0002FB95) (vsnupr+0001998A)
* 05EA1959 Module(ORA73+00021959) (vsnupr+0000B74E)
* 05E920A9 Module(ORA73+000120A9) (upiosd+00000063)
* 05E8BA77 Module(ORA73+0000BA77) (oparse+0000007C)
* 10001D88 Module(ociw32+00001D88) (oparse+00000028)
* 05E0EC77 Module(msdaora+0001EC77) (DllRegisterServer+000017B5)
* 780085BC Module(msvcrt+000085BC) (endthreadex+000000BC)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
----
* Location : 05EB8187 Module(ORA73+00038187) (vsnupr+00021F7C)
* Return Addr: 05EAFCE3 Module(ORA73+0002FCE3) (vsnupr+00019AD8)
Frame : 0B50F98C
Parameters:
[1] 00000002:
[2] 00000000:
[3] 0536AB20: 05DF2B28 00000007 00000001 00001000 05381978 0B1DBF08
[4] 77E1A7BD: 53EC8B55 A1645756 00000018 F08BC933 0F0C4D39 00008B85
160 bytes of stack data from 0B50F8EC to 0B50F98C
0B50F8EC: 000B0CE8 0A9E7C98 00000104 08A60048 [....|.....H...]
0B50F8FC: 05490178 08A60048 05490178 08A60040 [x.I.H...x.I.@....]
0B50F90C: 000001B7 00000001 00000000 00000000 [............]
0B50F91C: 00000000 00000000 00000000 00000000 [............]
:::: 2 Duplicate lines detected
0B50F94C: 00000000 0A9E7854 0000001C 77F82A8C [...Tx......*.w]
0B50F95C: 0A9E7860 00000005 77F82A8C 000B0000 [`x......*.w...]
0B50F96C: 000B0778 00000005 001761A8 0A9E7838 [x......a..8x..]
0B50F97C: 00000000 0536AB20 77E1A7BD 000001F0 [... .6...w...]Hi Stephanie,
Is the machine you are running on a multiprocessor machine? What sort
of storage system are you using (e.g. RAID, SAN)?
If you have a contract with MS Support (I'm under the impression you
need a contract now to get phone or email support for SQL Server 2000,
could be wrong though) you might consider forwarding them the SQL Dump
and also your mini-dump file (you should've got 2 files out of the
exception, a .txt file and another file which would be your mini-dump
file).
Sorry I can't be of more help.

Fatal exception error in mSSQL 2000 sp3 and sp4

Hi all,
We have intermittent fatal exception error since MSSQL 2000 sp3a. We have
applied sp4 but the problem still can't be solved. Below is part the the
SQLdump. Any advise on it? Thanks in advance!
BEGIN STACK DUMP:
* 05/13/06 11:26:08 spid 0
*
* Exception Address = 05EB8187 (vsnupr + 00021F7C Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000001F0
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* Invalid Address 77F80000 77FFCFFF 0007d000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* KERNEL32 7C570000 7C622FFF 000b3000
* RPCRT4 77D30000 77DA0FFF 00071000
* MSVCP71 7C080000 7C0FBFFF 0007c000
* MSVCR71 7D000000 7D057FFF 00058000
* opends60 41060000 41065FFF 00006000
* SHELL32 782F0000 78534FFF 00245000
* GDI32 77F40000 77F7AFFF 0003b000
* USER32 77E10000 77E6EFFF 0005f000
* SHLWAPI 63180000 631E8FFF 00069000
* msvcrt 78000000 78044FFF 00045000
* COMCTL32 71710000 71793FFF 00084000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* IMM32 75E60000 75E79FFF 0001a000
* sqlevn70 41080000 4108AFFF 0000b000
* NETAPI32 02BF0000 02C3EFFF 0004f000
* Secur32 02C40000 02C4EFFF 0000f000
* NTDSAPI 02C50000 02C60FFF 00011000
* DNSAPI 02C70000 02C93FFF 00024000
* WSOCK32 02CA0000 02CA7FFF 00008000
* WS2_32 02CB0000 02CC3FFF 00014000
* WS2HELP 02CD0000 02CD7FFF 00008000
* WLDAP32 02CE0000 02D09FFF 0002a000
* NETRAP 02D10000 02D15FFF 00006000
* SAMLIB 02D20000 02D2EFFF 0000f000
* AUTHZ 02D80000 02D8FFFF 00010000
* ole32 02FA0000 0308EFFF 000ef000
* XOLEHLP 03090000 03097FFF 00008000
* MSDTCPRX 030A0000 03156FFF 000b7000
* MTXCLU 03160000 0316FFFF 00010000
* VERSION 03170000 03176FFF 00007000
* LZ32 03180000 03185FFF 00006000
* CLUSAPI 03190000 0319FFFF 00010000
* RESUTILS 031A0000 031ACFFF 0000d000
* USERENV 031B0000 03210FFF 00061000
* rnr20 03220000 0322BFFF 0000c000
* iphlpapi 03270000 03282FFF 00013000
* ICMP 03290000 03294FFF 00005000
* MPRAPI 032A0000 032B6FFF 00017000
* OLEAUT32 032C0000 0335AFFF 0009b000
* ACTIVEDS 03360000 0338EFFF 0002f000
* ADSLDPC 03390000 033B2FFF 00023000
* RTUTILS 033C0000 033CDFFF 0000e000
* SETUPAPI 033D0000 0345DFFF 0008e000
* RASAPI32 03460000 03492FFF 00033000
* RASMAN 034A0000 034B0FFF 00011000
* TAPI32 034C0000 034E1FFF 00022000
* DHCPCSVC 034F0000 03508FFF 00019000
* winrnr 039B0000 039B7FFF 00008000
* rasadhlp 039C0000 039C4FFF 00005000
* SSNETLIB 04090000 040A5FFF 00016000
* NTMARTA 040E0000 040FCFFF 0001d000
* WINSPOOL 04110000 0412DFFF 0001e000
* MPR 04170000 0417FFFF 00010000
* security 04430000 04433FFF 00004000
* msafd 04770000 0478DFFF 0001e000
* wshtcpip 047D0000 047D6FFF 00007000
* SSmsLPCn 048F0000 048F7FFF 00008000
* SSnmPN70 04930000 04936FFF 00007000
* mswsock 049D0000 049E1FFF 00012000
* kerberos 04A40000 04A75FFF 00036000
* CRYPTDLL 04A80000 04A8DFFF 0000e000
* MSASN1 04A90000 04A9FFFF 00010000
* rsabase 04DA0000 04DC2FFF 00023000
* CRYPT32 04DD0000 04E56FFF 00087000
* SQLFTQRY 05050000 05075FFF 00026000
* CLBCATQ 05080000 0510FFFF 00090000
* sqloledb 05220000 0529CFFF 0007d000
* MSDART 052C0000 052E3FFF 00024000
* comdlg32 052F0000 0532DFFF 0003e000
* MSDATL3 05330000 05344FFF 00015000
* msv1_0 055D0000 055F0FFF 00021000
* oledb32 05700000 0576FFFF 00070000
* OLEDB32R 05770000 05780FFF 00011000
* xpsqlbot 05790000 05795FFF 00006000
* xpstar 05B00000 05B4CFFF 0004d000
* SQLRESLD 05B50000 05B5BFFF 0000c000
* SQLSVC 05B60000 05B7AFFF 0001b000
* ODBC32 05B80000 05BB9FFF 0003a000
* odbcbcp 05BC0000 05BC5FFF 00006000
* W95SCM 05BD0000 05BDCFFF 0000d000
* SQLUNIRL 05BE0000 05C0CFFF 0002d000
* SHFOLDER 05C10000 05C17FFF 00008000
* odbcint 05D60000 05D76FFF 00017000
* NDDEAPI 05D80000 05D86FFF 00007000
* SQLSVC 05D90000 05D95FFF 00006000
* xpstar 05DA0000 05DA8FFF 00009000
* xplog70 05DC0000 05DCEFFF 0000f000
* xplog70 05DD0000 05DD4FFF 00005000
* msdaora 05DF0000 05E26FFF 00037000
* MSDAORAR 05E30000 05E33FFF 00004000
* ociw32 10000000 1000DFFF 0000e000
* ORA73 05E80000 05ED8FFF 00059000
* CORE35 05EE0000 05F0BFFF 0002c000
* NLSRTL32 05F10000 05F57FFF 00048000
* MSVCRT40 05F60000 05F74FFF 00015000
* MSVCIRT 05F80000 05F91FFF 00012000
* CORE35O 05FA0000 05FC5FFF 00026000
* SQLLib18 05FF0000 06007FFF 00018000
* KG73 06010000 0605AFFF 0004b000
* comsvcs 06060000 061CEFFF 0016f000
* TxfAux 061D0000 06233FFF 00064000
* NLNT 06400000 06419FFF 0001a000
* WINMM 06420000 0644FFFF 00030000
* nttnt 06540000 0654BFFF 0000c000
* msdasql 06730000 06779FFF 0004a000
* MSDASQLR 06780000 06783FFF 00004000
* vfpodbc 06790000 06883FFF 000f4000
* odbccp32 076D0000 076E9FFF 0001a000
* cwbodbc 07C70000 07CE5FFF 00076000
* CWBNL 07CF0000 07D09FFF 0001a000
* cwbrw 07D10000 07D42FFF 00033000
* CwbAb1 07D50000 07D56FFF 00007000
* CWBSV 07D60000 07D7EFFF 0001f000
* CwbCf 07D80000 07D9DFFF 0001e000
* CwbAdNrt 07DA0000 07DB3FFF 00014000
* CwbBb1 07DC0000 07DC8FFF 00009000
* CWBCFTFT 07DD0000 07DD7FFF 00008000
* CWBNL1 07DE0000 07DECFFF 0000d000
* CwbAb 07DF0000 07DFEFFF 0000f000
* CWBCF1 07E00000 07E06FFF 00007000
* CWBNLTRN 07E10000 07E16FFF 00007000
* CwbCo 07E20000 07E57FFF 00038000
* CwbAd 07E60000 07E6CFFF 0000d000
* CwbMsgbx 07E70000 07E7AFFF 0000b000
* CWBNLDLG 07E80000 07E86FFF 00007000
* cwbuireg 07E90000 07E97FFF 00008000
* CwbAd1 07EA0000 07EA7FFF 00008000
* CWBUNPLA 07EB0000 07EE1FFF 00032000
* cwbsof 07EF0000 07F25FFF 00036000
* CwbSy 07F30000 07F39FFF 0000a000
* CWBRC 07F40000 07F51FFF 00012000
* CwbBb 07F60000 07F68FFF 00009000
* CWBUNSSL 07F70000 07F7FFFF 00010000
* MFC42 07F80000 0807AFFF 000fb000
* cwbstp 08080000 08096FFF 00017000
* CWBMSGB 084C0000 084C3FFF 00004000
* cwbcomsg 084D0000 084D4FFF 00005000
* CWBSOMRI 084E0000 084EDFFF 0000e000
* CWBODDLG 084F0000 084F6FFF 00007000
* CWBODMSG 08500000 08505FFF 00006000
* SQLTNSNT 08750000 0877FFFF 00030000
* NSNT 08780000 0879FFFF 00020000
* nasnsnt 087A0000 087C3FFF 00024000
* ntnt 087D0000 087D9FFF 0000a000
* NCRNT 087E0000 08828FFF 00049000
* msadce 08840000 0888CFFF 0004d000
* msadcer 08890000 08894FFF 00005000
* odsole70 09110000 09120FFF 00011000
* MQOA 09270000 092A9FFF 0003a000
* MQRT 092B0000 092CDFFF 0001e000
* MQSec 092D0000 092E3FFF 00014000
* MQUtil 092F0000 0930EFFF 0001f000
* MQDSCli 09310000 09326FFF 00017000
* SQLSRV32 095C0000 09626FFF 00067000
* sqlsrv32 09630000 09645FFF 00016000
* Cwbnetnt 09660000 09666FFF 00007000
* sqlvdi 0A260000 0A26CFFF 0000d000
* adsldp 04720000 04741FFF 00022000
* adsmsext 09EC0000 09ED1FFF 00012000
* sqlmap70 05000000 0502CFFF 0002d000
* MAPI32 05E40000 05E60FFF 00021000
* MSMAPI32 0A320000 0A3E7FFF 000c8000
* GAPI32 0A3F0000 0A407FFF 00018000
* dbghelp 0B540000 0B63FFFF 00100000
*
* Edi: 00000000:
* Esi: 0536AB20: 05DF2B28 00000007 00000001 00001000 05381978
0B1DB
F08
* Eax: 000001F0:
* Ebx: 77E1A7BD: 53EC8B55 A1645756 00000018 F08BC933 0F0C4D39
00008
B85
* Ecx: 00003931:
* Edx: 0B503032: 00000000 00000000 00000000 00000000 00000000
00000
000
* Eip: 05EB8187:
* Ebp: 0B50F98C: 0B50F9B8 05EAFCE3 00000002 00000000 0536AB20
77E1A
7BD
* SegCs: 0000001B:
* EFlags: 00010206: 0057005C 004E0049 0054004E 0073005C 00730079
00650
074
* Esp: 0B50F97C: 00000000 0536AB20 77E1A7BD 000001F0 0B50F9B8
05EAF
CE3
* SegSs: 00000023:
*
****************************************
************************************
*
**
*
----
-
--
* Short Stack Dump
* 05EB8187 Module(ORA73+00038187) (vsnupr+00021F7C)
* 05EAFCE3 Module(ORA73+0002FCE3) (vsnupr+00019AD8)
* 05EC4499 Module(ORA73+00044499) (vsnupr+0002E28E)
* 05EAFB95 Module(ORA73+0002FB95) (vsnupr+0001998A)
* 05EA1959 Module(ORA73+00021959) (vsnupr+0000B74E)
* 05E920A9 Module(ORA73+000120A9) (upiosd+00000063)
* 05E8BA77 Module(ORA73+0000BA77) (oparse+0000007C)
* 10001D88 Module(ociw32+00001D88) (oparse+00000028)
* 05E0EC77 Module(msdaora+0001EC77) (DllRegisterServer+000017B5)
* 780085BC Module(msvcrt+000085BC) (endthreadex+000000BC)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
----
--
* Location : 05EB8187 Module(ORA73+00038187) (vsnupr+00021F7C)
* Return Addr: 05EAFCE3 Module(ORA73+0002FCE3) (vsnupr+00019AD8)
Frame : 0B50F98C
Parameters:
[1] 00000002:
[2] 00000000:
[3] 0536AB20: 05DF2B28 00000007 00000001 00001000 05381978 0B1DBF08
[4] 77E1A7BD: 53EC8B55 A1645756 00000018 F08BC933 0F0C4D39 00008B85
160 bytes of stack data from 0B50F8EC to 0B50F98C
0B50F8EC: 000B0CE8 0A9E7C98 00000104 08A60048 [....|.....H...]
0B50F8FC: 05490178 08A60048 05490178 08A60040 [x.I.H...x.I.@....]
0B50F90C: 000001B7 00000001 00000000 00000000 [............]
0B50F91C: 00000000 00000000 00000000 00000000 [............]
:::: 2 Duplicate lines detected
0B50F94C: 00000000 0A9E7854 0000001C 77F82A8C [...Tx......*.w]
0B50F95C: 0A9E7860 00000005 77F82A8C 000B0000 [`x......*.w...]
0B50F96C: 000B0778 00000005 001761A8 0A9E7838 [x......a..8x..]
0B50F97C: 00000000 0536AB20 77E1A7BD 000001F0 [... .6...w...]Hi Stephanie,
Is the machine you are running on a multiprocessor machine? What sort
of storage system are you using (e.g. RAID, SAN)?
If you have a contract with MS Support (I'm under the impression you
need a contract now to get phone or email support for SQL Server 2000,
could be wrong though) you might consider forwarding them the SQL Dump
and also your mini-dump file (you should've got 2 files out of the
exception, a .txt file and another file which would be your mini-dump
file).
Sorry I can't be of more help.

Fatal Exception Error

Hello,
This morning, my SQL Server 2000 was not responding and upon investigation
in the logs, I noticed that one process had brought the services down (2
services were shut off: SQL Server and SQL Server Agent).
I restarted the services and everything went fine.....however, if it
hapenned once, I'm sure it will come back to haunt me again.
Below is a dump of SQL Server Log in the last moments of going down: -
================================================== =====================
2005-04-18 06:59:04.31 spid55SQL Server is aborting. Fatal exception 0
caught..
2005-04-18 06:59:04.31 spid55Error: 0, Severity: 21, State: 0
2005-04-18 06:59:04.31 spid55Stack Signature for the dump is 0xBF697704
2005-04-18 06:59:03.41 spid55Using 'dbghelp.dll' version '4.0.5'...
2005-04-18 06:59:03.41 spid55Error: 3624, Severity: 20, State: 1.
2005-04-18 06:59:03.40 spid55SQL Server Assertion: File: <p:\sql\ntdbms\
cursors\src\ccursor.cpp>, line=850 .
2005-04-18 06:59:03.40 spid55Stack Signature for the dump is 0x4191A817
2005-04-18 06:59:02.18 spid55Using 'dbghelp.dll' version '4.0.5'...
2005-04-18 06:59:02.15 spid55Stack Signature for the dump is 0x92504269
2005-04-18 06:58:59.59 spid55SqlDumpExceptionHandler: Process 55
generated fatal exception c0000005 EXCEPTIO
2005-04-18 06:58:59.59 spid55Error: 0, Severity: 19, State: 0
2005-04-18 06:58:59.31 spid55Using 'dbghelp.dll' version '4.0.5'...
================================================== =====================
Can anyone please guide me with the diagnosis and possible prevention
methods.
Thanks,
Sameer.
Message posted via http://www.sqlmonster.com
This is likely to be a SQL bug... Make sure you are service packed up...
and it's probably time to call PSS... but if you post enough information
here, it would be good if someone can reproduce it...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Sameer Premji via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:5f2af30e65464083a8bd1523a3753302@.SQLMonster.c om...
> Hello,
> This morning, my SQL Server 2000 was not responding and upon investigation
> in the logs, I noticed that one process had brought the services down (2
> services were shut off: SQL Server and SQL Server Agent).
> I restarted the services and everything went fine.....however, if it
> hapenned once, I'm sure it will come back to haunt me again.
> Below is a dump of SQL Server Log in the last moments of going down: -
> ================================================== =====================
> 2005-04-18 06:59:04.31 spid55 SQL Server is aborting. Fatal exception 0
> caught..
> 2005-04-18 06:59:04.31 spid55 Error: 0, Severity: 21, State: 0
> 2005-04-18 06:59:04.31 spid55 Stack Signature for the dump is 0xBF697704
> 2005-04-18 06:59:03.41 spid55 Using 'dbghelp.dll' version '4.0.5'...
> 2005-04-18 06:59:03.41 spid55 Error: 3624, Severity: 20, State: 1.
> 2005-04-18 06:59:03.40 spid55 SQL Server Assertion: File: <p:\sql\ntdbms\
> cursors\src\ccursor.cpp>, line=850 .
> 2005-04-18 06:59:03.40 spid55 Stack Signature for the dump is 0x4191A817
> 2005-04-18 06:59:02.18 spid55 Using 'dbghelp.dll' version '4.0.5'...
> 2005-04-18 06:59:02.15 spid55 Stack Signature for the dump is 0x92504269
> 2005-04-18 06:58:59.59 spid55 SqlDumpExceptionHandler: Process 55
> generated fatal exception c0000005 EXCEPTIO
> 2005-04-18 06:58:59.59 spid55 Error: 0, Severity: 19, State: 0
> 2005-04-18 06:58:59.31 spid55 Using 'dbghelp.dll' version '4.0.5'...
> ================================================== =====================
> Can anyone please guide me with the diagnosis and possible prevention
> methods.
> Thanks,
> Sameer.
> --
> Message posted via http://www.sqlmonster.com
|||My SQL Server has SP3a.
I checked the MS Knowledge Base and it says that it fixes in SP3 but I
guess it didn't.
More info on the logs: -
2005-04-18 06:59:03.41
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0x6719d1c0, EC = 0x6719d4e8
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\
SQLDump0213.txt
* ************************************************** *****************************
*
* BEGIN STACK DUMP:
* 04/18/05 06:59:03 spid 55
*
* ex_terminator - Last chance exception handling
*
*** Unable to print input buffer - buffer changing location or not found ***
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E6EFFF 0005f000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 24350000 2439EFFF 0004f000
* Secur32 7C340000 7C34EFFF 0000f000
* NTDSAPI 243A0000 243B0FFF 00011000
* DNSAPI 243C0000 243E3FFF 00024000
* WSOCK32 243F0000 243F7FFF 00008000
* WS2_32 24400000 24413FFF 00014000
* WS2HELP 24420000 24427FFF 00008000
* WLDAP32 24430000 24459FFF 0002a000
* NETRAP 24460000 24465FFF 00006000
* SAMLIB 24470000 2447EFFF 0000f000
* ole32 245A0000 2468EFFF 000ef000
* XOLEHLP 24790000 24797FFF 00008000
* MSDTCPRX 247A0000 24856FFF 000b7000
* MTXCLU 24860000 2486FFFF 00010000
* VERSION 24870000 24876FFF 00007000
* LZ32 24880000 24885FFF 00006000
* CLUSAPI 24890000 2489FFFF 00010000
* RESUTILS 248A0000 248ACFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* rnr20 782C0000 782CBFFF 0000c000
* iphlpapi 248B0000 248C2FFF 00013000
* ICMP 248D0000 248D4FFF 00005000
* MPRAPI 248E0000 248F6FFF 00017000
* OLEAUT32 24900000 2499AFFF 0009b000
* ACTIVEDS 249A0000 249CEFFF 0002f000
* ADSLDPC 249D0000 249F2FFF 00023000
* RTUTILS 24A00000 24A0DFFF 0000e000
* SETUPAPI 24A10000 24A9DFFF 0008e000
* RASAPI32 24AA0000 24AD2FFF 00033000
* RASMAN 24AE0000 24AF0FFF 00011000
* TAPI32 24B00000 24B21FFF 00022000
* COMCTL32 24B30000 24BB3FFF 00084000
* SHLWAPI 24BC0000 24C25FFF 00066000
* DHCPCSVC 24C30000 24C48FFF 00019000
* winrnr 250F0000 250F7FFF 00008000
* rasadhlp 25100000 25104FFF 00005000
* SSNETLIB 258C0000 258D4FFF 00015000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 25C20000 25C23FFF 00004000
* msafd 25E30000 25E4DFFF 0001e000
* wshtcpip 25E50000 25E56FFF 00007000
* SSmsLPCn 25EE0000 25EE6FFF 00007000
* SQLFTQRY 41020000 41051FFF 00032000
* CLBCATQ 26770000 267FFFFF 00090000
* sqloledb 26810000 26882FFF 00073000
* MSDART 26890000 268AEFFF 0001f000
* comdlg32 268B0000 268EDFFF 0003e000
* SHELL32 782F0000 78534FFF 00245000
* MSDATL3 268F0000 26904FFF 00015000
* oledb32 26C10000 26C75FFF 00066000
* OLEDB32R 26C80000 26C8FFFF 00010000
* msv1_0 26D30000 26D50FFF 00021000
* CRYPT32 7C740000 7C7C6FFF 00087000
* MSASN1 26D60000 26D6FFFF 00010000
* xpsqlbot 26D80000 26D85FFF 00006000
* xpstar 410F0000 41136FFF 00047000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 26DB0000 26DC6FFF 00017000
* ODBC32 26DD0000 26E01FFF 00032000
* odbcbcp 26E10000 26E15FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 10000000 1002CFFF 0002d000
* WINSPOOL 10030000 1004DFFF 0001e000
* MPR 10050000 1005FFFF 00010000
* SHFOLDER 10060000 10067FFF 00008000
* odbcint 10170000 10185FFF 00016000
* NDDEAPI 10190000 10196FFF 00007000
* SQLSVC 101A0000 101A5FFF 00006000
* xpstar 101B0000 101B8FFF 00009000
* rsabase 7CA00000 7CA22FFF 00023000
* msdasql 02FB0000 02FF9FFF 0004a000
* MSDASQLR 03000000 03003FFF 00004000
* COMSVCS 78740000 788AEFFF 0016f000
* TxfAux 03090000 030F3FFF 00064000
* w3odbcci 03280000 032C8FFF 00049000
* CTL3D32 032D0000 032E0FFF 00011000
* pscore 032F0000 0332EFFF 0003f000
* W3CLNRES 03340000 03348FFF 00009000
* W3CLNRSX 03350000 03358FFF 00009000
* odbccp32 033E0000 033F8FFF 00019000
* W3CSM100 03400000 03411FFF 00012000
* pscl 03420000 034A6FFF 00087000
* MSVCP60 780C0000 78120FFF 00061000
* w3scmv7 034C0000 034D0FFF 00011000
* W3AIF10C 034F0000 03515FFF 00026000
* W3NSL244 11400000 1142CFFF 0002d000
* W3ENC107 03540000 03718FFF 001d9000
* clientrb 03830000 0383EFFF 0000f000
* MSWSOCK 03840000 03851FFF 00012000
* w3csp100 03960000 0396FFFF 00010000
* msadce 03A70000 03ABAFFF 0004b000
* mswstr10 03AC0000 03B54FFF 00095000
* msadcer 03F70000 03F74FFF 00005000
* xplog70 03F80000 03F91FFF 00012000
* xplog70 03FA0000 03FA3FFF 00004000
* kerberos 78280000 782B5FFF 00036000
* CRYPTDLL 08090000 0809DFFF 0000e000
* DBNETLIB 0D520000 0D52EFFF 0000f000
* SQLOLEDB 0D570000 0D57EFFF 0000f000
* dbghelp 01890000 01944FFF 000b5000
*
* Edi: 6719D4E8: 6719D1C0 6719D4EC 6719D4EC 56489C38 661CD5F8
66816030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: 6719D1C0: 00060037 00000000 0071D9B7 0000963A 00000000
00000000
* Ecx: 01BDB200: 00000000 0001003F 00000000 00000000 00000000
00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
64F04D8B
* Ebp: 01BDB1E4: 01BDBA04 0087C41F 6719D1C0 00AD8624 78032B18
00000000
* SegCs: 0000001B:
* EFlags: 00010246: 00740061 003D0068 003A0043 0050005C 00530056
005C0057
* Esp: 01BDB1B8: 6719D4E8 00000000 6719D1C0 01BDB200 6719D000
01BDB1B8
* SegSs: 00000023:
* ************************************************** *****************************
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 009318AF Module(sqlservr+005318AF) (ex_terminator+00000035)
* 78006942 Module(MSVCRT+00006942) (terminate+00000043)
* 7800686A Module(MSVCRT+0000686A) (_unDNameEx+000006FE)
* 7800699E Module(MSVCRT+0000699E) (abort+00000050)
* 780071B7 Module(MSVCRT+000071B7) (_CxxFrameHandler+00000026)
* 77F96BA7 Module(ntdll+00016BA7) (ZwSetIoCompletion+00000182)
* 77F96D67 Module(ntdll+00016D67) (RtlUnwind+000000DC)
* 7800716A Module(MSVCRT+0000716A) (CxxThrowException+00000096)
* 78006C3C Module(MSVCRT+00006C3C) (abort+000002EE)
* 78006B7C Module(MSVCRT+00006B7C) (abort+0000022E)
* 780069FB Module(MSVCRT+000069FB) (abort+000000AD)
* 7800735D Module(MSVCRT+0000735D) (_CxxLongjmpUnwind+00000196)
* 77F96BA7 Module(ntdll+00016BA7) (ZwSetIoCompletion+00000182)
* 77F96C42 Module(ntdll+00016C42) (ZwSetIoCompletion+0000021D)
* 77F9FF6E Module(ntdll+0001FF6E) (KiUserExceptionDispatcher+0000000E)
* 78007108 Module(MSVCRT+00007108) (CxxThrowException+00000034)
* 00488749 Module(sqlservr+00088749) (SetEcFlagAndThrow+00000026)
* 004886C2 Module(sqlservr+000886C2) (ex_raise2+00000396)
* 00931CD9 Module(sqlservr+00531CD9) (ex_raisecontrol+00000080)
* 0093141A Module(sqlservr+0053141A) (ex_trans_cexcept+000001FE)
* 780072DC Module(MSVCRT+000072DC) (_CxxLongjmpUnwind+00000115)
* 78006FCA Module(MSVCRT+00006FCA) (abort+0000067C)
* 78006BA7 Module(MSVCRT+00006BA7) (abort+00000259)
* 780069FB Module(MSVCRT+000069FB) (abort+000000AD)
* 780071B7 Module(MSVCRT+000071B7) (_CxxFrameHandler+00000026)
* 77F96BA7 Module(ntdll+00016BA7) (ZwSetIoCompletion+00000182)
* 77F96C42 Module(ntdll+00016C42) (ZwSetIoCompletion+0000021D)
* 77F9FF6E Module(ntdll+0001FF6E) (KiUserExceptionDispatcher+0000000E)
* 0057E8A9 Module(sqlservr+0017E8A9)
(CCursorDeclareStmt::XretExecute+00000555)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 005EFFC0 Module(sqlservr+001EFFC0) (SpPrepExec+00000313)
* 00591A0A Module(sqlservr+00191A0A) (SPCursor::CursorExecPrepExec+0000005D)
* 00591C3D Module(sqlservr+00191C3D) (SPCursor::PrepExec+0000002D)
* 005F142F Module(sqlservr+001F142F) (CSpecProc::ExecuteSpecial+000000B3)
* 005F1988 Module(sqlservr+001F1988) (CSpecProc::Execute+000000B6)
* 0061353F Module(sqlservr+0021353F) (execrpc+000004A6)
* 0043816D Module(sqlservr+0003816D) (execute_rpc+00000019)
* 00427001 Module(sqlservr+00027001) (process_commands+00000232)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ---
2005-04-18 06:59:03.40
SQL Server Assertion: File: <p:\sql\ntdbms\cursors\src\ccursor.cpp>,
line=850
Failed Assertion = 'fFalse'.
2005-04-18 06:58:59.59
SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* ************************************************** *****************************
*
* BEGIN STACK DUMP:
* 04/18/05 06:58:59 spid 55
*
* Exception Address = 327B0080
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 327B0080
*** Unable to print input buffer - buffer changing location or not found ***
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E6EFFF 0005f000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 24350000 2439EFFF 0004f000
* Secur32 7C340000 7C34EFFF 0000f000
* NTDSAPI 243A0000 243B0FFF 00011000
* DNSAPI 243C0000 243E3FFF 00024000
* WSOCK32 243F0000 243F7FFF 00008000
* WS2_32 24400000 24413FFF 00014000
* WS2HELP 24420000 24427FFF 00008000
* WLDAP32 24430000 24459FFF 0002a000
* NETRAP 24460000 24465FFF 00006000
* SAMLIB 24470000 2447EFFF 0000f000
* ole32 245A0000 2468EFFF 000ef000
* XOLEHLP 24790000 24797FFF 00008000
* MSDTCPRX 247A0000 24856FFF 000b7000
* MTXCLU 24860000 2486FFFF 00010000
* VERSION 24870000 24876FFF 00007000
* LZ32 24880000 24885FFF 00006000
* CLUSAPI 24890000 2489FFFF 00010000
* RESUTILS 248A0000 248ACFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* rnr20 782C0000 782CBFFF 0000c000
* iphlpapi 248B0000 248C2FFF 00013000
* ICMP 248D0000 248D4FFF 00005000
* MPRAPI 248E0000 248F6FFF 00017000
* OLEAUT32 24900000 2499AFFF 0009b000
* ACTIVEDS 249A0000 249CEFFF 0002f000
* ADSLDPC 249D0000 249F2FFF 00023000
* RTUTILS 24A00000 24A0DFFF 0000e000
* SETUPAPI 24A10000 24A9DFFF 0008e000
* RASAPI32 24AA0000 24AD2FFF 00033000
* RASMAN 24AE0000 24AF0FFF 00011000
* TAPI32 24B00000 24B21FFF 00022000
* COMCTL32 24B30000 24BB3FFF 00084000
* SHLWAPI 24BC0000 24C25FFF 00066000
* DHCPCSVC 24C30000 24C48FFF 00019000
* winrnr 250F0000 250F7FFF 00008000
* rasadhlp 25100000 25104FFF 00005000
* SSNETLIB 258C0000 258D4FFF 00015000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 25C20000 25C23FFF 00004000
* msafd 25E30000 25E4DFFF 0001e000
* wshtcpip 25E50000 25E56FFF 00007000
* SSmsLPCn 25EE0000 25EE6FFF 00007000
* SQLFTQRY 41020000 41051FFF 00032000
* CLBCATQ 26770000 267FFFFF 00090000
* sqloledb 26810000 26882FFF 00073000
* MSDART 26890000 268AEFFF 0001f000
* comdlg32 268B0000 268EDFFF 0003e000
* SHELL32 782F0000 78534FFF 00245000
* MSDATL3 268F0000 26904FFF 00015000
* oledb32 26C10000 26C75FFF 00066000
* OLEDB32R 26C80000 26C8FFFF 00010000
* msv1_0 26D30000 26D50FFF 00021000
* CRYPT32 7C740000 7C7C6FFF 00087000
* MSASN1 26D60000 26D6FFFF 00010000
* xpsqlbot 26D80000 26D85FFF 00006000
* xpstar 410F0000 41136FFF 00047000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 26DB0000 26DC6FFF 00017000
* ODBC32 26DD0000 26E01FFF 00032000
* odbcbcp 26E10000 26E15FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 10000000 1002CFFF 0002d000
* WINSPOOL 10030000 1004DFFF 0001e000
* MPR 10050000 1005FFFF 00010000
* SHFOLDER 10060000 10067FFF 00008000
* odbcint 10170000 10185FFF 00016000
* NDDEAPI 10190000 10196FFF 00007000
* SQLSVC 101A0000 101A5FFF 00006000
* xpstar 101B0000 101B8FFF 00009000
* rsabase 7CA00000 7CA22FFF 00023000
* msdasql 02FB0000 02FF9FFF 0004a000
* MSDASQLR 03000000 03003FFF 00004000
* COMSVCS 78740000 788AEFFF 0016f000
* TxfAux 03090000 030F3FFF 00064000
* w3odbcci 03280000 032C8FFF 00049000
* CTL3D32 032D0000 032E0FFF 00011000
* pscore 032F0000 0332EFFF 0003f000
* W3CLNRES 03340000 03348FFF 00009000
* W3CLNRSX 03350000 03358FFF 00009000
* odbccp32 033E0000 033F8FFF 00019000
* W3CSM100 03400000 03411FFF 00012000
* pscl 03420000 034A6FFF 00087000
* MSVCP60 780C0000 78120FFF 00061000
* w3scmv7 034C0000 034D0FFF 00011000
* W3AIF10C 034F0000 03515FFF 00026000
* W3NSL244 11400000 1142CFFF 0002d000
* W3ENC107 03540000 03718FFF 001d9000
* clientrb 03830000 0383EFFF 0000f000
* MSWSOCK 03840000 03851FFF 00012000
* w3csp100 03960000 0396FFFF 00010000
* msadce 03A70000 03ABAFFF 0004b000
* mswstr10 03AC0000 03B54FFF 00095000
* msadcer 03F70000 03F74FFF 00005000
* xplog70 03F80000 03F91FFF 00012000
* xplog70 03FA0000 03FA3FFF 00004000
* kerberos 78280000 782B5FFF 00036000
* CRYPTDLL 08090000 0809DFFF 0000e000
* DBNETLIB 0D520000 0D52EFFF 0000f000
* SQLOLEDB 0D570000 0D57EFFF 0000f000
* dbghelp 00BF0000 00CA4FFF 000b5000
*
* Edi: 00000000:
* Esi: 604F8670: 604F86F2 00000000 00000000 00000000 604F8020
604F8ED8
* Eax: 604F8EF0: 00992A72 00992A60 00992A50 00992A38 00992A24
00992A04
* Ebx: 00000000:
* Ecx: 00992A72: 28C60080 65380042 64BA0042 64E70080 327B0080
E8300080
* Edx: 00000000:
* Eip: 327B0080:
* Ebp: 01BDEDFC: 01BDEFD8 0057E8A9 604FC068 009AA108 00000000
00000000
* SegCs: 0000001B:
* EFlags: 00010246: 00740061 003D0068 003A0043 0050005C 00530056
005C0057
* Esp: 01BDED84: 005819E1 604F8EF0 00000000 00000000 00000001
604F8068
* SegSs: 00000023:
* ************************************************** *****************************
* ----
* Short Stack Dump
* 327B0080 Module(UNKNOWN+00000000)
* 005819E1 Module(sqlservr+001819E1) (CCursorTableScan::WakeUp+00000018)
* 00581FC4 Module(sqlservr+00181FC4) (CCursor::InitFromCache+0000015A)
* 00581E64 Module(sqlservr+00181E64) (CCursor::InitFromCache+0000000A)
* ---
Message posted via http://www.sqlmonster.com
|||It looks like it might be this:
FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on
CStmtCond::XretExecute
http://support.microsoft.com/default...b;en-us;824027
I would definitely call PSS and open a support call. You will need to open
a call anyway to obtain the hotfix associated with this KB article.
Geoff N. Hiten
Microsoft SQL Server MVP
"Sameer Premji via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d53b94836e8543e8ae8f5237f22fe978@.SQLMonster.c om...
> My SQL Server has SP3a.
> I checked the MS Knowledge Base and it says that it fixes in SP3 but I
> guess it didn't.
> More info on the logs: -
>
> 2005-04-18 06:59:03.41
> --
> Using 'dbghelp.dll' version '4.0.5'
> *Dump thread - spid = 55, PSS = 0x6719d1c0, EC = 0x6719d4e8
> *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\
> SQLDump0213.txt
> *
> ************************************************** *****************************
> *
> * BEGIN STACK DUMP:
> * 04/18/05 06:59:03 spid 55
> *
> * ex_terminator - Last chance exception handling
> *
> *** Unable to print input buffer - buffer changing location or not found
> ***
> *
> * MODULE BASE END SIZE
> * sqlservr 00400000 00B2CFFF 0072d000
> * ntdll 77F80000 77FFCFFF 0007d000
> * KERNEL32 7C570000 7C622FFF 000b3000
> * ADVAPI32 7C2D0000 7C331FFF 00062000
> * RPCRT4 77D30000 77DA0FFF 00071000
> * USER32 77E10000 77E6EFFF 0005f000
> * GDI32 77F40000 77F7AFFF 0003b000
> * OPENDS60 41060000 41065FFF 00006000
> * MSVCRT 78000000 78044FFF 00045000
> * UMS 41070000 4107CFFF 0000d000
> * SQLSORT 42AE0000 42B6FFFF 00090000
> * MSVCIRT 780A0000 780B1FFF 00012000
> * sqlevn70 41080000 41086FFF 00007000
> * NETAPI32 24350000 2439EFFF 0004f000
> * Secur32 7C340000 7C34EFFF 0000f000
> * NTDSAPI 243A0000 243B0FFF 00011000
> * DNSAPI 243C0000 243E3FFF 00024000
> * WSOCK32 243F0000 243F7FFF 00008000
> * WS2_32 24400000 24413FFF 00014000
> * WS2HELP 24420000 24427FFF 00008000
> * WLDAP32 24430000 24459FFF 0002a000
> * NETRAP 24460000 24465FFF 00006000
> * SAMLIB 24470000 2447EFFF 0000f000
> * ole32 245A0000 2468EFFF 000ef000
> * XOLEHLP 24790000 24797FFF 00008000
> * MSDTCPRX 247A0000 24856FFF 000b7000
> * MTXCLU 24860000 2486FFFF 00010000
> * VERSION 24870000 24876FFF 00007000
> * LZ32 24880000 24885FFF 00006000
> * CLUSAPI 24890000 2489FFFF 00010000
> * RESUTILS 248A0000 248ACFFF 0000d000
> * USERENV 7C0F0000 7C150FFF 00061000
> * rnr20 782C0000 782CBFFF 0000c000
> * iphlpapi 248B0000 248C2FFF 00013000
> * ICMP 248D0000 248D4FFF 00005000
> * MPRAPI 248E0000 248F6FFF 00017000
> * OLEAUT32 24900000 2499AFFF 0009b000
> * ACTIVEDS 249A0000 249CEFFF 0002f000
> * ADSLDPC 249D0000 249F2FFF 00023000
> * RTUTILS 24A00000 24A0DFFF 0000e000
> * SETUPAPI 24A10000 24A9DFFF 0008e000
> * RASAPI32 24AA0000 24AD2FFF 00033000
> * RASMAN 24AE0000 24AF0FFF 00011000
> * TAPI32 24B00000 24B21FFF 00022000
> * COMCTL32 24B30000 24BB3FFF 00084000
> * SHLWAPI 24BC0000 24C25FFF 00066000
> * DHCPCSVC 24C30000 24C48FFF 00019000
> * winrnr 250F0000 250F7FFF 00008000
> * rasadhlp 25100000 25104FFF 00005000
> * SSNETLIB 258C0000 258D4FFF 00015000
> * SSNMPN70 410D0000 410D5FFF 00006000
> * security 25C20000 25C23FFF 00004000
> * msafd 25E30000 25E4DFFF 0001e000
> * wshtcpip 25E50000 25E56FFF 00007000
> * SSmsLPCn 25EE0000 25EE6FFF 00007000
> * SQLFTQRY 41020000 41051FFF 00032000
> * CLBCATQ 26770000 267FFFFF 00090000
> * sqloledb 26810000 26882FFF 00073000
> * MSDART 26890000 268AEFFF 0001f000
> * comdlg32 268B0000 268EDFFF 0003e000
> * SHELL32 782F0000 78534FFF 00245000
> * MSDATL3 268F0000 26904FFF 00015000
> * oledb32 26C10000 26C75FFF 00066000
> * OLEDB32R 26C80000 26C8FFFF 00010000
> * msv1_0 26D30000 26D50FFF 00021000
> * CRYPT32 7C740000 7C7C6FFF 00087000
> * MSASN1 26D60000 26D6FFFF 00010000
> * xpsqlbot 26D80000 26D85FFF 00006000
> * xpstar 410F0000 41136FFF 00047000
> * SQLRESLD 42AC0000 42AC6FFF 00007000
> * SQLSVC 26DB0000 26DC6FFF 00017000
> * ODBC32 26DD0000 26E01FFF 00032000
> * odbcbcp 26E10000 26E15FFF 00006000
> * W95SCM 41140000 4114BFFF 0000c000
> * SQLUNIRL 10000000 1002CFFF 0002d000
> * WINSPOOL 10030000 1004DFFF 0001e000
> * MPR 10050000 1005FFFF 00010000
> * SHFOLDER 10060000 10067FFF 00008000
> * odbcint 10170000 10185FFF 00016000
> * NDDEAPI 10190000 10196FFF 00007000
> * SQLSVC 101A0000 101A5FFF 00006000
> * xpstar 101B0000 101B8FFF 00009000
> * rsabase 7CA00000 7CA22FFF 00023000
> * msdasql 02FB0000 02FF9FFF 0004a000
> * MSDASQLR 03000000 03003FFF 00004000
> * COMSVCS 78740000 788AEFFF 0016f000
> * TxfAux 03090000 030F3FFF 00064000
> * w3odbcci 03280000 032C8FFF 00049000
> * CTL3D32 032D0000 032E0FFF 00011000
> * pscore 032F0000 0332EFFF 0003f000
> * W3CLNRES 03340000 03348FFF 00009000
> * W3CLNRSX 03350000 03358FFF 00009000
> * odbccp32 033E0000 033F8FFF 00019000
> * W3CSM100 03400000 03411FFF 00012000
> * pscl 03420000 034A6FFF 00087000
> * MSVCP60 780C0000 78120FFF 00061000
> * w3scmv7 034C0000 034D0FFF 00011000
> * W3AIF10C 034F0000 03515FFF 00026000
> * W3NSL244 11400000 1142CFFF 0002d000
> * W3ENC107 03540000 03718FFF 001d9000
> * clientrb 03830000 0383EFFF 0000f000
> * MSWSOCK 03840000 03851FFF 00012000
> * w3csp100 03960000 0396FFFF 00010000
> * msadce 03A70000 03ABAFFF 0004b000
> * mswstr10 03AC0000 03B54FFF 00095000
> * msadcer 03F70000 03F74FFF 00005000
> * xplog70 03F80000 03F91FFF 00012000
> * xplog70 03FA0000 03FA3FFF 00004000
> * kerberos 78280000 782B5FFF 00036000
> * CRYPTDLL 08090000 0809DFFF 0000e000
> * DBNETLIB 0D520000 0D52EFFF 0000f000
> * SQLOLEDB 0D570000 0D57EFFF 0000f000
> * dbghelp 01890000 01944FFF 000b5000
> *
> * Edi: 6719D4E8: 6719D1C0 6719D4EC 6719D4EC 56489C38 661CD5F8
> 66816030
> * Esi: 00000000:
> * Eax: 00000000:
> * Ebx: 6719D1C0: 00060037 00000000 0071D9B7 0000963A 00000000
> 00000000
> * Ecx: 01BDB200: 00000000 0001003F 00000000 00000000 00000000
> 00000000
> * Edx: FFFFFFFF:
> * Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
> 64F04D8B
> * Ebp: 01BDB1E4: 01BDBA04 0087C41F 6719D1C0 00AD8624 78032B18
> 00000000
> * SegCs: 0000001B:
> * EFlags: 00010246: 00740061 003D0068 003A0043 0050005C 00530056
> 005C0057
> * Esp: 01BDB1B8: 6719D4E8 00000000 6719D1C0 01BDB200 6719D000
> 01BDB1B8
> * SegSs: 00000023:
> *
> ************************************************** *****************************
> * ----
> --
> * Short Stack Dump
> * 0087A90E Module(sqlservr+0047A90E)
> (CStackDump::GetContextAndDump+0000002E)
> * 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
> * 009318AF Module(sqlservr+005318AF) (ex_terminator+00000035)
> * 78006942 Module(MSVCRT+00006942) (terminate+00000043)
> * 7800686A Module(MSVCRT+0000686A) (_unDNameEx+000006FE)
> * 7800699E Module(MSVCRT+0000699E) (abort+00000050)
> * 780071B7 Module(MSVCRT+000071B7) (_CxxFrameHandler+00000026)
> * 77F96BA7 Module(ntdll+00016BA7) (ZwSetIoCompletion+00000182)
> * 77F96D67 Module(ntdll+00016D67) (RtlUnwind+000000DC)
> * 7800716A Module(MSVCRT+0000716A) (CxxThrowException+00000096)
> * 78006C3C Module(MSVCRT+00006C3C) (abort+000002EE)
> * 78006B7C Module(MSVCRT+00006B7C) (abort+0000022E)
> * 780069FB Module(MSVCRT+000069FB) (abort+000000AD)
> * 7800735D Module(MSVCRT+0000735D) (_CxxLongjmpUnwind+00000196)
> * 77F96BA7 Module(ntdll+00016BA7) (ZwSetIoCompletion+00000182)
> * 77F96C42 Module(ntdll+00016C42) (ZwSetIoCompletion+0000021D)
> * 77F9FF6E Module(ntdll+0001FF6E) (KiUserExceptionDispatcher+0000000E)
> * 78007108 Module(MSVCRT+00007108) (CxxThrowException+00000034)
> * 00488749 Module(sqlservr+00088749) (SetEcFlagAndThrow+00000026)
> * 004886C2 Module(sqlservr+000886C2) (ex_raise2+00000396)
> * 00931CD9 Module(sqlservr+00531CD9) (ex_raisecontrol+00000080)
> * 0093141A Module(sqlservr+0053141A) (ex_trans_cexcept+000001FE)
> * 780072DC Module(MSVCRT+000072DC) (_CxxLongjmpUnwind+00000115)
> * 78006FCA Module(MSVCRT+00006FCA) (abort+0000067C)
> * 78006BA7 Module(MSVCRT+00006BA7) (abort+00000259)
> * 780069FB Module(MSVCRT+000069FB) (abort+000000AD)
> * 780071B7 Module(MSVCRT+000071B7) (_CxxFrameHandler+00000026)
> * 77F96BA7 Module(ntdll+00016BA7) (ZwSetIoCompletion+00000182)
> * 77F96C42 Module(ntdll+00016C42) (ZwSetIoCompletion+0000021D)
> * 77F9FF6E Module(ntdll+0001FF6E) (KiUserExceptionDispatcher+0000000E)
> * 0057E8A9 Module(sqlservr+0017E8A9)
> (CCursorDeclareStmt::XretExecute+00000555)
> * 0041B442 Module(sqlservr+0001B442)
> (CMsqlExecContext::ExecuteStmts+000003B9)
> * 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
> * 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
> * 005EFFC0 Module(sqlservr+001EFFC0) (SpPrepExec+00000313)
> * 00591A0A Module(sqlservr+00191A0A)
> (SPCursor::CursorExecPrepExec+0000005D)
> * 00591C3D Module(sqlservr+00191C3D) (SPCursor::PrepExec+0000002D)
> * 005F142F Module(sqlservr+001F142F) (CSpecProc::ExecuteSpecial+000000B3)
> * 005F1988 Module(sqlservr+001F1988) (CSpecProc::Execute+000000B6)
> * 0061353F Module(sqlservr+0021353F) (execrpc+000004A6)
> * 0043816D Module(sqlservr+0003816D) (execute_rpc+00000019)
> * 00427001 Module(sqlservr+00027001) (process_commands+00000232)
> * 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
> * 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
> * 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
> * 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
> * ---
>
>
> 2005-04-18 06:59:03.40
> --
> SQL Server Assertion: File: <p:\sql\ntdbms\cursors\src\ccursor.cpp>,
> line=850
> Failed Assertion = 'fFalse'.
>
> 2005-04-18 06:58:59.59
> --
> SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
> *
> ************************************************** *****************************
> *
> * BEGIN STACK DUMP:
> * 04/18/05 06:58:59 spid 55
> *
> * Exception Address = 327B0080
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 327B0080
> *** Unable to print input buffer - buffer changing location or not found
> ***
> *
> * MODULE BASE END SIZE
> * sqlservr 00400000 00B2CFFF 0072d000
> * ntdll 77F80000 77FFCFFF 0007d000
> * KERNEL32 7C570000 7C622FFF 000b3000
> * ADVAPI32 7C2D0000 7C331FFF 00062000
> * RPCRT4 77D30000 77DA0FFF 00071000
> * USER32 77E10000 77E6EFFF 0005f000
> * GDI32 77F40000 77F7AFFF 0003b000
> * OPENDS60 41060000 41065FFF 00006000
> * MSVCRT 78000000 78044FFF 00045000
> * UMS 41070000 4107CFFF 0000d000
> * SQLSORT 42AE0000 42B6FFFF 00090000
> * MSVCIRT 780A0000 780B1FFF 00012000
> * sqlevn70 41080000 41086FFF 00007000
> * NETAPI32 24350000 2439EFFF 0004f000
> * Secur32 7C340000 7C34EFFF 0000f000
> * NTDSAPI 243A0000 243B0FFF 00011000
> * DNSAPI 243C0000 243E3FFF 00024000
> * WSOCK32 243F0000 243F7FFF 00008000
> * WS2_32 24400000 24413FFF 00014000
> * WS2HELP 24420000 24427FFF 00008000
> * WLDAP32 24430000 24459FFF 0002a000
> * NETRAP 24460000 24465FFF 00006000
> * SAMLIB 24470000 2447EFFF 0000f000
> * ole32 245A0000 2468EFFF 000ef000
> * XOLEHLP 24790000 24797FFF 00008000
> * MSDTCPRX 247A0000 24856FFF 000b7000
> * MTXCLU 24860000 2486FFFF 00010000
> * VERSION 24870000 24876FFF 00007000
> * LZ32 24880000 24885FFF 00006000
> * CLUSAPI 24890000 2489FFFF 00010000
> * RESUTILS 248A0000 248ACFFF 0000d000
> * USERENV 7C0F0000 7C150FFF 00061000
> * rnr20 782C0000 782CBFFF 0000c000
> * iphlpapi 248B0000 248C2FFF 00013000
> * ICMP 248D0000 248D4FFF 00005000
> * MPRAPI 248E0000 248F6FFF 00017000
> * OLEAUT32 24900000 2499AFFF 0009b000
> * ACTIVEDS 249A0000 249CEFFF 0002f000
> * ADSLDPC 249D0000 249F2FFF 00023000
> * RTUTILS 24A00000 24A0DFFF 0000e000
> * SETUPAPI 24A10000 24A9DFFF 0008e000
> * RASAPI32 24AA0000 24AD2FFF 00033000
> * RASMAN 24AE0000 24AF0FFF 00011000
> * TAPI32 24B00000 24B21FFF 00022000
> * COMCTL32 24B30000 24BB3FFF 00084000
> * SHLWAPI 24BC0000 24C25FFF 00066000
> * DHCPCSVC 24C30000 24C48FFF 00019000
> * winrnr 250F0000 250F7FFF 00008000
> * rasadhlp 25100000 25104FFF 00005000
> * SSNETLIB 258C0000 258D4FFF 00015000
> * SSNMPN70 410D0000 410D5FFF 00006000
> * security 25C20000 25C23FFF 00004000
> * msafd 25E30000 25E4DFFF 0001e000
> * wshtcpip 25E50000 25E56FFF 00007000
> * SSmsLPCn 25EE0000 25EE6FFF 00007000
> * SQLFTQRY 41020000 41051FFF 00032000
> * CLBCATQ 26770000 267FFFFF 00090000
> * sqloledb 26810000 26882FFF 00073000
> * MSDART 26890000 268AEFFF 0001f000
> * comdlg32 268B0000 268EDFFF 0003e000
> * SHELL32 782F0000 78534FFF 00245000
> * MSDATL3 268F0000 26904FFF 00015000
> * oledb32 26C10000 26C75FFF 00066000
> * OLEDB32R 26C80000 26C8FFFF 00010000
> * msv1_0 26D30000 26D50FFF 00021000
> * CRYPT32 7C740000 7C7C6FFF 00087000
> * MSASN1 26D60000 26D6FFFF 00010000
> * xpsqlbot 26D80000 26D85FFF 00006000
> * xpstar 410F0000 41136FFF 00047000
> * SQLRESLD 42AC0000 42AC6FFF 00007000
> * SQLSVC 26DB0000 26DC6FFF 00017000
> * ODBC32 26DD0000 26E01FFF 00032000
> * odbcbcp 26E10000 26E15FFF 00006000
> * W95SCM 41140000 4114BFFF 0000c000
> * SQLUNIRL 10000000 1002CFFF 0002d000
> * WINSPOOL 10030000 1004DFFF 0001e000
> * MPR 10050000 1005FFFF 00010000
> * SHFOLDER 10060000 10067FFF 00008000
> * odbcint 10170000 10185FFF 00016000
> * NDDEAPI 10190000 10196FFF 00007000
> * SQLSVC 101A0000 101A5FFF 00006000
> * xpstar 101B0000 101B8FFF 00009000
> * rsabase 7CA00000 7CA22FFF 00023000
> * msdasql 02FB0000 02FF9FFF 0004a000
> * MSDASQLR 03000000 03003FFF 00004000
> * COMSVCS 78740000 788AEFFF 0016f000
> * TxfAux 03090000 030F3FFF 00064000
> * w3odbcci 03280000 032C8FFF 00049000
> * CTL3D32 032D0000 032E0FFF 00011000
> * pscore 032F0000 0332EFFF 0003f000
> * W3CLNRES 03340000 03348FFF 00009000
> * W3CLNRSX 03350000 03358FFF 00009000
> * odbccp32 033E0000 033F8FFF 00019000
> * W3CSM100 03400000 03411FFF 00012000
> * pscl 03420000 034A6FFF 00087000
> * MSVCP60 780C0000 78120FFF 00061000
> * w3scmv7 034C0000 034D0FFF 00011000
> * W3AIF10C 034F0000 03515FFF 00026000
> * W3NSL244 11400000 1142CFFF 0002d000
> * W3ENC107 03540000 03718FFF 001d9000
> * clientrb 03830000 0383EFFF 0000f000
> * MSWSOCK 03840000 03851FFF 00012000
> * w3csp100 03960000 0396FFFF 00010000
> * msadce 03A70000 03ABAFFF 0004b000
> * mswstr10 03AC0000 03B54FFF 00095000
> * msadcer 03F70000 03F74FFF 00005000
> * xplog70 03F80000 03F91FFF 00012000
> * xplog70 03FA0000 03FA3FFF 00004000
> * kerberos 78280000 782B5FFF 00036000
> * CRYPTDLL 08090000 0809DFFF 0000e000
> * DBNETLIB 0D520000 0D52EFFF 0000f000
> * SQLOLEDB 0D570000 0D57EFFF 0000f000
> * dbghelp 00BF0000 00CA4FFF 000b5000
> *
> * Edi: 00000000:
> * Esi: 604F8670: 604F86F2 00000000 00000000 00000000 604F8020
> 604F8ED8
> * Eax: 604F8EF0: 00992A72 00992A60 00992A50 00992A38 00992A24
> 00992A04
> * Ebx: 00000000:
> * Ecx: 00992A72: 28C60080 65380042 64BA0042 64E70080 327B0080
> E8300080
> * Edx: 00000000:
> * Eip: 327B0080:
> * Ebp: 01BDEDFC: 01BDEFD8 0057E8A9 604FC068 009AA108 00000000
> 00000000
> * SegCs: 0000001B:
> * EFlags: 00010246: 00740061 003D0068 003A0043 0050005C 00530056
> 005C0057
> * Esp: 01BDED84: 005819E1 604F8EF0 00000000 00000000 00000001
> 604F8068
> * SegSs: 00000023:
> *
> ************************************************** *****************************
> * ----
> --
> * Short Stack Dump
> * 327B0080 Module(UNKNOWN+00000000)
> * 005819E1 Module(sqlservr+001819E1) (CCursorTableScan::WakeUp+00000018)
> * 00581FC4 Module(sqlservr+00181FC4) (CCursor::InitFromCache+0000015A)
> * 00581E64 Module(sqlservr+00181E64) (CCursor::InitFromCache+0000000A)
> * ---
> --
> Message posted via http://www.sqlmonster.com
|||Thank you so much for your guidance.
Pardon my ignorance but what is PSS and what is their phone number in
Canada ?
Thanks,
Sameer.
Message posted via http://www.sqlmonster.com
|||No problems. We all start out ignorant. You seem determined to change.

PSS is shorthand for Product Support Services, Microsoft's customer support
organization. They offer several methods for support, including a
pay-per-incident telephone option that may be what you need.
Go to http://support.microsoft.com/ and select Assisted support. Follow the
menus (Canada is there with both French and English) until you get to the
options and price page which also has the phone numbers. Under certain
conditions, you may get a refund but be prepared to pay for the support call
regardless.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Sameer Premji via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:78d1d1471af54229982b414c3b6bd247@.SQLMonster.c om...
> Thank you so much for your guidance.
> Pardon my ignorance but what is PSS and what is their phone number in
> Canada ?
> Thanks,
> Sameer.
> --
> Message posted via http://www.sqlmonster.com
sql

Thursday, March 29, 2012

Field names must be CLS-compliant identifiers.

Tuesday, March 27, 2012

Field Error

Monday, March 26, 2012

Fetch within a fetch

fetch successful resultset after exception

Friday, March 23, 2012

Feedback on Merge Replication Error

Wednesday, March 21, 2012

fcb::ZeroFile(): GetOverLappedResult() failed with error 27.

fcb::ZeroFile(): GetOverLappedResult() failed with error 27.

fcb::ZeroFile(): GetOverLappedResult() failed with error 27.

Fatal System Error

Fatal Network Error 4014 when writing big BLOB chunks

Fatal Exception in SQL Server

Fatal Exception in SQL Server

Fatal Exception in SQL Server

Fatal exception error in MSSQL2005 SP1

Fatal exception error in MSSQL2005 SP1

Fatal exception error in mSSQL 2000 sp4

Fatal exception error in mSSQL 2000 sp3 and sp4

Fatal exception error in mSSQL 2000 sp3 and sp4

Fatal Exception Error

Footer rows to skip

Blog Archive

About Me