topic Re: Report server migration in Report Server

Report server migration

Anonymous — Fri, 20 Mar 2020 16:13:44 GMT

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?

Re: Report server migration

d_gosbell — Fri, 20 Mar 2020 20:15:39 GMT

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?

Re: Report server migration

Anonymous — Sat, 21 Mar 2020 09:47:59 GMT

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'.