Report server migration

[Anonymous]

@d_gosbell  Hello,

We recently migrated from 2008R2 SSRS to PBIRS 2017 using backup restore of the databases, copied encryption keys and scripted jobs from old server to new server. All jobs are executing successfully, but we are not getting any reports as emails.

any ideas?

[d_gosbell]

You should check in the log files normally stored at "C:\Program Files\Microsoft Power BI Report Server\LogFiles" you should find some that start with "ReportServerService_" this is the component that processes subscriptions so you might find some more information in there.

Have  you tried setting up a new subscription as a test to see if it is just a problem with migrated subscriptions?

[Anonymous]

Hi,

Verfied log files, I am not clear with errors. any idea of this errors?

library!WindowsService_7!efc!03/21/2020-11:21:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;
library!WindowsService_7!efc!03/21/2020-11:21:37:: w WARN: Transaction rollback was not executed connection is invalid
schedule!WindowsService_7!efc!03/21/2020-11:21:37:: i INFO: Error processing event with data: TimeEntered: 03/21/2020 11:21:37, Type: Event, EventType: TimedSubscription, SubscriptionID: c73df455-e214-4965-9c1b-2f83ec559feb. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.