I am deploying Data Sources & RDLs on SharePoint 2010 and SSRS 2008 r2. I am using 2 box deployment with SharePoint FE and SQL Server 2008 r2 BE with Reporting Services Installed. I have created and given the permissions to sharepoint groups and databases
on the Reporting Server Instance.
I am using .net utility using sharepoint dlls that deploy the data sources on rdl. If i have SharePoint + BE on the same box deployment works fine. When i have 2 box deployment i am getting the following error in the reporting service log.
ERROR: Error when calling GetSPItemMetaData on path:
library!ReportServer_0-1!804!09/15/2010-14:03:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: , Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error.
---> System.ArgumentException: Value does not fall within the expected range.
at Microsoft.SharePoint.Library.SPRequestInternalClass.GetMetadataForUrl(String bstrUrl, Int32 METADATAFLAGS, Guid& pgListId, Int32& plItemId, Int32& plType, Object& pvarFileOrFolder)
at Microsoft.SharePoint.Library.SPRequest.GetMetadataForUrl(String bstrUrl, Int32 METADATAFLAGS, Guid& pgListId, Int32& plItemId, Int32& plType, Object& pvarFileOrFolder)
View Complete Post