SSRS 2017 Subscription issue

Question

question

KirubakaraSenthilKumarS-2261 asked Apr 7, '21 Joyzhao-MSFT commented Apr 9, '21

SSRS 2017 Subscription issue

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

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-04-08T18:57:11.197Z

KirubakaraSenthilKumarS-2261 answered Apr 8, '21 Joyzhao-MSFT commented Apr 9, '21

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

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT · Apr 09, 2021 at 01:30 AM

I am glad to hear that your issue has been resolved. If you have any questions,please feel free to let me know.

0 ·

Answer 2 · 2021-04-08T02:24:32.75Z

Joyzhao-MSFT answered Apr 8, '21

Hi @KirubakaraSenthilKumarS-2261 ,

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.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question