-
Type:
Bug
-
Resolution: Timed out
-
Priority:
Low
-
Component/s: Import/Export - Site Import
-
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
- Create Jira Server board with Quick Filter: assignee = user@domain.com
- Import site backup of Server into Jira Cloud
- Access Board with quick filter
Expected Results
Board should be visible
Actual Results
- 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"