You’re offline. This is a read only version of the page.
50
Hi Experts, I have a bad quality SSRS report to generate the monthly payroll. It takes time to be generated due to the way how the DP calls where developed.
now due to grow in data i get the following error when i run it
{
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
}
i tired few actions it use to work when i do them like restart SQL Services, use the system in the ideal time, run the Rich Client of the application from server. it is not working any more.
when i try to run it from reporting server ,URL http://<serverName>/Reports it get following error , after i changed the report timeout from SQL Server Reporting Services, still i get the error
{
}
I know the best way is rewrite or enhance the report processing class in the report, but development we take time and testing efforts, can i find solution or temporary solutions. I have only issue in this report other reports are working fine.
*This post is locked for comments
I have the same question (0)
Yes,
detecting and optimizing the bottleneck is the best approach to have a final 'solution' for the future too.
But, regarding timeouts, there are a lot if involved timeouts, do you have gone through this?
blogs.msdn.microsoft.com/.../how-to-addressing-ssrs-session-timeouts
regards Douglas
Share
Report
All responses (
Answers (
