Uploaded image for project: 'Advanced Roadmaps'
  1. Advanced Roadmaps
  2. JPOSERVER-74

Importing issues produces a com.atlassian.jira.jql.parser.JqlParseException

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    XMLWordPrintable

Details

    Description

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

      Importing issues into portfolio produces an on screen error as follows:

      com.atlassian.jira.exception.DataAccessException :com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(59@[])
at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv:482
  at com.atlassian.jira.issue.search.OfBizSearchRequestStore.convertGVToRequest:456
  at com.atlassian.jira.issue.search.OfBizSearchRequestStore.access$000:58
  at com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get:96
  at com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get:93
  at com.atlassian.jira.ofbiz.DatabaseIterator.pullNext:68
  at com.atlassian.jira.ofbiz.DatabaseIterator.populateNextIfNull:77
  at com.atlassian.jira.ofbiz.DatabaseIterator.hasNext:40
  at com.atlassian.jira.ofbiz.PagedDatabaseIterable$PagingIterator.hasNext:207
  at com.atlassian.jira.util.collect.CollectionUtil.foreach:42
  at com.atlassian.jira.util.collect.CloseableIterator$Functions.foreach:58
  at com.atlassian.jira.util.collect.CloseableIterator$ListResolver.get:41
  at com.atlassian.jira.ofbiz.PagedDatabaseIterable$SortedIterator.<init>:146
  at com.atlassian.jira.ofbiz.PagedDatabaseIterable.iterator:100
  at com.atlassian.jira.ofbiz.PagedDatabaseIterable.foreach:107
  at com.atlassian.jira.util.collect.TransformingEnclosedIterable.foreach:29
  at com.atlassian.jira.util.collect.EnclosedIterable$ListResolver.get:52
  at com.atlassian.jira.sharing.search.SharedEntitySearchResult.getResults:40
  at com.radiantminds.roadmap.jira.common.components.extension.JiraIssueFilterUtil.getAllFilters:36
  at com.radiantminds.roadmap.jira.common.components.extension.JiraWorkitemExtension.getAllIssueFilters:305
  at com.radiantminds.roadmap.common.rest.services.SystemService$1.execute:46
  at com.radiantminds.roadmap.common.context.Context.forAllExtensions:35
  at com.radiantminds.roadmap.common.rest.services.SystemService.listFilters:42
  at sun.reflect.NativeMethodAccessorImpl.invoke0:-2
  at sun.reflect.NativeMethodAccessorImpl.invoke:57
  at sun.reflect.DelegatingMethodAccessorImpl.invoke:43
  at java.lang.reflect.Method.invoke:606
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker$1.invoke:234
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$1.intercept:100
  at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke:61
  at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept:38
  at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke:61
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors:132
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch:230
  at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch:75
  at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept:288
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept:147
  at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept:108
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept:147
  at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept:84
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest:1469
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest:1400
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest:1349
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest:1339
  at com.sun.jersey.spi.container.servlet.WebComponent.service:416
  at com.sun.jersey.spi.container.servlet.ServletContainer.service:537
  at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter:178
  at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter:795
  at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter:73
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.jira.tzdetect.IncludeResourcesFilter.doFilter:39
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.jira.baseurl.IncludeResourcesFilter.doFilter:38
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilterInternal:26
  at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilter:40
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter:25
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.servicedesk.internal.web.RedirectExternalCustomerToPortalFilter.doFilter:18
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.mywork.client.filter.ServingRequestsFilter.doFilter:37
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.cors.CorsFilter.doFilter:65
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter.doFilter:36
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsDispatcherFilter.doFilter:60
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFilter.doFilter:92
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsMatcherFilter.doFilter:56
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.labs.botkiller.BotKillerFilter.doFilter:36
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest:103
  at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter:87
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter:54
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter:87
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.seraph.filter.SecurityFilter.doFilter:239
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter:100
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.seraph.filter.BaseLoginFilter.doFilter:172
  at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter:70
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter:69
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter:40
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter:71
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite:176
  at org.tuckey.web.filters.urlrewrite.RuleChain.doRules:145
  at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest:92
  at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter:394
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.gzipfilter.GzipFilter.doFilterInternal:82
  at com.atlassian.gzipfilter.GzipFilter.doFilter:59
  at com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter:55
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.analytics.client.filter.JiraAnalyticsFilter.doFilter:41
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter:87
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter:33
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter:41
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter:45
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter:79
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter:41
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter:87
  at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter:60
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at org.apache.catalina.core.StandardWrapperValve.invoke:220
  at org.apache.catalina.core.StandardContextValve.invoke:122
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke:501
  at org.apache.catalina.core.StandardHostValve.invoke:171
  at org.apache.catalina.valves.ErrorReportValve.invoke:103
  at org.apache.catalina.core.StandardEngineValve.invoke:116
  at org.apache.catalina.valves.AccessLogValve.invoke:950
  at org.apache.catalina.connector.CoyoteAdapter.service:408
  at org.apache.coyote.http11.AbstractHttp11Processor.process:1070
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process:611
  at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run:2377
  at java.util.concurrent.ThreadPoolExecutor.runWorker:1145
  at java.util.concurrent.ThreadPoolExecutor$Worker.run:615
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run:61
  at java.lang.Thread.run:745

      The JIRA log files will show an error similar to the following:

      /rest/roadmap/1.0/system/filters.json [jira.issue.search.OfBizSearchRequestStore] A JQL query exception was thrown parsing, error loading search request with id 'xxxxx' and name 'xxxxx' owned by 'xxxxx' query 'xxx xxx xxx xxx'.

      Cause
      The query displayed above is incorrect/corrupt, and causes the import function to blow up.

      Resolution
      Find the saved filter in question based on id or filter name as displayed in the error. Remove it from the instance (GUI if possible, else directly in the database) or adjust it in order for it to become a valid filter.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. JSWSERVER-10537 Upgrade Task 13 Should Ignore Invalid JIRA filter

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JSWCLOUD-20037 Importing issues produces a com.atlassian.jira.jql.parser.JqlParseException

          • Low - Low priority issues
          • Closed

          Activity

            People

              Unassigned Unassigned
              mnassette MJ (Inactive)
              Archiver:
              atibrewal@atlassian.com Aakrity Tibrewal

              Dates

                Created:
                Updated:
                Resolved:
                Archived: