I have two report servers and a single separate SQL Server 2008 server hosting the data source database and the report server catalogues.
There is a data driven subscription that runs off a sproc that returns 300 rows with email addresses for this report to be emailed to.
The report itself contains around 30 subreports each with its own sproc to retrieve data.
As the report is executing there are long pauses between the times when emails are actually sent out, and the subscription status will finally end with something like "Done: 300 processed of 300 total; 40 errors."
I am not sure how to go about troubleshooting this problem.
I kicked it off at (say) 2:00 PM. Within 3 minutes in the report server execution log I saw 300 entries. There were exactly 300 people who should receive reports, so the master report should have executed 300 times and sent out 300 emails.
So this looked good in the execution log.
But when I checked report manager's status page for the subscription it was listed as processing 50 out of 300...
Then all activity stopped, about 15 minutes some more reports started emailing out, and now I see there are around 590 rows in the execution log and maybe 97 emails sent out... Then finally I get a grand total of 846 rows in the execution log and a grand
total of 260 of 300 emails sent out with 40 errors so 260+40=300 exactly.
The time betw
View Complete Post