Attachment too large to send via SMTP email

server administration XI Server Discussion
1

I am scheduling a WebI report to run in the middle of the night and send the report as an excel spreadsheet to certain email recipients. However, I get the following error when it tries to send the email:

write error. [Error sending mail message to SMTP server. Return code: [].]: [CrystalEnterprise.Smtp]

I believe it has something to do with the file size because I can send other reports as excel attachments that are smaller.

The spreadsheet is 8.96 MB. My environment is BO Edge 3.1 SP 3.5.

I checked with infrastructure and they said that the max attachment size is 10 MB.

Isn’t there a setting in one of the servers or through config files to set the max allowed attachment size to fix this issue?

cwatson :us: (BOB member since 2010-03-25)

2

BO is fine in this equation, sounds like your email server guys have set the limit at 10 meg - you may be into the realm of workarounds…

Can you split this report into a part 1 and part 2, using a filter? Names A-M, N-Z for example, maybe dates? Plan B is drop your file on a share drive and send just a link to it, works if your users are in-house… FTP??

Good luck!
B

bdouglas :switzerland: (BOB member since 2002-08-29)

3

So do you think that the SMTP server would stop the file from being sent even though it is 1MB shy of the 10MB limit?

A few years ago I remember there being a 50MB limit in BO when scheduling a report to just be saved in the history. I’m just wondering if there is another limit somewhere for email.

cwatson :us: (BOB member since 2010-03-25)

4

I misread your original message, sorry - maybe it’s a straight network error, something wrong that’s only an issue during longer transfers…?

I’d get your traces on, dig into those for any more detail you can get - check your server event logs, too - maybe a clue there…

Good luck!
B

bdouglas :switzerland: (BOB member since 2002-08-29)