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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS Report Timeout
Finance | Project Operations, Human Resources, ...
Unanswered

SSRS Report Timeout

(0) ShareShare
ReportReport
Posted on by Afieq Suhaimi 40

Hi,

I have an issue when printing the Ledger Transaction List report with one year data filter, it's causing the timeout error.

I also have checked on SQL Server Reporting Services, the current default report timeout is 1800.

I want to know if im going to increase the report timeout value, any necessary steps that i need to perform and aware?

Thanks in advance.

Regards,
Afieq

I have the same question (0)
  • Arshad A Shaikh Profile Picture
    Arshad A Shaikh on at

    Hello Afieq,

    Thanks for reaching out to Dynamics Community.

    Please can you share more details around the issue.

    1. Are you getting sql time out error in Dynamics 365.

    2. Have you tried running the same report on reporting server.

    3. The time out will occur if you huge amount of data to be fetched from servers.

    4. The best option to check is grab SSRS traces from : \Program Files\Microsoft Sql Server\MSRSx. <Instance>\Reporting Services\LogFiles

    This will give you some information on why the report failed.

    Regards,

    Arshad

    Microsoft Dynamics 365 Support

  • Afieq Suhaimi Profile Picture
    Afieq Suhaimi 40 on at

    Hi Arshad,

    I'm getting the error from Dynamics Ax.

    What do you mean tried running the same report on reporting server?

    Can u show me the steps on how to do it?

    I have tried to look at the traces folder file but does not have the logfiles for my error.

    For your information, everytime i try printing the Ledger Transaction List report for huge amount data after 1 minutes and 38 seconds it will prompt the error 'An existing connection was forcibly closed by the remote host'.

    But if less than 1 minutes and 38 seconds it can print successfully without any issue, i have tried using batch processing and change the print destination but still facing the same error.

    Are there any solutions for this error?

    Thanks.

    Regards,

    Afieq

  • Harshal Nayak Profile Picture
    Harshal Nayak on at

    Hello Afieq,

    As per the comments , I understand that this is AX 2012 report. can you try to check the points mentioned on this doc to increase the timeout

    docs.microsoft.com/.../tips-to-help-prevent-long-running-reports-from-timing-out

    Regards,

    Harshal

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans