-
Bug
-
Resolution: Fixed
-
Highest
-
Severity 3 - Minor
-
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
- is related to
-
JPOSERVER-1826 Plan fails to load due to Invalid JQL or unable to translate
- Closed