Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-474

Timeout errors when exporting search results to Excel

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Excel
    • None
    • Severity 3 - Minor

      Issue Summary

      Exporting search results with a high number of fields to Excel will often result in errors and timeouts.

      Steps to Reproduce

      1. Create a search that returns a high number of issues (~1k tickets should work)
      2. Add multiple columns to the search results. If possible, add SLA fields, as they seem to have a higher impact.
      3. Export the results by clicking on "Open on Microsoft Excel".

      Expected Results

      The query results will open on Excel or the file will be successfully downloaded.

      Actual Results

      An error will happen:

      Workaround

      • Use the "Open in Google sheets" instead. (The bug doesn't seem to affect the Google sheets export)
      • Export fewer fields and combine the two files later.
        • Example: Export the Issue Key and the SLA fields apart from the rest of the fields.

        1. image-2021-10-19-09-41-17-839.png
          image-2021-10-19-09-41-17-839.png
          11 kB
        2. image-2021-10-19-09-42-31-770.png
          image-2021-10-19-09-42-31-770.png
          34 kB

            [API-474] Timeout errors when exporting search results to Excel

            Samyak Mehta made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]
            Utkarsh Singh made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 823592 ]
            Andrew Daniels made changes -
            Remote Link New: This issue links to "JST-811412 (Atlassian Support System)" [ 697439 ]
            Vitalii Saienko (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: In Progress [ 3 ]
            Vitalii Saienko (Inactive) made changes -
            Assignee New: Vitalii Saienko [ vsaienko ]
            Paulo Junior (Inactive) made changes -
            Description Original: h3. Issue Summary

            Exporting search results with a high number of fields to Excel will often result in errors and timeouts.

            h3. Steps to Reproduce
             # Create a search that returns a high number of issues (~1k tickets should work)
             # Add multiple columns to the search results. If possible, add SLA fields, as they seem to have a higher impact.
            # Export the results by clicking on "Open on Microsoft Excel".
            !image-2021-10-19-09-41-17-839.png|thumbnail!

            h3. Expected Results

            The query results will open on Excel or the file will be successfully downloaded.

            h3. Actual Results

            An error will happen:
            !image-2021-10-19-09-42-31-770.png|thumbnail!

            h3. Workaround

            Use the "Open in Google sheets" instead.             		New: h3. Issue Summary

            Exporting search results with a high number of fields to Excel will often result in errors and timeouts.

            h3. Steps to Reproduce
             # Create a search that returns a high number of issues (~1k tickets should work)
             # Add multiple columns to the search results. If possible, add SLA fields, as they seem to have a higher impact.
            # Export the results by clicking on "Open on Microsoft Excel".
            !image-2021-10-19-09-41-17-839.png|thumbnail!

            h3. Expected Results

            The query results will open on Excel or the file will be successfully downloaded.

            h3. Actual Results

            An error will happen:
            !image-2021-10-19-09-42-31-770.png|thumbnail!

            h3. Workaround

            * Use the "Open in Google sheets" instead. (The bug doesn't seem to affect the Google sheets export)
            * Export fewer fields and combine the two files later.
            ** Example: Export the *Issue Key* and the *SLA* fields apart from the rest of the fields.
            Paulo Junior (Inactive) made changes -
            Description Original: h3. Issue Summary

            Exporting a search results with a high number of fields to Excel will often result in errors and timeouts.

            h3. Steps to Reproduce
             # Create a search that returns a hight number of issues (~1k tickets should work)
             # Add multiple columns to the search results. If possible, add SLA fields, as they seem to have a higher impact.
            # Export the results by clicking on "Open on Microsoft Excel". !image-2021-10-19-09-41-17-839.png|thumbnail!

            h3. Expected Results

            The query results will open on Excel or the file will be successfully downloaded.

            h3. Actual Results

            An error will happen: !image-2021-10-19-09-42-31-770.png|thumbnail!

            h3. Workaround

            Use the "Open in Google sheets" instead.             		New: h3. Issue Summary

            Exporting search results with a high number of fields to Excel will often result in errors and timeouts.

            h3. Steps to Reproduce
             # Create a search that returns a high number of issues (~1k tickets should work)
             # Add multiple columns to the search results. If possible, add SLA fields, as they seem to have a higher impact.
            # Export the results by clicking on "Open on Microsoft Excel".
            !image-2021-10-19-09-41-17-839.png|thumbnail!

            h3. Expected Results

            The query results will open on Excel or the file will be successfully downloaded.

            h3. Actual Results

            An error will happen:
            !image-2021-10-19-09-42-31-770.png|thumbnail!

            h3. Workaround

            Use the "Open in Google sheets" instead.
            Paulo Junior (Inactive) created issue -

              vsaienko Vitalii Saienko (Inactive)
              pjunior Paulo Junior (Inactive)
              Affected customers:
              9 This affects my team
              Watchers:
              20 Start watching this issue

                Created:
                Updated:
                Resolved: