SSRS Subscription Problem

  • We have upgraded our SSRS server to 2017. And redeployed the SSRS reports from the version control.
    But we found the subscription got lost after the redeployment.

    Does the redeployment of reports make the Subscription disappearing?
    Or the subscription should be still there.

    Thanks,

  • In my experience, redeployment shouldn't make subscriptions disappear, the subscriptions should still be there. You redeployed the SSRS reports from version control after the upgrade, what was the reason for doing this step? Do you know if the reports were there after the upgrade and before you redeployed them from source control?

    Andrew P.

  • Thank you!

    First  after the upgrade, I know the SSRS reports are upgraded too. The reason we redeploy is that we want all the stored definition files are in new definition schema. We opened the Visual studio 2017 and saved it in the new schema definition then redeploy them.

    ·       See below  from microsoft.
    When you upgrade a Reporting Services installation to a SQL Server 2017 Reporting Services (SSRS) installation, existing reports and snapshots that have been published to a report server are compiled and automatically upgraded to the new schema the first time they are processed. If a report cannot be automatically upgraded, the report is processed using the backward-compatibility mode. The report definition remains in the original schema.

    Second, I found our production server subscriptions still exist. But not those on Dev, Test, UAT servers.
    The developer deployed to production manually from Visual studio.
    But on dev and test server he used Octupus deployment tool for testing, I guess the tool deleted the reports and then deployed them other than overwriting the reports on the report server. I guess if a report is deleted the subscription will be gone, if it is overwrite the subscription should be still there.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply