I'm looking for either help on an issue or to see if somebody can point me in the right direction to troubleshoot the issue below.
We have reports running in SSRS 2008 R2 SP1 (10.50.2500.0) where a subscription on a shared schedule will sometimes show as hung up in a "pending" state. From looking through the execution log table I found that an execution log record that is normally written wasn't. I have attached a screenshot highlighting the record that was missing a duplicate that day as well as a 0 byte count. I also looked through the SSRS log files (Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles) and they look identical to previous days when I search by report name as well as the SubscriptionID for the scheduled run time. When I rescheduled the subscription to run it executed without a problem. I would like to see if anyone has any advanced troubleshooting techniques that I can employ prior to calling in a ticket with Microsoft. My client is really coming down on me to come up with an explanation for these random report failures and at this point all I can say is "I don't know".
Any help, suggestions or comments are appreciated.