SSRS 2017 Subscription issue

Kirubakara Senthil Kumar S 191 Reputation points
2021-04-07T15:44:25.487+00:00

Hello All,

We have ~500 reports in SSRS 2008. Recently we migrated all the reports to SSRS 2017. After the migration, we noticed, subscription / Scheduling not working. In the SQL logs we noticed, the reports are shown as successful. But no outputs generated, no emails triggered. We verified the path, permission etc. Also, in the subscribe tab, if we run the report, it is running for ever.

Manually we are able to run the report, Export to Excel, PDF etc.

Even we created a simple "Hello World" report, that is also not working/generating output thru the subscription.

We tested this "Hello world" in SQL SSRS 2019, it working perfectly. This looks to me like a SSRS 2017 bug.

Appreciate your inputs and help in advance for this issue.

Thanks.
-Sen

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,797 questions
0 comments
Accepted answer
  1. Kirubakara Senthil Kumar S 191 Reputation points
    2021-04-08T18:57:11.197+00:00

    Thanks @Joyzhao-MSFT for your inputs.

    We have resolved this issue today with MS support ticket.

    There is a trigger on SSRS subscription table, which creates the entry for schedules, emails etc.

    This trigger was still pointing to a old server, that failed.

    It looks, that is a hard coded value/config issue, should be fixed during the SSRS migration from old server to new.

    After updating this trigger, it started working.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-04-08T02:24:32.75+00:00

    Hi @Kirubakara Senthil Kumar S ,

    This should not be a bug in SSRS2017.

    If you are migrating from SSRS2008 to the 2017 version, you could first refer to the following: Migrate a Reporting Services Installation (Native Mode). Please check whether the corresponding configuration has not been modified during the migration process. For example, if you have modified the RSReportServer.config file or RSWebApplication.config file in the previous installation, you should make the same modification in the new RSReportServer.config file.
    Please also refer to the following link to view email settings: E-Mail Settings-Reporting Services Native mode (Configuration Manager)

    I still have a question, how did you get the SSRS2019 version? Was it upgraded from SSRS2017? If you still keep the SSRS2017 version, you may wish to try to recreate a new subscription in the 2017 version to see if it can be delivered correctly.

    In addition, for any troubleshooting about the report server, we can check the error through the error log of the following path: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.

    Since this kind of issue cannot be reproduced, please provide me with comprehensive feedback as much as possible.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments