-
Bug
-
Resolution: Fixed
-
Medium
-
None
-
Severity 1 - Critical
-
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
- Create a queue with a valid filter. e.g: resolution = Unresolved
- Edit the queue
- Change to resolution > Unresolved
- 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.
- relates to
-
JSDCLOUD-4322 JIRA filter for a queue that has an uncaught exception breaks Queues view
-
- Closed
-
- mentioned in
- was cloned as
-
TESLA-946 Failed to load
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.