Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Report server migration

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 exec...
Report Server + PBI On Permises
d_gosbell's avatar
d_gosbell
Super User
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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