I have a report which uses a stored procedure to retreive a resource intensive dataset from a Data Warehouse. With a small scope it renders in SharePoint no problem, but when a larger scope is specified ShrePoint throws this non-descript error.
I can execute the procedure in SQL Server Management Studio, and though it takes 2+ minutes with the larger scope (30 sec with smaller) it does return the data. Similarly, in Business Intelligence Development Studio it returns the rendered report with
data after 2-3 minutes.
Only in SharePoint and only with a larger dataset does this occur. Timeout is set at 30 minutes and it occurs long before then. SSRS server has over 12 gigs memory, running SQL Server 2008, SharePoint 2007 is in integrated mode. No
errors in SharePoint server or SSRS server logs. Ideas?
View Complete Post