Projects and Boards Error with MethodInvocationException

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

問題

atlassian-jira.log に次のログが記録される。

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 filtered

診断

診断ステップ

  • Accessing page that loads the project side bar, like project pages or Agile boards, result in the above error.

原因

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

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

"myfield(s)" = "test"

(info) We have seen this problem occur when JQL is modified outside of Jira's interface, like direct database changes.

ソリューション

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.

  1. Using the filter ID of 10100, access the filter via http://<baseurl>/issues/?filter=10100
  2. Check for the owner of the filter and reach out to them to fix the JQL.
    1. If the owner is unavailable, a Jira admin can take over ownership, see here: Managing shared filters


See related bug:  JSWSERVER-13632 - Getting issue details... STATUS


最終更新日 2018 年 11 月 2 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.