Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

SSRS Report timing out

Posted on by 1,669

Hi everyone

I'm running a certain report in Ax 2012 R3 CU13, Vendor Invoice Transactions. When run for a short period, it works. When run for a long period, it doesn't - it runs longer and so times out.

The time out happens after 10 minutes exactly.

The timeout problem isn't on the report server itself. The site default timeout setting is 2 hours, and the report itself has a timeout setting of 30 minutes.

I found this article which seems more appropriate: 

https://www.axug.com/communities/community-home/digestviewer/viewthread?MessageKey=1f7531b0-9714-44bc-a6d0-693262d43c20&CommunityKey=af0dadbe-c222-4660-9d1e-a9e3416c837a&tab=digestviewer

However, even though I've implemented these changes, the timeout still happens.

Here is other information: 

- The reporting service is on a different server to the AOS

- The reporting service uses a default config file found on the AOS server

- The (main) error message in the log file on the report server is: 

System.TimeoutException: A timeout error occurred while calling the AOS service. Use the Microsoft Dynamics AX Configuration utility to change the WCF configuration values. Exception details: The request channel timed out while waiting for a reply after 00:09:59.9531497. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. ---> Microsoft.Dynamics.AX.Framework.Services.Client.QueryServiceException: The request channel timed out while waiting for a reply after 00:09:59.9531497. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. ---> System.TimeoutException: The request channel timed out while waiting for a reply after 00:09:59.9531497. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. ---> System.TimeoutException: The socket transfer timed out after 00:10:00. You have exceeded the timeout set on your binding. The time allotted to this operation may have been a portion of a longer timeout. ---> System.IO.IOException: The read operation failed, see inner exception. ---> System.TimeoutException: The socket transfer timed out after 00:10:00. You have exceeded the timeout set on your binding. The time allotted to this operation may have been a portion of a longer timeout. ---> System.Net.Sockets.SocketException: 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

Things I've tried:

-  Modified the timeout value in the config file (according to the article), and replaced the config file on the AOS server

Modified the timeout value in the config file (according to the article), and placed it in the bin folder on the report server

- Modified all timeouts in the file to 1 minute to see if any of them have an effect on the report, but the same error occurs. Even though all timeouts are 1 minute, the report times out after 10

- Restarted the reporting service after each of these operations

- Tried the suggestions here: docs.microsoft.com/.../tips-to-help-prevent-long-running-reports-from-timing-out

What am I missing? Any help appreciated as always

  • Michael Antony Profile Picture
    Michael Antony 314 on at
    RE: SSRS Report timing out

    I've tried the configuration on the first link that you mentioned, and it seems to be working on my server and it resolved the time out error.

    www.axug.com/.../viewthread

    Other than that, before that config, I've set no timeout in the SSRS Site settings and Report setting (on the report name it self). Also i've set no timeout on my SQL Server Instance: SSRS and Database

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: SSRS Report timing out

    The only real solution is to convert it to pre-process as described here docs.microsoft.com/.../how-to-long-running-reports . Pre-process reports do not have a timeout as such so can run for days.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans