Projects and Boards Error with MethodInvocationException
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
The following appears in the atlassian-jira.log
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
2018-01-11 12:33:26,583 http-nio-127.0.0.1-8009-exec-982 ERROR admin 753x18701711x2 4iddvh 10.35.173.163 /secure/RapidBoard.jspa [c.a.j.issue.search.OfBizSearchRequestStore] A JQL query exception was thrown parsing, error loading search request with id '10100' and name 'myfield(s) = "test"'.
2018-01-11 12:33:26,591 http-nio-127.0.0.1-8009-exec-982 ERROR admin 753x18701711x2 4iddvh 10.35.173.163 /secure/RapidBoard.jspa [c.atlassian.velocity.DefaultVelocityManager] MethodInvocationException occurred getting message body from Velocity: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(34@[])
com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(34@[])
at com.atlassian.cache.ehcache.DelegatingCache.get(DelegatingCache.java:104)
at com.atlassian.jira.issue.search.CachingSearchRequestStore.getSearchRequest(CachingSearchRequestStore.java:129)
at com.atlassian.jira.issue.search.DefaultSearchRequestManager.getSearchRequestById(DefaultSearchRequestManager.java:134)
at sun.reflect.GeneratedgAccessor732.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at com.sun.proxy.$Proxy140.getSearchRequestById(Unknown Source)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136)
at com.sun.proxy.$Proxy140.getSearchRequestById(Unknown Source)
at com.atlassian.greenhopper.service.rapid.view.RapidViewPermissionServiceImpl.canSeeRapidView(RapidViewPermissionServiceImpl.java:40)
at com.atlassian.greenhopper.service.query.QueryServiceImpl.getSearchRequestWithoutSanitization(QueryServiceImpl.java:149)
at com.atlassian.greenhopper.service.query.QueryServiceImpl.getProjectsForRapidView(QueryServiceImpl.java:134)
at com.atlassian.greenhopper.service.query.QueryServiceImpl.getExplicitProjectsForRapidViewFilterQuery(QueryServiceImpl.java:128)
at com.atlassian.greenhopper.service.rapid.ProjectRapidViewServiceImpl.findProjectsByRapidView(ProjectRapidViewServiceImpl.java:69)
at com.atlassian.greenhopper.service.rapid.ProjectRapidViewServiceImpl.findRapidViewsByProject(ProjectRapidViewServiceImpl.java:51)
at com.atlassian.greenhopper.web.sidebar.ProjectBoardsHelper.getProjectBoards(ProjectBoardsHelper.java:53)
at com.atlassian.greenhopper.web.sidebar.BoardScopeFilterContextProviderImpl.getContext(BoardScopeFilterContextProviderImpl.java:47)
at com.atlassian.jira.projects.context.ProjectContextPopulatorImpl.populateWithProject(ProjectContextPopulatorImpl.java:82)
at com.atlassian.jira.projects.sidebar.footer.ProjectAdminLinkService.getProjectConfigUrlOverride(ProjectAdminLinkService.java:90)
at com.atlassian.jira.projects.sidebar.footer.ProjectAdminLinkService.getAdminUrl(ProjectAdminLinkService.java:75)
at com.atlassian.jira.projects.sidebar.footer.ProjectAdminLinkService.getLinkForProject(ProjectAdminLinkService.java:57)
at com.atlassian.jira.projects.sidebar.ProjectSidebarRendererImpl.render(ProjectSidebarRendererImpl.java:102)
at com.atlassian.greenhopper.sidebar.ProjectSidebarRendererAdapterImpl.render(ProjectSidebarRendererAdapterImpl.java:21)
at com.atlassian.greenhopper.sidebar.ProjectSidebarRenderer.render(ProjectSidebarRenderer.java:45)
at com.atlassian.greenhopper.web.sidebar.BoardSidebarRenderer.getProjectSidebarHtml(BoardSidebarRenderer.java:157)
at com.atlassian.greenhopper.web.sidebar.BoardSidebarRenderer.getSidebarHtml(BoardSidebarRenderer.java:88)
at com.atlassian.greenhopper.web.rapid.RapidBoardAction.getSidebarHtml(RapidBoardAction.java:273)
... 2 filteredDiagnosis
Diagnostic Steps
Accessing page that loads the project side bar, like project pages or Agile boards, result in the above error.
Cause
A JQL query being used by an Agile board contains invalid syntax. In the above stacktrace example, we see that the JQL is:
Bad JQL
1
myfield(s) = "test"The field name is "myfields(s)", but the it was not enclosed with double quotes. So the parenthesis () are causing problems with the parser.
Good JQL
1
"myfield(s)" = "test"ℹ️ We have seen this problem occur when JQL is modified outside of Jira's interface, like direct database changes.
Solution
Resolution
From the error, we can see that the filter being used as an ID of 10100. Using this, we can access the filter and fix the JQL.
Using the filter ID of 10100, access the filter via http://<baseurl>/issues/?filter=10100
Check for the owner of the filter and reach out to them to fix the JQL.
If the owner is unavailable, a Jira admin can take over ownership, see here: Managing shared filters
Related
See related bug: JSWSERVER-13632 - JIRA Software Manage Boards and viewing boards can timeout due to analysing JQL.
Was this helpful?