Uploaded image for project: 'SR for Jira - Development'
  1. SR for Jira - Development
  2. SRJIRA-5016

An invalid JQL query breaks Service Management Queues

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: 6.17.0, 6.18.0
    • Fix Version/s: 6.20.0
    • Component/s: JQL Functions
    • Labels:
    • Sprint:
      SR4J Sprint 92
    • Critical Points:
      2.4

      Description

      Any JQL query that becomes invalid can cause the JSM UI to not render. Although the query is initially validated, it can become invalid over time.

      See below for an example.

      lastcomment("by username") breaks Service Management Queues when the user is not found (due to user rename).

      Step to reproduce:

      1. Create user "admin".
      2. Create a Service management project.
      3. Create new queue in the Service management Project to use: lastcomment("by username")
      4. Confirm queue is displayed correctly.
      5. Rename user "admin" to "admin-old" in user management.
      6. Reload the queue.

      Expected result

      All queues are displayed in the Service management project.

      Actual result

      Empty queues are displayed in the Service management project.

      Logs
      From the logs with "com.atlassian.plugin.web.DefaultWebInterfaceManager" set to debug we can see below error:

      WebItemProvider from module 'com.atlassian.servicedesk.project-ui:sd-queues-custom-provider' threw an error 'null'. Web-items provided by this provider will be ignored.
      ....
      ....
      ....
      Caused by: java.lang.Exception: Cannot find user with username: admin.
      

      Workaround

      1. Rename back the user to the previous username (eg: admin)
      2. Remove the Queue that uses lastcomment("by username").
      3. Rename back the user to the new username.
      4. Add new queue that uses lastcomment("by username").

        Attachments

          Activity

            People

            Assignee:
            jechlin Jamie Echlin
            Reporter:
            aomar Amirul Omar
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: