Solved

xp_sendmail SqlDumpExceptionHandler

Posted on 2004-10-14
13
725 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:edi02
Comment Utility
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
Comment Utility
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
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 34

Accepted Solution

by:
arbert earned 125 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
What version of Outlook is it?
0
 

Author Comment

by:edi02
Comment Utility
I don't know
0
 

Author Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now