April 15, 2011 at 11:01 am
We've recently setup SSRS 2005. There are three daily subscriptions thus far that send results in CSV via email. One of them has failed twice since we set this up, but most days it works fine.
When I view the Subscription in SSRS, the Status says "Failure sending mail: An error has occurred during report processing." The failed subscription happens 1 minute before another subscription, and the latter has not failed yet.
In both cases the scheduled job history in SSMS says "The step succeeded". Then I run the job manually and it sends the email fine (and the Status in SSRS says "Mail sent to <people>".
Where can I look to get actual error information? Event Viewer doesn't seem to have any extra details. I'd like to know where to look for any type of error logs. Also note that I have about two dozen jobs I've manually written to use db mail, and they've never failed to send email, so I'm fairly sure this is an SSRS problem.
Thanks.
April 15, 2011 at 11:23 am
Look into this folder:
C:\Program Files\Microsoft SQL Server\MSRS10_50.SSRSBI\Reporting Services\LogFiles
MSRS10_50.SSRSBI = The name of your SSRS instance Name
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 15, 2011 at 1:53 pm
That's them. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply