Hello,
During the report migration done database and encryption key backup and restore task successfully from 2008 to 2012 instance. But when check subscription on 2012 then not found.
There is no subscription showing into report server URL but checked all subscription is in reportserver database. I got following error message on SQL Server Reporting Services report log when migrated report server from 2008 R2 version to 2012 version.
During the report migration done database and encryption key backup and restore task successfully from 2008 to 2012 instance. But when check subscription on 2012 then not found.
There is no subscription showing into report server URL but checked all subscription is in reportserver database. I got following error message on SQL Server Reporting Services report log when migrated report server from 2008 R2 version to 2012 version.
Throwing Microsoft.ReportingServices.Library.InvalidSubscriptionException: , Microsoft.ReportingServices.Library.InvalidSubscriptionException: An invalid subscription '9999FD7C-C505-4827-AB30-42EBCA0A33C7' was found. Subscription must be deleted and recreated.
Not exactly found any solution for that then I just delete reports on Report Server and also cross check corresponding jobs into SQL Server Agent and also deleted there if found. Also update domain host name into rssqlserver config file as:
<DefaultHostName>yoursmtpserver.com</DefaultHostName>
Then I do backup and restore steps again and yes this time subscription are showing there.
May this helpful OR please share if anyone found more.
Thanks
No comments:
Post a Comment