Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JSWCLOUD-19169

Plan fails to load due to Invalid JQL or unable to translate

XMLWordPrintable

      NOTE: This bug report is for JIRA Portfolio Cloud. Using JIRA Portfolio Server? See the corresponding bug report.

      When attempting to load a plan, users are presented with a 500 error page:

       

      Expanding this for more details show a long trace:

      Technical details
      
      Log's referral number: 6ab881f9-52a8-4dcd-ad79-56c30dff463b
      Cause
      
      Referer URL: Unknown
      
      com.atlassian.jpo.env.jql.IssueSourceTranslationException: Invalid JQL or unable to translate.
      
      com.atlassian.jpo.env.jql.IssueSourceTranslationException: Invalid JQL or unable to translate.
      at com.atlassian.jpo.env.jql.JiraJqlIssueSourceTranslator.translate(JiraJqlIssueSourceTranslator.java:85)
      at com.atlassian.jpo.env.projects.JiraProjectAnalysisService.getProjectIdsForIssueSources(JiraProjectAnalysisService.java:52)
      at com.atlassian.jpo.issuesource.context.DefaultIssueSourceContextService.getProjectIdsForIssueSourcesWithoutFallback(DefaultIssueSourceContextService.java:95)
      at com.atlassian.jpo.issuesource.context.DefaultIssueSourceContextService.extractProjectIdsFromIssueSourcesWithoutLimit(DefaultIssueSourceContextService.java:140)
      at com.atlassian.jpo.issuesource.context.DefaultIssueSourceContextService.extractProjectIdsFromIssueSources(DefaultIssueSourceContextService.java:122)
      at com.atlassian.jpo.issuesource.context.DefaultIssueSourceContextService.getProjectIdsForPlan(DefaultIssueSourceContextService.java:75)
      at com.atlassian.rm.jpo.plugin.views.plan.common.CachedPlanInformationComponent.load(CachedPlanInformationComponent.java:68)
      at com.atlassian.rm.jpo.plugin.views.plan.view.standard.PlanView.execute(PlanView.java:118)
      at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39)
      at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31)
      at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16)
      at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35)
      at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225)
      at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:154)
      at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:152)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      ...
      Caused by: com.atlassian.rm.common.env.EnvironmentServiceException: Unknown filter: 24562
      at com.atlassian.jpo.env.jql.JiraJqlIssueSourceTranslator.translateFilter(JiraJqlIssueSourceTranslator.java:116)
      at com.atlassian.jpo.env.jql.JiraJqlIssueSourceTranslator.translate(JiraJqlIssueSourceTranslator.java:75)
      ... 204 more

       

      Cause

      • The plan is referencing a filter that is to no longer exists or contains a JQL that cannot be parsed.
      • The plan is using an Agile board, which is then using a JQL filter that no longer exists or cannot be parsed.

      Expectation

      The plan is loaded, indicating that the data has changed or is no longer available. It would show the configuration details of which Agile board is referenced or filter ID is being used.

      Actual

       The 500 page is presented and the user will have no course of action to understand how to fix the issue or what caused it.

      Workaround

      • Fix the filter being referenced by the Plan and ensure it is valid
        • If plugin functionality is referenced, ensure that the plugin is installed and enabled or remove the plugin functions in the JQL
      • If the filter is no longer available, create a new filter and update the database, setting the new filter's ID to be the same as the originally referenced ID. A restart of JIRA is required after the change

              Unassigned Unassigned
              dchan David Chan
              Votes:
              8 Vote for this issue
              Watchers:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: