07-11-2016 12:31 PM
WARNING: Email: 552 5.3.4 Error: message file too big
I am getting this WARNING in the SAS log in one of the batch processes. This has 2 excel file attachment -- one is 9MB size and the other one is 100KB size. I don't want to reduce the file size, as most of them are required. When I changed it to CSV, the size is almost doubled, so it is not an option. Right now it uses proc export to xlsx file and then attach via filename email statements.
The program abends due to this issue and does not send any emails. I had to manually run from EG and it works fine from EG.
Can anyone suggest a work around for this without removing columns in excel file?
I am looking for options where you tell SAS to ignore these warning or use larger than 10MB file size, but could not able to find one.
07-11-2016 04:13 PM - edited 07-11-2016 04:15 PM
This is a restriction of your email system - nothing to do with SAS - it is just returning the error from your email system. You could try zipping the attachment first.
07-11-2016 04:46 PM
Thanks, I got confused because it works from EG and not via batch process.
Do you think EG uses local Outlook and batch job uses email server in SAS grid that restricts the size?
I will look into zipping, but do you use x command and gzip or how you would do the zipping other ways?
07-11-2016 05:01 PM
I suggest you check with your email admin to find out what your email restrictions are in different environments. If you are emailing within your organisation can you exchange files via a file share or use FTP so you don't have these restrictions?
I know some email systems will automatically zip files once they reach a certain size.