Forum Discussion
SSRS reports not working
Hi Microsoft team,
We are looking for tech support on an issue with SSRS reports that are used in one of our applications.
The details of the issue are as foll:
When Trying to access an SSRS ReportServer instance (either through the SOAP Service, or directly from the browser) does not work. There are Errors observed in the log files as well as the user interface .
The error message is
An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.
The user interface fails to load Report as a result
Attached are the SSRS log files from the last month from one of the servers.
The last time reports were successfully accessed was on Friday, June 15th. Starting this Monday all functionality stopped working.
This environment has 4 SSRS servers under an High Availability AGL.
RSManagement log files indicate that the ReportServer schemas may be in an inconsistent state
|FATAL|8|Database upgrade failed!! The database may now be in an inconsistent state.
Further research indicates that this may be corrected by the following procedure…
Stop SSRS services
Backup and delete ReportServer and ReportServerTempDB databases
Start the SSRS services
Use the wizard to create a new ReportServer set of databases
Stop the SSRS services
Delete the new (empty ReportServer) database
Restore the backup of the ReportServer (from step 2 - do not restore the temp database)
Fix schema of ReportServer.dbo.Catalog.PropertyField and ReportServer.dbo.Segment.Content (change columns from ntext to nvarchar(max))
Start the SSRS services (Monitor the RSManagement log file)
Verify
Backout if fail: (Stop Services, Restore the databases, Restart Services)
This may also include refreshing of encryption keys and removing servers from the AGL prior to this procedure
Can you please help identify what could be a possible root cause for this issue, confirm if the steps listed below present a plausible solution, and advise on any additional triaging steps or corrective procedures?
Thanks in Advance