Solved

xp_sendmail SqlDumpExceptionHandler

Posted on 2004-10-14
13
727 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
 

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 34

Accepted Solution

by:
arbert earned 125 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

864 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

24 Experts available now in Live!

Get 1:1 Help Now