I have a report that pulls data from an SSAS 2008 cube. The report does take a few minutes to run, as it is grabbing a lot of data. The report is published to our sharepoint website, with stored credentials. When I run this report manually
on the sharepoint site, it works fine. However, when I try to create a data driven subscription, it gives me the following error: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I've looked through the SSRS log file, and it basically just repeats this error. I've also run SQL Server profiler, and I can see that all of the queries that populate the parameters run successfully, but then there are no more queries sent. So,
it seems that the connection is fine, but the data driven subscription has another timeout value that is causing the problem. All of the datasets have a timeout = 0, so that is not the issue.
I've also run a different data driven subscription using a smaller report (based on the same cube though), and it works fine. Any thoughts on what I need to do to fix this?
View Complete Post