Error creating email. No emailId was returned

Error creating email. No emailId was returned

  
Hi,
I see these error messages - Error creating Email. No EmailId was returned. 
Also the table -  OSSYS_EMAIL_CONTENT is 120 gig in size.

Please can you explain how to resolve the error and if it is ok to truncate the table.

Thanks,
Nisha
Hi Nisha,

Please explain your problem in detail. At what time you are getting the error?

Regards,
Suraj Borade
Hi Suraj,

We have this error message below - every few minutes. Full message is given below. There are no issues in the application sending
emails to users. They are recieving emails as usual and no one has raised an issue. I am not sure what user event triggers this error message.

Looks like a timer - scheduled email. I will find out more and get back. Thanks, in the mean time if you have any inputs please let me know.


Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<title>500 - Internal server error.</title>
<style type="text/css">
<!--
body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}
fieldset{padding:0 15px 10px 15px;} 
h1{font-size:2.4em;margin:0;color:#FFF;}
h2{font-size:1.7em;margin:0;color:#CC0000;} 
h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;} 
#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF;
background-color:#555555;}
#content{margin:0 0 0 2%;position:relative;}
.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}
-->
</style>
</head>
<body>
<div id="header"><h1>Server Error</h1></div>
<div id="content">
<div class="content-container"><fieldset>
  <h2>500 - Internal server error.</h2>
  <h3>There is a problem with the resource you are looking for, and it cannot be displayed.</h3>
</fieldset></div>
</div>
</body>
</html>
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"><s:Header><o:Security s:mustUnderstand="1" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"><u:Timestamp u:Id="_0"><u:Created>2015-10-29T16:04:42.036Z</u:Created><u:Expires>2015-10-29T16:09:42.036Z</u:Expires></u:Timestamp></o:Security></s:Header><s:Body><s:Fault><faultcode xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher">a:InternalServiceFault</faultcode><faultstring xml:lang="en-US">System.Web.Services.Protocols.SoapE

Hi Nisha,

This error is repeating after every few minutes bacause of timer. This action is getting executed inside the timer and timer is getting executed every few minutes. So check what is schedule of timer to run.


Are you calling any webservice inside the timer action and then passing some data from webservice to an e-mail? If it is so then there is problem in the response of webservice. It should return "text/xml" instead of "text/html".

If there is no webservice, are you passing any data from XML to e-mail. Then check those XML contents.


I hope this will help you in tracing the root cause.

Regards,
Suraj Borade
Hi Suraj,
Thank you for your response.

The issue was a user was disabled and did not exist in AD. And he had a few reports set up to run in a frequency. Hence the errors. I have purged all his reports and reports set up frequence etc and its all good now.

Cheers,
Nisha