Once a month on the first of the month I need to burst an SSRS report out to ~200 email addresses. This month was the first time I've attempted it. The first run processed 185 emails but had 86 failures. When I look at the log it appears that my data source (which an ODBC connection to a SAP HANA in memory DB) is simply failing. It's not available or times out, or something.
In order to re-try the failures, I pulled the log file into excel which shows me the success emails, and rebuild my data driven subscription filtering those email addresses out. I've done this a number of times now and I'm getting there, but obviously this is quite painful.
I was thinking of trying to use Caching to fix the issue, but I'm not sure how that is going to help me since I don't have a good way to know which of the 200ish paramaters each month successfully built a cache or not. Any advice would be appreciated. I don't know if there is someway to automatically retry a failure or at least log who successfully received an email so that I don't email the same person twice.