• Replies 19 replies
  • Subscribers 338 subscribers
  • Views 430 views
  • Users 0 members are here
Related

Report Server/Scheduled Reports/Email

Michele Keutsch
$organization
Over the past couple of days we've had random scheduled reports not email out. The majority of the scheduled email reports are sending, but there are 1 or 2 that run, but won't email. Any thoughts on what the problem could be? Michele
Parents
  • $organization
    Hi Michele, On at least two recent occasions, we had an issue where only InfoMaker scheduled reports were not emailing out while SSRS ones were working just fine. A server reboot was ultimately required to get them to work again; at the moment, I'm not sure the cause and was not able to get it working without rebooting the server. Is it possible the two reports that aren't emailing are InfoMaker and the ones that are working are SSRS? If so, you may be experiencing the same issue we ran into. Thanks, David
Reply
  • $organization
    Hi Michele, On at least two recent occasions, we had an issue where only InfoMaker scheduled reports were not emailing out while SSRS ones were working just fine. A server reboot was ultimately required to get them to work again; at the moment, I'm not sure the cause and was not able to get it working without rebooting the server. Is it possible the two reports that aren't emailing are InfoMaker and the ones that are working are SSRS? If so, you may be experiencing the same issue we ran into. Thanks, David
Children
  • $organization in reply to David Frederick
    Thanks David, but that's not it either. Almost all of our scheduled reports are Infomaker.
  • $organization in reply to David Frederick
    Ooh...that's an interesting one to keep an eye out for.
  • $organization in reply to David Frederick

    David, Gawain: IIRC, I've had Infomaker reports fail to email even though SSRS was working fine due to the Windows Print Spooler service having quit! Infomaker reports don't have native PDF export, so they use Ghostscript which relies on a virtual printer. (Fun Fact: the next version of PowerBuilder will have PDF generation built in! No idea if Tessitura is planning to update, though.)

    As for random IM reports failing to email, I would really expect to see something in the logs; either the logfiles or the email log tables. But one thing you might want to check is that your Report Server concurrency is set to 1 (this is configured in the report server itself, or its ini file). Any other value makes it untrustworthy IMO -- I've had simultaneous schedules get their report attachments switched. That might be another thing to check -- are the reports that are failing to email scheduled at the same time as other schedules, or are they all spread out?