Uploaded image for project: 'JIRA Service Desk Server'
  1. JIRA Service Desk Server
  2. JSDSERVER-4322

JIRA filter for a queue that has an uncaught exception breaks Queues view

    XMLWordPrintable

    Details

      Description

      NOTE: This bug report is for JIRA Service Desk Server. Using JIRA Service Desk Cloud? See the corresponding bug report.

      Summary

      It is possible to saved a broken filter to a queue when the JQL query returns an uncaught exception. This causes the Queues view to display no queues and prevent the creation of new queues.

      Steps to Reproduce

      1. Create a queue with a valid filter. e.g: resolution = Unresolved
      2. Edit the queue
      3. Change to resolution > Unresolved
      4. Save queue

      Expected Results

      The queue is not saved and a message is displayed indicating the the JQL filter is invalid.

      Actual Results

      The screen doesn't change as if the "Save" didn't work but the filter was saved in the background.
      Loading the queues again shows no queues.

      Notes:

      The problem is actually caused by an Uncaught exception returned by JIRA when searching resolution < unresolved but JIRA Service Desk could prevent the JQL to be saved in these scenarios. JSD correctly prevents the saving a JQL that is invalid if it doesn't error.

      Workaround

      Find the queues on the project:

      SELECT * from "AO_54307E_QUEUE" where "PROJECT_ID" in (select id from project where pkey = '<PKEY>');
      

      Find the filter that is broken by searching JIRA using the same JQL
      Update the queue in the database to a working JQL.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lgoodhewcook Lachlan Goodhew-Cook
              Reporter:
              mfernandezbadii Mauro Badii
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: