Solved

xp_sendmail SqlDumpExceptionHandler

Posted on 2004-10-14
13
734 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 

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 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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

710 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