Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-4322

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

      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.

            [JSDSERVER-4322] JIRA filter for a queue that has an uncaught exception breaks Queues view

            Following up on my comment....

            The workaround did work and I am glad to have my queues back.

            I am surprised that Jira SD 4.5.3 let me save a queue with a JQL filter that is invalid.

            MadelineBarr added a comment - Following up on my comment.... The workaround did work and I am glad to have my queues back. I am surprised that Jira SD 4.5.3 let me save a queue with a JQL filter that is invalid.

            I just did something like this inadvertently in  JIRA Service Desk Application v4.5.3, Jira v8.5.3. Is it not fixed?

            MadelineBarr added a comment - I just did something like this inadvertently in  JIRA Service Desk Application v4.5.3, Jira v8.5.3. Is it not fixed?

              lgoodhewcook Lachlan G (Inactive)
              mfernandezbadii Mauro Badii (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: