Monday, October 20, 2014

SharePoint2010 Reporting services error: Report Server has encountered a SharePoint error

Scenario: In Production SharePoint environment the "SQL Server Reporting Services" service was running on "App" servers only, and our client is not interested in enabling "SharePoint Foundation Webapplication" service on App servers. Because of this when deploying reports(*.rdl) to the site in Production we are greeted with below error message, that halts reports deployment:-
Report Server has encountered a SharePoint error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> System.ArgumentException: Feature '80faee05-c18e-45a9-9eac-09e12911c7dd' for list template '11100' is not installed in this farm.  The operation could not be completed.
Solution: The reason for this error is that as "reporting services" is running on App server when it tries to add reports to the "Reports" document library (custom document library created declaratively using XML markup and activated as part of feature), It somehow tries to access the "reports" library locally in 14 hive of App server, and it cant find its schema files and fails.

So creating the "Document Library" programmatically on "FetaureActivated" event resolved the issue. The other not so recommended approach is to save site as template and have a Powershell script to create site from template.