I wrote a python program to bulk download ssrs reports.
The program sends a url to the browser to download an SSRS report, which it then renames and moves to specified directory for each key in a dictionary holding parameter values for the report.
For the parameters I've been testing each time I run my program I hit the same SSRS report 63 times.
The problem is that during development, I notice that after a while SSRS stops responding with the error
"The report server execution yhsoj1vs4bjdyqn4c4nw4k55 has expired or cannot be found. (rsExecutionNotFound)".
Then I cannot even manually run the report. The problem usually resolves itself within an hour but how do I prevent this from happening?
It could be the parameters or it could be session timeout or it could be just draining too much of the memory. Is that how it's going to run in production - you hit the same report 63 times? And is that just continually hitting that report? When it stops responding "after awhile" its that with breaks or continually hitting the report?
Have you looked in the Reporting Services log as well as the execution log view in the ReportServer database for other issues, errors when this happens?
Sue