Hi @Eshwar ,
If the error occurs sometimes when the report is the same, and sometimes it works normally, I think the issue of report execution timeout should be considered.
Report Execution Timeout
First of all, if your report is large, check your report and make sure that you only extracted the necessary information. Please use the available filters to extract only the information that is useful to you.
Once you have filtered the report as much as possible and the report still timed out, you can modify the execution timeout setting in Microsoft Reporting Services (or disable the timeout). Open the report manager (Web portal url)-Site Setting-General. You could then set the number of seconds to 3600. If that does not allow the report to finish, you could then select the "do not timeout" option.
You could set the httpruntime to run the large report,
You can alter the value of attribute executionTimeout of tag httpRuntime, default value if 9000 and value is in the seconds.
<httpRuntime executionTimeout = "9000" />
Open the Web.config file. If it does not exist, you must create it in that section.
If the above setting does not resolve the issue, please feel free to let me know.
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.