Report.Run time exceeds request timeout at times

Posted by: robertwilliams673 on 28 February 2022, 6:26 am EST

  • Posted 28 February 2022, 6:26 am EST

    I am seeing an issue where the report run time exceeds the request timeout.

    We are running 2 pairs of webservers with load balancing between each pair.

    The issue seems to happen on one or two of the servers for a few minutes, then it straightens out.

    I put code in to determine if the issue was between the webserver and the database. That was not the issue.

    Here's the code behind the page:

    Using mStream As New MemoryStream
    Using pdf As New PdfExport
    pdf.Version = PdfVersion.Pdf17
    pdf.Security.Permissions = PdfPermissions.AllowPrint
    pdf.Security.Encrypt = True
    pdf.Security.Use128Bit = True
    pdf.Security.OwnerPassword = Guid.NewGuid.ToString
    Dim rptStart As Date = Date.Now
    Dim rpt As New Af469
    rpt.SetData(dtAf469, False)
    Dim rptEnd As Date = Date.Now
    _rptTs = rptEnd.Subtract(rptStart)
    _responseStart = Date.Now
    mStream.Position = 0
    Response.ContentType = "application/pdf"
    Response.AddHeader("content-disposition", "inline; filename=AF469.PDF")
    pdf.Export(rpt.Document, mStream)
    End Using
    End Using

    The timespan between rptStart and rptEnd will exceed 80,000 milliseconds on many of the error log entries.

    Any ideas on how I can narrow down the cause for this issue?

  • Marked as Answer

    Replied 28 February 2022, 9:52 pm EST

    Hi Robert,

    Please refer to our guide on Optimizing Section Reports.

    I hope it resolves your issue.
  • Replied 9 March 2022, 5:45 am EST

    At this point, the most likely cause is a Denial of Service attack by our own host based security system. An external process is running our CPU % up to 99%.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels