November 19, 2013 at 5:00 am
Hello,
The ssrs report is calling a stored procedure to populate data...
The stored proc. takes about 15 minutes to complete.
Therefore the report gives a timeout message after 10 minutes.
For business reasons, the stored proc. should remain as is.
Question:
How can I increase the timeout so that this timeout is not shown and the report is populated even if it takes longer than 10 minutes to complete?
Thanks
November 19, 2013 at 6:09 am
Setting Time-out Values for Report and Shared Dataset Processing (SSRS)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 19, 2013 at 6:09 am
What is the timeout message saying? Is it a connection timeout? Have you run a profile on the target server and run the report? If so does the SQL complete?
The reason I am asking these things is to determine what sort of timeout you are getting e.g If the SQL is completing and then the timeout occurs afterwards then it's a report rendering issue.
November 19, 2013 at 6:27 am
yayomayn (11/19/2013)
What is the timeout message saying? Is it a connection timeout? Have you run a profile on the target server and run the report? If so does the SQL complete?The reason I am asking these things is to determine what sort of timeout you are getting e.g If the SQL is completing and then the timeout occurs afterwards then it's a report rendering issue.
Hi, as you see in my post, the stored procedure takes a long time to complete...
Solved the problem by changing the setting odf the report do not timeout.
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply