SSRS Report Execution timeout issue (The wait operation timed out)

(2) Share

Report

Posted on by TH-10100715-0

Hi there,

I have a SSRS report and i have followed all best practices like

I have Extended My DP class with SrsReportDataProviderPreProcessTempDB.
My Report table Type is TempDB
I have created Controller Class and call my report through this class
I have Updated the properties of menu item , Object Type Class , Object controller class name
Set the User Connection on the temp table . For this write this code on the start of your processReport method

I am not getting any error on OneBox machine but i am getting timeout and different server errors on UAT and Production environments. We are using on prem Microsoft dynamics 365 Finance and Operation version 10.0.38 (10.0.1777.94).

I am getting following different errors.

1. The wait operation timed out

2. An existing connection was forcibly closed by the remote host

Categories:

Development / Customization / SDK

Image (1).jpeg

All responses (1)

Answers (0)

Suggested answer

Waed Ayyad 5,503 Super User 2024 Season 2 on at

Like (0)

Report

SSRS Report Execution timeout issue (The wait operation timed out)

Hi,

Did you try to enhance the query of the code?

Suggestion: Instead of using insert try to use RecordInsertList and insertDatabase.

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue