-
Bug
-
Resolution: Won't Fix
-
Medium
-
None
-
10.56
-
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
- Create data that would create an export of 185K+ Excel rows
- Go to Time Tracking > Detailed Time Export
- 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:
- Choose the option "Extract Period" in the field "Time Period"
- Then select the period (multiple) you'd like to include in the export, like for example 1-1-2019 through 6-30-2019
- Export
- is related to
-
JIRAALIGN-746 When Selecting 400+ the Detailed Timesheet Report Will Not Getting Downloaded
- Closed
- relates to
-
JIRAALIGN-1031 Timesheet Export produces an empty report when exporting high volume data set
- Closed