Hello All,
I have scheduled one report. We have three instance. Each instances have different list of values selected. It has set to run 1st Monday of the month at 7 AM.
Two reports got failed, and one got successes. Each report has different list of value selected in the prompts…
Can you please let me know what I need to fix these?
Thanks
SH
SH3230 (BOB member since 2010-10-25)
First step would be checking to see what the error message is.
joepeters 
(BOB member since 2002-08-29)
Hello Joe,
Here is the Error message:
write error. [Error sending mail message to SMTP server. Return code: [552].]: [CrystalEnterprise.Smtp]Thanks for your help.
SH
SH3230 (BOB member since 2010-10-25)
So it looks like there was a problem sending the message. I would check to ensure that the email addresses are valid; apart from that, you might need to check the logs on the mail server to find the actual problem.
joepeters (BOB member since 2002-08-29)
Also check to see the potential size of the generated file - could the failed instance fail because you have a limit on how big emails can be?
Nick Daniels 
(BOB member since 2002-08-15)
Email address is good. We have three region- US, Europe and Brazil…
In the prompts I have selected US and Europe, its failing and Brazil is working fine.
Thanks
SH
SH3230 (BOB member since 2010-10-25)
The size of the generated file(Excel) is 66.2MB.
SH3230 (BOB member since 2010-10-25)
That’s most likely the culprit. If you really need to send emails that huge, talk to the admin of the mail server to check on the size limit and have it increased if needed.
joepeters (BOB member since 2002-08-29)