Solved

xp_sendmail SqlDumpExceptionHandler

Posted on 2004-10-14
13
732 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

740 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