Pages

Friday, November 22, 2013

ReportServerError: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Invalid object name ''. Could not use view or function 'ExtendedCatalog' because of binding errors.

There will be often Business Needs to Have your Report Server Migrated Moved or Restored onto Different Environment. You May come up with Different Errors Post Restoration. Here i am going to describe one such Error. You May get the below error when you have your ReportServer Databases Restored
“An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.Invalid object name ''. Could not use view or function 'ExtendedCatalog' because of binding errors.”
This is because there is a function in Your ReportServer Database by Name 'ExtendedCatalog' . This will be holding the entry to corresponding ReportServerTempDB.
The Old Names may be different and New Names might be different. Since this catalog will still be pointing to Old ReportServer Temp Database you will get this error.
Resolution:
To resolve this error, you need to Modify the Function and Change the Old ReportServerTempDB Name to New one
Old Code Snippet:
[OldReportServerTempDB].dbo.TempCatalog TC
New Code Snippet:
[NewReportServerTempDB].dbo.TempCatalog TC
Done, now you will be able to run your Reports.
I will write a Separate Topic on Clean and Neat ReportServer Database Restoration.

No comments:

Post a Comment