Error creating email. No emailId was returned

Nisha Thyagarajan

Question

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

28 Oct 2015

Suraj Borade

Hi Nisha,

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

Regards,
Suraj Borade

28 Oct 2015

Nisha Thyagarajan

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" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="https://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">

</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="https://schemas.xmlsoap.org/soap/envelope/" xmlns:u="https://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"><s:Header><o:Security s:mustUnderstand="1" xmlns:o="https://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="https://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher">a:InternalServiceFault</faultcode><faultstring xml:lang="en-US">System.Web.Services.Protocols.SoapE

29 Oct 2015

Suraj Borade

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

EmailError.png

30 Oct 2015

Nisha Thyagarajan

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

02 Nov 2015

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines