Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-62232

JQL search with large number of characters cannot be exported

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 6.3.11, 7.2.0
    • JQL

    Description

      Issue Summary

      When a JIRA user performs a search in JIRA that uses the IN condition (e.g. Key in (.....)) if the options is very large (200+), JIRA would do one of the following depending on the browser and JIRA Version when they attempt to perform an Export:

      Update

      This behavior is not limited to the IN operator. Performing any search in JIRA with about 3k characters in the JQL, we were able to reproduce the issue of the export failing with slightly different observations

      Excel Exports

      JIRA 6.3.11

      1. Do nothing: Firefox
      2. Result in White page: IE, Chrome

      Looking at the console while performing this, you would see the 400 bad page exception.

      JIRA 7.2

      • All threw the 400 bad page exception for searches with the IN operator was used.
      • Chrome would throw a white page(blank page) if the in operator is not used and the data exceeds 3000 from our count.
      • Firefox does nothing, however when we looked at the browser console, we noticed that the 400 page error was also thrown in it.

      This doesn't seem to work irrespective of the export choice.

      Steps to Reproduct

      1. Go to the search issue page in JIRA.
      2. Perform an advanced search with the following option
        key in ("JRA-62001", "JRA-62002", "JRA-62003", "JRA-62004", "JRA-62005", "JRA-62006", "JRA-62007", "JRA-62008", "JRA-62009", "JRA-62010", "JRA-62011", "JRA-62012", "JRA-62013", "JRA-62014", "JRA-62015", "JRA-62016", "JRA-62017", "JRA-62018", "JRA-62019", "JRA-62020", "JRA-62021", "JRA-62022", "JRA-62023", "JRA-62024", "JRA-62025", "JRA-62026", "JRA-62027", "JRA-62028", "JRA-62029", "JRA-62030", "JRA-62031", "JRA-6202", "JRA-6203", "JRA-6204", "JRA-6205", "JRA-6206", "JRA-6207", "JRA-6208", "JRA-6209", "JRA-62010", "JRA-62011", "JRA-62012", "JRA-62013", "JRA-62014", "JRA-62015", "JRA-62016", "JRA-62017", "JRA-62018", "JRA-62019", "JRA-62020", "JRA-62021", "JRA-22", "JRA-23", "JRA-24", "JRA-25", "JRA-26", "JRA-27", "JRA-28", "JRA-29", "JRA-30", "JRA-31", "JRA-32", "JRA-33", "JRA-34", "JRA-35", "JRA-36", "JRA-37", "JRA-38", "JRA-39", "JRA-40", "JRA-41", "JRA-42", "JRA-43", "JRA-44", "JRA-45", "JRA-46", "JRA-47", "JRA-48", "JRA-49", "JRA-50", "JRA-51", "JRA-52", "JRA-53", "JRA-54", "JRA-55", "JRA-56", "JRA-57", "JRA-58", "JRA-59", "JRA-60", "JRA-61", "JRA-62", "JRA-63", "JRA-64", "JRA-65", "JRA-66", "JRA-67", "JRA-68", "JRA-69", "JRA-70", "JRA-71", "JRA-72", "JRA-73", "JRA-74", "JRA-75", "JRA-76", "JRA-77", "JRA-78", "JRA-79", "JRA-80", "JRA-81", "JRA-62195", "JRA-62196", "JRA-62197", "JRA-62198", "JRA-62199", "JRA-62200", "JRA-62201", "JRA-62202", "JRA-62203", "JRA-62204", "JRA-62205", "JRA-62206", "JRA-62207", "JRA-62208", "JRA-62209", "JRA-62210", "JRA-62211", "JRA-62212", "JRA-62213", "JRA-62214", "JRA-62215", "JRA-62216", "JRA-62217", "JRA-62218", "JRA-62219", "JRA-62220", "JRA-62221", "JRA-62222", "JRA-62223", "JRA-62224", "JRA-62225", "JRA-62226", "JRA-62227", "JRA-62228", "JRA-62229", "JRA-62230", "JRA-62231", "JRA-62232", "JRA-62233", "JRA-62234", "JRA-62235", "JRA-62236", "JRA-62237", "JRA-62238", "JRA-62239", "JRA-62240", "JRA-241") and status not in (closed)
        
        or something like:
        
        key = ssp-1 or key = ssp-2 or key = ssp-3 or key = ssp-4 or key = ssp-5 or key = ssp-6 or key = ssp-7 or key = ssp-8 or key = ssp-9 or key = ssp-11 or key = ssp-12 or key = ssp-13 or key = ssp-14 or key = ssp-15 or key = ssp-16 or key = ssp-17 or key = ssp-18 or key = ssp-19 or key = ssp-21 or key = ssp-22 or key = ssp-23 or key = ssp-24 or key = ssp-25 or key = ssp-26 or key = ssp-27 or key = ssp-28 or key = ssp-29 or key = witi-1 or key = witi-2 or key = witi-3 or key = witi-4 or key = witi-5 or key = witi-6 or key = witi-7 or key = witi-8 or key = witi-9 or key = witi-1 or key = witi-2 or key = witi-3 or key = witi-4 or key = witi-5 or key = witi-6 or key = witi-7 or key = witi-8 or key = witi-9 or key = witi-11 or key = witi-12 or key = witi-13 or key = witi-14 or key = witi-15 or key = witi-16 or key = witi-17 or key = witi-18 or key = witi-19 or key = witi-21 or key = witi-22 or key = witi-23 or key = witi-24 or key = witi-25 or key = witi-26 or key = witi-27 or key = witi-28 or key = witi-29 or key = witi-31 or key = witi-32 or key = witi-33 or key = witi-34 or key = witi-35 or key = witi-36 or key = witi-37 or key = witi-38 or key = witi-39 or key = witi-41 or key = witi-42 or key = witi-43 or key = witi-44 or key = witi-45 or key = witi-46 or key = witi-47 or key = witi-48 or key = witi-49 or key = witi-51 or key = witi-52 or key = witi-53 or key = witi-54 or key = witi-55 or key = witi-56 or key = witi-57 or key = witi-58 or key = witi-59 or key = bile-1 or key = bile-2 or key = bile-3 or key = bile-4 or key = bile-5 or key = bile-6 or key = bile-7 or key = bile-8 or key = bile-9 or key = bile-11 or key = bile-12 or key = bile-13 or key = bile-14 or key = bile-15 or key = bile-16 or key = bile-17 or key = bile-18 or key = bile-19 or key = bile-21 or key = bile-22 or key = bile-23 or key = bile-24 or key = bile-25 or key = bile-26 or key = bile-27 or key = bile-28 or key = bile-29 or key = bile-31 or key = bile-32 or key = bile-33 or key = bile-34 or key = bile-35 or key = bile-36 or key = bile-37 or key = bile-38 or key = bile-39 or key = bile-41 or key = bile-42 or key = bile-43 or key = bile-44 or key = bile-45 or key = bile-46 or key = bile-47 or key = bile-48 or key = bile-49 or key = bile-51 or key = bile-52 or key = bile-53 or key = bile-54 or key = bile-55 or key = bile-56 or key = bile-57 or key = bile-58 or key = bile-59 or key = tyli-1 or key = tyli-2 or key = tyli-3 or key = tyli-4 or key = tyli-5 or key = tyli-6 or key = tyli-7 or key = tyli-8 or key = tyli-9 or key = tyli-11 or key = tyli-12 or key = tyli-13 or key = tyli-14 or key = tyli-15 or key = tyli-16 or key = tyli-17 or key = tyli-18 or key = tyli-19 or key = tyli-21 or key = tyli-22 or key = tyli-23 or key = tyli-24 or key = tyli-25 or key = tyli-26 or key = tyli-27 or key = tyli-28 or key = tyli-29 or key = tyli-31 or key = tyli-32 or key = tyli-33 or key = tyli-34 or key = tyli-35 or key = tyli-36 or key = bile-37 or key = tyli-38 or key = tyli-39 or key = tyli-41 or key = tyli-42 or key = tyli-43 or key = tyli-44 or key = tyli-45 or key = tyli-46 or key = tyli-47 or key = tyli-48 or key = tyli-49 or key = tyli-51 or key = tyli-52 or key = tyli-53 or key = bile-54 or key = tyli-55 or key = tyli-56 or key = tyli-57 or key = tyli-58 or key = tyli-59 or key = vgrs-1 or key = vgrs-2 or key = vgrs-3 or key = vgrs-4 or key = vgrs-5 or key = vgrs-6 or key = vgrs-7 or key = vgrs-8 or key = vgrs-9 or key = vgrs-11 or key = vgrs-12 or key = vgrs-13 or key = vgrs-14 or key = vgrs-15 or key = vgrs-16 or key = vgrs-17 or key = vgrs-18 or key = vgrs-19 or key = vgrs-21 or key = vgrs-22 or key = vgrs-23 or key = vgrs-24 or key = vgrs-25 or key = vgrs-26 or key = vgrs-27 or key = vgrs-28 or key = vgrs-29 or key = vgrs-31 or key = vgrs-32 or key = vgrs-33 or key = vgrs-34 or key = vgrs-35 or key = vgrs-36 or key = vgrs-37 or key = vgrs-38 or key = vgrs-39 or key = vgrs-41 or key = vgrs-42 or key = vgrs-43 or key = vgrs-44 or key = vgrs-45 or key = vgrs-46 or key = vgrs-47 or key = vgrs-48 or key = vgrs-49 or key = vgrs-51 or key = vgrs-52 or key = vgrs-53 or key = vgrs-54 or key = vgrs-55 or key = vgrs-56 or key = vgrs-57 or key = vgrs-58 or key = vgrs-59
        
      3. JIRA should show you the expected result.
      4. Attempt to perform an export of the result.

      Expected Behavior

      JIRA would export the issue correctly with no problem what so ever.

      Actual Result

      JIRA would throw one of the errors I mentioned above or throw the 400 bad page exception.

      Further Test & Workaround

      If you reduce the options in the in condition(refine the search) or the amount of characters in the JQL (2595 has been confirmed to work by our customer)JIRA would be able to export the result correctly.

      The issue does not occur in JIRA 6.2 hence this seems like a regression.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ijimoh Ismael Olusula Jimoh (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: