SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,818 questions
SSRS on SharePoint: Check for Subscription failure issue
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 13%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Norman K. F. Chow
75
Reputation points
Hi all,
I am dealing with an SSRS data-driven subscription failure issue. I am using SQL Server 2008 R2 with its reporting services run on SharePoint integration mode (in a SharePoint 2010 server):
As shown above, this subscription instance generated 27 reports with 3 errors (it turned out that 3 out of 27 reports were skipped somehow).
In the SQL 2008 server I could find the ExecutionLog3 but found it not so useful....
It is also said that one could find reporting services logs files under \Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles, but in my case there is no such folder called "Reporting Services" in the machine running SQL Server 2008:
Any ideas of how to proceed checking why 3 out of 27 reports of this subscription run failed? Many thanks in advance.
Ricky