Uploaded image for project: 'Xray for Jira Cloud'
  1. Xray for Jira Cloud
  2. XRAYCLOUD-10909

Storage CSV export fails silently with "Invalid JQL query" when Storage contains large number of files (JQL operand limit exceeded)

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Waiting Approval
    • Medium
    • Resolution: Unresolved
    • Xray Cloud 15.0.0
    • None
    • None
    • N/A

    • UNCOVERED

    Description

      Description:

      Storage CSV export fails silently for tenants with a large number of storage files. The export never completes and no error is shown in the UI. The backend job "xray.processor.storagesync" (op: export-csv) fails with an "Invalid JQL query" error because the generated JQL query places all issue IDs into a single issue in (...) clause, exceeding Jira's operand limit (74,679 IDs observed on the affected tenant).

      Steps to reproduce:

      1. Log in to a Jira instance with Xray Cloud installed and a large number of Storage entries (tens of thousands of linked issues)
      2. Navigate to Jira Settings > Marketplace apps > Xray > Storage
      3. Click "Export to CSV"

      Actual result:

      The export never completes and no error message or download link is shown in the UI. The HAR file shows the export request returns a 404. {{}}

      Expected result:

      The CSV file containing the Storage data should be generated and made available for download.

      Attachments

        Issue Links

          Activity

            People

              bernardo.cottim Bernardo Cottim
              victor.tisbierek Victor Tisbierek
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: