The report could not be loaded. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
When attempting to run reports, the error "The report could not be loaded. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)" occurs on the page. The following error may also be associated with this error as well in the logs: "Invalid object name 'ReportServerTempDB.dbo.TempCatalog'. Could not use view or function 'ExtendedCatalog' because of binding errors."
Upon checking the disk space on the server where the report server databases are located, it is found that there is no low disk condition that exists.
There are a few different solutions for this as described below:
2. This can be caused by a corrupt Report Server or ReportServer Temp database. This error can be resolved by creating a new Report Server and ReportServerTempDB by doing the following steps. Note in step 16 of this process, you will be attempting to run the report in CRM\BBDM to make sure it runs as well. There are several components to installing and configuring SSRS, which need to be completed first before attempting to deploy and load reports in CRM or BBDM.
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.