web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

SSRS Report timing out

(0) ShareShare
ReportReport
Posted on by 1,673

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

I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    60,284 on at

    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.

  • Michael Antony Profile Picture
    314 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans