Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SHARING] ReportCaster attachment size issue / workaround
Go
New
Search
Notify
Tools
Reply
  
[SHARING] ReportCaster attachment size issue / workaround
 Login/Join
 
Member
posted
Using WebFOCUS 8201m in Linux Red Hat VM on AS/400.

Long time ReportCaster use with no issues, but recently added a new report schedule that generates large Excel file (7+ meg). 

Mail server has 10 meg attachment limits, bumped to 25 for testing with no affect.

Sending to single email address works, but when sending to a distribution list only the first email account attempted is successful.  Getting 'IOEception while sending message' to 2nd email address when job fails and no additional attempts are made.

Distribution list does work for this report with a different date selection and file size 2~3 megs.  

Also, email addresses appear to be processed in random order.  First / last email address in list is not always the first email address used.  Also not in alpha sort order.

Workaround is to not use distribution list and instead send to email address(s). Obviously taking more effort to maintain large list of recipients but fortunately this is impacts a small number of reports for us.

This message has been edited. Last edited by: FP Mod Chuck,


Dennis Tuttle
WebFOCUS 8.201M
iSeries V7.2
Active, HTML, Excel
 
Posts: 12 | Location: Maryland | Registered: June 01, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Nice Thread Thanks for posting this!!!


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1608 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Master
posted Hide Post
Must have something to do with your environment (besides the email server limit). Is your report FORMAT EXL2K or XLSX? If EXL2K did you try the zip option in Report Caster? Can you use XLSX? These are actually a zip file so they are compressed. I send .xlsx files all the time using distribution lists that are larger than that (our limit is 25MB for attachments) and have never had an issue as long as I stay under the 25MB limit. Another option is to use ftp/sftp in Report Caster or in a script to send the file to a machine the user's can access. I have some jobs that do this.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 929 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Member
posted Hide Post
We're using an Excel template (xltm) which is merged with report data to create the macro-enabled workbook (xlsm). I can work on generating a large report to a standard workbook (xlsx) to see if that makes a difference. That would be interesting, and also better isolate an issue if the error doesn't occur with the standard Excel files.

Creating the zip file didn't change anything. Only sent to the first address in the distribution list.

FTP not an option in this environment.

My belief is that this is somehow tied to using the distribution lists.


Dennis Tuttle
WebFOCUS 8.201M
iSeries V7.2
Active, HTML, Excel
 
Posts: 12 | Location: Maryland | Registered: June 01, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SHARING] ReportCaster attachment size issue / workaround

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.