Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-866

[JIRAALIGN-866] Running the Detailed Time Export results in "Script timed out" error

XMLWordPrintable

    • 1
    • Severity 3 - Minor
    • No

      Issue Summary

      When running the "Detailed Time Export" for a significant amount of data like an YTD report, it results in a "Script timed out" error and a corrupted XLS file.

      Steps to Reproduce

      1. Create data that would create an export of 185K+ Excel rows
      2. Go to Time Tracking > Detailed Time Export
      3. Export the data

      Expected Results

      Be able to open the Excel file with all the exported data.

      Actual Results

      • UI doesn't show any error and creates a corrupted XLS file.
      • When trying to open the Excel file, the following error shows in the logs:
        XML PARSE ERROR: Missing attribute quote
        Error occurs at or below this element stack:
        <ss:Workbook>
        <ss:Worksheet>
        <ss:Table>
        
      • Excel file has the following on its content.
        <font face="Arial" size=2>
        <p>Active Server Pages</font> <font face="Arial" size=2>error 'ASP 0113'</font>
        <p>
        <font face="Arial" size=2>Script timed out</font>
        <p>
        <font face="Arial" size=2>/ExportData.asp</font>
        <p>
        <font face="Arial" size=2>The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
        </font>
        

      Workaround

      When exporting, instead of export the full Year, do the following:

      1. Choose the option "Extract Period" in the field "Time Period"
      2. Then select the period (multiple) you'd like to include in the export, like for example 1-1-2019 through 6-30-2019
      3. Export

              kforeman@atlassian.com Kyle Foreman
              fd18f17e9ccb align-connector-bot
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: