Error with Sending large emails

[maverick_hs]

I have a report scheduled to be deliverd via email in Cognos Connection which sometimes doesn't get delivered if the size of the report exceeds certain limit. This is the error message I get in the log file. (I can run the report and save it as a view so the problem is only with emailing)

"class javax.mail.MessagingException: 552 message size of 46707030 bytes exceeds site limit of 5120000 bytes"

Cognos support says there is so no limitations on the size of emails that can be sent.

Can anyone figure out this error message and tell me where the limit of 5120000 bytes is specified? I can send out the report via email directly through my Outlook. Funny thing is the size of the report is never more than 2-3 MB, so I don't understand why the error message says it's 46.7 MB. Does reportnet do something funny before it sends out emails that increases the size temporarily? (if I run a smaller report say 1mb in size, I do recieve the email from reportnet and the size of the email is 1mb, so it does seem like reportnet does some intermediate conversion which increases the size temporarily making the mail server unable to send it.

I really appreciate any comments/help.

Thanks.

[Darek]

I think I will have to side with Cognos on this one. There is no limit I've heard of for their SMTP client; however, there might be a limit on your SMTP email server. To test this theory, bring up an IIS installation with SMTP services or get yourself some freeware SMTP server. Then reconfigure CRN to use that server instead of your default one. Make sure there is no limit on message size.

[sgyazuddin]

Hi;

The problem will be with your EMAIL Server(SMTP). Ask support people abt the attachment size which can be sent via email in your domain.

Thx & Reg.
S.Gyazuddin.

[maverick_hs]

I dug deeper into the log files and it turns out that the attachment which as an excel file should be about 2 MB or so, is converted to some intermediate xml file by Cognos for emailing and the size of that file is about 46 MB! This is of course more than what most SMTP servers would support in terms of size. I am not sure why Cognos needs to generate this huge file... Cognos support didn't have a solution either. For now, the users are doing without the report emailed to them...

[avitabj]

Hi!  Have you tried emailing the report in all the Excel formats that are supported by Cognos to see if any of them give your users the results they need but still stay within the attachment size limitations?  I use Excel 2000 for sending through our email server and it works ok (10 MB limit).  I keep the report in pretty much a simple list format.  You could always try CSV!!

hth...jean

[Darek]

Excel 2002 documents are in MSXML format I believe.