DatabaseMail.exe Event Name: APPCRASH Debugger could not be started because no user is logged on

• lsalih

  SSCertifiable

  Points: 6143

  More actions

  February 10, 2016 at 9:04 am

  #311331

  We have 2 Mail profiles set to send alters in SQL, one is default and used by the agent, and the second one is for user type alerts (each got different sequence_number). Every now and then, the databasemail.exe crashed only during when an alert is fired from the second profile. We get the following msg. This only happens when the system is trying to send an email using the second profile, a lot of times it works but sometimes it does not work thus we do not get the email. Any idea how to auto start databasemail.exe if APPCRASH happens or how to go about this issue to resolve it?!

  Error:

  "An unhandled exception ('System.IO.FileNotFoundException') occurred in DatabaseMail.exe [97548]. Just-In-Time debugging this exception failed with the following error: Debugger could not be started because no user is logged on."

  Faulting application name: DatabaseMail.exe, version: 11.0.2100.60, time stamp: 0x4f35e1a1

  Faulting module name: KERNELBASE.dll, version: 6.1.7601.23250, time stamp: 0x562593c7

  Exception code: 0xe0434f4d

  Fault offset: 0x000000000000adcd

  Faulting process id: 0x%9

  Faulting application start time: 0x%10

  Faulting application path: %11

  Faulting module path: %12

  Report Id: %13

  LoadedModule[59]=C:\Windows\system32\apphelp.dll

  FriendlyEventName=APPCRASH

  ConsentKey=APPCRASH

  AppName=Database Mail engine

  AppPath=C:\Program Files\Microsoft SQL Server\MSSQL11.AAAAA\MSSQL\Binn\DatabaseMail.exe

  ReportDescription=Stopped working

  ** Below is how we have sysmail_configuration configured ***

  AccountRetryAttempts (Value: 5)

  AccountRetryDelay (Value: 60)

  DatabaseMailExeMinimumLifeTime (Value: 600)

  DefaultAttachmentEncoding (Value: MIME)

  LoggingLevel (Value: 2)

  MaxFileSize (100000000)

  ProhibitedExtensions (Value: exe,dll,vbs,js,bat,com)