Unable to parse QuickFilter JQL when filter assignee reference appears as user@domain.com

XMLWordPrintable

    • 2
    • Minor

      Issue Summary

      After a Site import, accessing certain boards resulted in 500 Error. The log show the following:

      Caused by: java.lang.IllegalStateException: Unable to parse QuickFilter JQL
      	at com.atlassian.greenhopper.manager.rapidview.QuickFilterManagerImpl.replaceForgottenUsers(QuickFilterManagerImpl.java:359)

      This is because the table "AO_60DB71_QUICKFILTER" contains value assignee = user@domain.com and is unable to parse assignee.

      Unable to parse JQL for QuickFilter [5846] : [assignee in (user@domain.com...
      

      Steps to Reproduce

      1. Create Jira Server board with Quick Filter: assignee = user@domain.com
      2. Import site backup of Server into Jira Cloud
      3. Access Board with quick filter

      Expected Results

      Board should be visible

      Actual Results

      1. 500 Error page

      The below exception is thrown:

      Caused by: java.lang.IllegalStateException: Unable to parse QuickFilter JQL
      	at com.atlassian.greenhopper.manager.rapidview.QuickFilterManagerImpl.replaceForgottenUsers(QuickFilterManagerImpl.java:359)
      

      Workaround

      Atlassian Support needs to execute SQL update on table AO_60DB71_QUICKFILTER to manually enclose assignee value in quotes:

      assignee = user@domain.com

      Needs to be changed to:

      assignee = "user@domain.com"

            Assignee:
            Unassigned
            Reporter:
            Alfonso S. [Atlassian Support]
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: