D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

SSRS report times out even though Report Server settings are set to "Do not timeout report"

  • 1.  SSRS report times out even though Report Server settings are set to "Do not timeout report"

    TOP CONTRIBUTOR
    Posted Feb 01, 2019 11:27 AM
    ​Over a year ago we tried changing our Report Server settings so that reports would run to completion instead of timing out after 10 minutes.  Despite making those changes, reports would still timeout after 10 minutes.  To get around that problem, I ended up changing the specific reports to run in "pre-process mode" by changing the data provider class to specify that it extends the SrsReportDataProviderPreProcess class.

    Due to monthend, today we have an urgent situation where a much-needed report is timing out, and we're unable to make the necessary pre-process changes without having to do a code release to our PRD environment.  Currently I have the Report Server Site Settings and the report's Processing Options set to "Do not timeout report".

    Report Server Site Settings


    Report processing options

    The report still times out after 10 minutes.

    Any other quick suggestions for allowing this report to complete without timing out?

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------


  • 2.  RE: SSRS report times out even though Report Server settings are set to "Do not timeout report"

    SILVER CONTRIBUTOR
    Posted Feb 04, 2019 10:01 AM
    Hi Rudy,

    usually, the first thing to check when SSRS reports start timing out with AX 2012, is the class that generates that specific report.  Code changes can be performed to optimize report processing and prevent that 10 minute query timeout.  However, it can happen that the report is already optimized and still runs over that 10 minute default limit because of data volume or other factors that could impact run time.  That's when I usually go and specify a longer QueryServiceEndpoint sendTimeout value to allow reports to complete without error.  In order to do so, just take an AXC file that contains information to connect to the desired environment and copy it to the report server's bin directory (usually C:\Program Files\Microsoft SQL Server\MSRS11.<INSTANCE>\Reporting Services\ReportServer\bin).  Note that the MSRSXX can vary based your version of SSRS. Make sure to rename the config file to exactly Microsoft.Dynamics.AX.ReportConfiguration.axc.  Edit the file with a text editor and look for the QueryServiceEndpoint binding, then the sendTimeout property next to it.  By default, it will be 00:10:00 (10 minutes) but you can change it to whatever value you find acceptable for a decent report run.

    Let me know if that solves your issue!

    Best regards,

    ------------------------------
    Yvan Charbonneau
    Director of Information Systems and Supply Chain
    Laboratoire Riva Inc
    Blainville QC
    ------------------------------



  • 3.  RE: SSRS report times out even though Report Server settings are set to "Do not timeout report"

    Posted Feb 06, 2019 01:02 PM
    Are you pulling this reports from a temp table? try changing it to regular table.

    ------------------------------
    Suba Velpuri
    Hefty Seed Company
    ------------------------------



  • 4.  RE: SSRS report times out even though Report Server settings are set to "Do not timeout report"

    TOP CONTRIBUTOR
    Posted Feb 12, 2019 09:49 AM
    @Yvan Charbonneau  Thanks for the suggestion.  I would like to try that in one of our development or test environments first.  The SQL Server folder structure on those servers looks like this:

              SQL Server folder structure on DEV & TEST servers

    There are 3 "bin" subfolders within the folder structure.  Should I put the .AXC file in the bottom bin folder?

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



  • 5.  RE: SSRS report times out even though Report Server settings are set to "Do not timeout report"

    SILVER CONTRIBUTOR
    Posted Feb 12, 2019 10:07 AM
    @Rudy Salcedo, it looks like you don't have the SSRS subfolders on that server.  The custom AXC file needs to reside in the \ReportServer\Bin folder of the SSRS instance used for your AX environment.

    Best regards,



    ------------------------------
    Yvan Charbonneau
    Senior Director of Information Systems and Supply Chain
    Laboratoire Riva Inc
    Blainville QC
    ------------------------------



  • 6.  RE: SSRS report times out even though Report Server settings are set to "Do not timeout report"

    TOP CONTRIBUTOR
    Posted Feb 12, 2019 11:01 AM
    @Yvan Charbonneau OK thanks.  We do have that folder structure on our production report server, so I'll just have to go ahead and try it there.  I'll let you know the results.  Thanks!​

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



  • 7.  RE: SSRS report times out even though Report Server settings are set to "Do not timeout report"

    TOP CONTRIBUTOR
    Posted Feb 21, 2019 09:56 AM
    Edited by Rudy Salcedo Feb 21, 2019 09:58 AM
    @Yvan Charbonneau - ​I followed your instructions to increase the sendTimeout parameter from 10 to 30 minutes in our PRD environment and the report no longer times out.  I ran it about a dozen times and the runtimes ranged between 11 and 20+ minutes.  Thanks for your help!

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



  • 8.  RE: SSRS report times out even though Report Server settings are set to "Do not timeout report"

    SILVER CONTRIBUTOR
    Posted Feb 21, 2019 12:58 PM
    @Rudy Salcedo that's great news!  Glad to see you solved your issue.

    Best regards,​

    ------------------------------
    Yvan Charbonneau
    Senior Director of Information Systems and Supply Chain
    Laboratoire Riva Inc
    Blainville QC Canada
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role