Share via

SSRS Processing: 0 processed of 251 total; 0 errors on data-driven report

Keturah Phillips 10 Reputation points
2023-01-18T19:52:53.2233333+00:00

Hey Everyone, I have read through several threads about this error but no solution has worked. All my subscriptions were working previously and now subscriptions will be in a "Pending" state and after a few hours all the subscriptions will say, 'Processing: 0 processed of 251 total; 0 errors'.

I have tried the below. Please any assistance would be appreciated.

  1. I have restarted the subscriptions manually in "SQL Server Agent".
  2. Created a new subscription
  3. Restarted the "SQL Server Reporting Service" from Services.
  4. Restarted the Server where this subscriptions are hosted.
  5. Someone suggested to check the & character in "ExtensionSettings" column in Subscription table, but there is no & character.
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.
3,063 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tasadduq Burney 8,956 Reputation points MVP Volunteer Moderator
    2023-01-18T21:13:53.04+00:00

    Please try steps mentioned below :-

    1. Check the permissions on the report folder and the shared data source. Make sure that the service account running the SSRS service has the necessary permissions to access the report and the data source.
    2. Check the permissions on the subscription folders. Make sure the service account running the SSRS service has the necessary permissions to access the subscription folders.
    3. Check the SSRS configuration file (rsreportserver.config). Make sure that the database connection string is correct and that the server and database specified in the connection string are both up and running.
    4. Check the database connectivity. Make sure that the SQL Server instance that hosts the SSRS database is running and that the database is accessible.
    5. Check the SSRS logs for any error messages that may indicate the cause of the problem. The log files are located in the "LogFiles" folder under the SSRS installation directory.
    1 person found this answer helpful.
  2. ZoeHui-MSFT 41,491 Reputation points
    2023-01-19T06:57:35.6366667+00:00

    Hi @Keturah Phillips

    Please look at the ExecutionLog3 to see the reports status in Render column.

    Also have a check if it is a permission issue, make sure that account could access the database or the folder.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.