Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS Report Execution ...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by TH-10100715-0 6

Hi there,

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

  1. I have Extended My DP class with SrsReportDataProviderPreProcessTempDB.

  2. My Report table Type is TempDB

  3. I have created Controller Class and call my report through this class

  4. I have Updated the properties of menu item , Object Type  Class , Object controller class name 

  5. 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

 

 

Image (1).jpeg
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 1,878 on at
    SSRS Report Execution timeout issue (The wait operation timed out)

    Hmm... If it’s using the pre-processing pattern, I have a hard time seeing how it can time out unless there are some really funky things going on in the RDL or if an SQL execution plan in TEST/PROD got screwed up.

    My old AX checklist includes manually deleting the report from the SSRS manager and deploying it again. That’s what I’d try first.

    I wonder if there’s an issue with the SSRS server itself.

    • Can you see any high CPU or memory loads on the server when the report is being generated?
    • Do you have issues with other reports?
    • Can you see anything in the SSRS logs? SSRS Logs Documentation
    • Is this the only report with issues?

    You should be able to see how long it spends in the data provider in the logs.

  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,063 Super User 2024 Season 2 on at
    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
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,936 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,381 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans