Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

xp_sendmail SqlDumpExceptionHandler

Posted on 2004-10-14
13
Medium Priority
?
756 Views
Last Modified: 2008-01-09
I'm getting the following problem when running xp_sendmail...

DESCRIPTION:      Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 66 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

I get this error message via an email.  A reboot cures this
problem for a day or two (i.e. xp_sendmail works ok) and then the problem
reoccurs.

Running SQL 2000 SP3

Anybody got any ideas?
0
Comment
Question by:edi02
  • 9
  • 4
13 Comments
 

Author Comment

by:edi02
ID: 12315831
I forgot to tell that xp_sendmail is set to run from a stored procedure which is triggered from a job.
0
 
LVL 34

Expert Comment

by:arbert
ID: 12315853
are you using an exchange server?  Post the proc you're using to call xp_sendmail....

When you get the exception error, can you still execute xp_sendmail from query analyzer, or do all calls to xp_sendmail generate the error?
0
 

Author Comment

by:edi02
ID: 12316069
Actually I use to receive this error 2 or 3 times a day and after receiving the error xp_sendmail still work. But sometimes after 2 or more errors the job is stuck at this xp_sendmail and then another xp_sendmail is not working anymore (nor from querry analyzer, nor DTS) and even the job itself cannot be stopped. So my only solution is to bouce the server, and then for another day or two everithing works fine. And then again...

Now the SP. I use a generic SP to send emails (spr_utl_notify) wich one use xp_sendmail:

CREATE  procedure spr_utl_notify
 @user          varchar(80)
,@tran_name          varchar(40)
,@subject          varchar(100)
,@tran_number       varchar(10)   = null
,@message            varchar(1000) = null
,@file_nm       varchar(1000) = null
as

......



exec master.dbo.xp_sendmail
    @recipients = @RECIPIENTS
   ,@message = @message
   ,@subject = @subject
   ,@width = 500
   ,@echo_error = 'true'
   ,@dbuse = @DATABASE
   ,@attachments = @file_nm

and this one I call any time is necessary from the main SP in my job (spr_main)

Yes, we are using an exchange server.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:edi02
ID: 12316105
Actually there are 2 jobs they are running every minute and they are using different SP but both of them use to send emails. So this error occurs sometimes to one of them other times to the next one (there is no rule in which of them error occurs).
0
 
LVL 34

Expert Comment

by:arbert
ID: 12316130
Just trying to narrow down.  What version of Outlook did you use to install the Mapi profile?  When you get the error, can you logon with the SQLAgent user and open outlook and connect successfully to exchange?
0
 

Author Comment

by:edi02
ID: 12316214
Unfortunatelly I'm not the DBA so I have a limited knowledge and access to this stuff. I will have to ask the DBA or SA but they will be reluctunt to answer my questions.

0
 
LVL 34

Accepted Solution

by:
arbert earned 375 total points
ID: 12316266
That's too bad your DBAs can't be more accomodating, I think it would be a good idea to see if there is still connectivity between exchange and sql when this happens (ie, opening outlook).

Have you looked at these articles?

http://support.microsoft.com/default.aspx?scid=kb;en-us;839405
http://support.microsoft.com/default.aspx?scid=kb;en-us;821548
0
 

Author Comment

by:edi02
ID: 12316271
I've sent your previous question to the DBA. Hope will answer :)
I will have a look above links.
I will keep you informed when I will receive his answer.
0
 

Author Comment

by:edi02
ID: 12316318
Don't think is the second link because I have a different dump:

 BEGIN STACK DUMP:
*   10/13/04 11:51:04 spid 114
*
*   Exception Address = 09357E58 (ScInitMapiUtil + 00001497 Line 0+00000000)
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred writing address 00000020

or
 BEGIN STACK DUMP:
*   10/15/04 08:40:10 spid 79
*
*   Exception Address = 77F99C32 (ZwSetTimerResolution + 0000229E Line 0+00000000)
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred writing address 09C5FF80

or

 BEGIN STACK DUMP:
*   10/15/04 11:53:09 spid 60
*
*   Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line 0+00000000)
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred reading address 07AAFF90
0
 

Author Comment

by:edi02
ID: 12316321
I have an answer from SA for you previous question:

Yes I can log in as the service account and send emails, so it does look like it’s localised to SQL Server in some way.
0
 
LVL 34

Expert Comment

by:arbert
ID: 12334063
What version of Outlook is it?
0
 

Author Comment

by:edi02
ID: 12335377
I don't know
0
 

Author Comment

by:edi02
ID: 12357216
Not fixed yet but I will give you the points because, at least, you've done a try to help me.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question