Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-4322

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

XMLWordPrintable

      NOTE: This bug report is for JIRA Service Desk Cloud. Using JIRA Service Desk Server? 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.

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

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2303355 ] New: JAC Bug Workflow v3 [ 3441925 ]
            Status Original: Done [ 10044 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 2057216 ] New: JSD Bug Workflow v5 - TEMP [ 2303355 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2054360 ] New: JSD Bug Workflow v5 [ 2057216 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 1954240 ] New: JSD Bug Workflow v5 - TEMP [ 2054360 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v4 [ 1872263 ] New: JSD Bug Workflow v5 [ 1954240 ]
            jonah (Inactive) made changes -
            Description Original: h3. 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.

            h3. Steps to Reproduce
            # Create a queue with a valid filter. e.g: {{resolution = Unresolved}}
            # Edit the queue
            # Change to {{resolution > Unresolved}}
            # Save queue

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

            h3. 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.

            h3. 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.

            h3.Workaround
            Find the queues on the project:
            {noformat}
            SELECT * from "AO_54307E_QUEUE" where "PROJECT_ID" in (select id from project where pkey = '<PKEY>');
            {noformat}
            Find the filter that is broken by searching JIRA using the same JQL
            Update the queue in the database to a working JQL.

            		 New: {panel:bgColor=#e7f4fa}
              *NOTE:* This bug report is for *JIRA Service Desk Cloud*. Using *JIRA Service Desk Server*? [See the corresponding bug report|http://jira.atlassian.com/browse/JSDSERVER-4322].
              {panel}

            h3. 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.

            h3. Steps to Reproduce
            # Create a queue with a valid filter. e.g: {{resolution = Unresolved}}
            # Edit the queue
            # Change to {{resolution > Unresolved}}
            # Save queue

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

            h3. 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.

            h3. 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.

            h3.Workaround
            Find the queues on the project:
            {noformat}
            SELECT * from "AO_54307E_QUEUE" where "PROJECT_ID" in (select id from project where pkey = '<PKEY>');
            {noformat}
            Find the filter that is broken by searching JIRA using the same JQL
            Update the queue in the database to a working JQL.
            jonah (Inactive) made changes -
            Link New: This issue is related to JSDSERVER-4322 [ JSDSERVER-4322 ]
            vkharisma made changes -
            Project Import New: Sun Apr 02 00:24:18 UTC 2017 [ 1491092658763 ]
            Matthew McMahon (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Awaiting Release [ 11372 ] New: Done [ 10044 ]
            Lachlan G (Inactive) made changes -
            Fix Version/s New: 3.3.0 [ 61746 ]

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

                Created:
                Updated:
                Resolved: