SSRS on SharePoint: Check for Subscription failure issue

Norman K. F. Chow 75 Reputation points
2024-03-22T07:06:44.1433333+00:00

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):User's image 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:

User's image

Any ideas of how to proceed checking why 3 out of 27 reports of this subscription run failed? Many thanks in advance.

Ricky

SQL Server Reporting Services
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,798 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,607 questions
0 comments No comments
{count} votes