com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException:com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null)

Atlassian JIRA | James Roper [Atlassian] | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    The following code: {code:java} searchRequestManager.getAll().foreach(new SharedEntityGroupUpdator<SearchRequest>(oldName, newName, filterPermissions)); {code} is throwing the following exception: {noformat} com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException:com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:415) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.convertGVToRequest(OfBizSearchRequestStore.java:389) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.access$000(OfBizSearchRequestStore.java:48) at com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get(OfBizSearchRequestStore.java:84) at com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get(OfBizSearchRequestStore.java:82) at com.atlassian.jira.ofbiz.DatabaseIterator.pullNext(DatabaseIterator.java:69) at com.atlassian.jira.ofbiz.DatabaseIterator.populateNextIfNull(DatabaseIterator.java:78) at com.atlassian.jira.ofbiz.DatabaseIterator.hasNext(DatabaseIterator.java:41) at com.atlassian.jira.util.collect.CollectionUtil.foreach(CollectionUtil.java:41) at com.atlassian.jira.util.collect.CloseableIterator$Functions.foreach(CloseableIterator.java:58) at com.atlassian.jira.ofbiz.DatabaseIterable.foreach(DatabaseIterable.java:45) at com.atlassian.jira.util.collect.TransformingEnclosedIterable.foreach(TransformingEnclosedIterable.java:29) at com.atlassian.studio.importer.DefaultStudioImportManager.updateGroupName(DefaultStudioImportManager.java:400) at com.atlassian.studio.importer.DefaultStudioImportManager.postImportStudify(DefaultStudioImportManager.java:298) at com.atlassian.jira.studio.importer.StudioImport.doImport(StudioImport.java:100) ... Caused by: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null) at com.atlassian.jira.jql.parser.DefaultJqlQueryParser.parseClause(DefaultJqlQueryParser.java:135) at com.atlassian.jira.jql.parser.DefaultJqlQueryParser.parseQuery(DefaultJqlQueryParser.java:37) at sun.reflect.GeneratedMethodAccessor274.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.atlassian.jira.ProxyAdapter$ProxiedComponentInvocationHandler.invoke(ProxyAdapter.java:167) at $Proxy141.parseQuery(Unknown Source) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:410) ... 122 more Caused by: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null) at com.atlassian.jira.jql.parser.antlr.LexerErrorHelper.handleError(LexerErrorHelper.java:54) at com.atlassian.jira.jql.parser.antlr.JqlLexer.recover(JqlLexer.java:121) at com.atlassian.jira.jql.parser.antlr.JqlLexer.recover(JqlLexer.java:127) at com.atlassian.jira.jql.parser.antlr.JqlLexer.mERROR_RESERVED(JqlLexer.java:1511) at com.atlassian.jira.jql.parser.antlr.JqlLexer.mTokens(JqlLexer.java:2207) at org.antlr.runtime.Lexer.nextToken(Lexer.java:84) at org.antlr.runtime.CommonTokenStream.fillBuffer(CommonTokenStream.java:119) at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:238) at com.atlassian.jira.jql.parser.antlr.JqlParser.query(JqlParser.java:191) at com.atlassian.jira.jql.parser.DefaultJqlQueryParser.parseClause(DefaultJqlQueryParser.java:124) ... 129 more Caused by: MismatchedSetException(46!=null) at com.atlassian.jira.jql.parser.antlr.JqlLexer.recover(JqlLexer.java:126) ... 136 more {noformat} It would appear that one of the filters being loaded has invalid JQL. I don't think this should stop them from being loaded from the database by the {{DatabaseIterable}} though. This error occurred after a fresh JIRA import (that's probably how the corrupt filter got in there), during the Studio import process. \\ \\ *Cause* An invalid character gets stored into *searchrequest* the database, for example the query is stored like this: {code} fixVersion = 3.0 {code} * this causes problems as JIRA cannot properly parse the 3.0 Instead, what should be stored is: {code} fixVersion = "3.0" {code} * It is not known how the JQL gets improperly stored into the db

    Atlassian JIRA | 7 years ago | James Roper [Atlassian]
    com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException:com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null)
  2. 0

    The following code: {code:java} searchRequestManager.getAll().foreach(new SharedEntityGroupUpdator<SearchRequest>(oldName, newName, filterPermissions)); {code} is throwing the following exception: {noformat} com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException:com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:415) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.convertGVToRequest(OfBizSearchRequestStore.java:389) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.access$000(OfBizSearchRequestStore.java:48) at com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get(OfBizSearchRequestStore.java:84) at com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get(OfBizSearchRequestStore.java:82) at com.atlassian.jira.ofbiz.DatabaseIterator.pullNext(DatabaseIterator.java:69) at com.atlassian.jira.ofbiz.DatabaseIterator.populateNextIfNull(DatabaseIterator.java:78) at com.atlassian.jira.ofbiz.DatabaseIterator.hasNext(DatabaseIterator.java:41) at com.atlassian.jira.util.collect.CollectionUtil.foreach(CollectionUtil.java:41) at com.atlassian.jira.util.collect.CloseableIterator$Functions.foreach(CloseableIterator.java:58) at com.atlassian.jira.ofbiz.DatabaseIterable.foreach(DatabaseIterable.java:45) at com.atlassian.jira.util.collect.TransformingEnclosedIterable.foreach(TransformingEnclosedIterable.java:29) at com.atlassian.studio.importer.DefaultStudioImportManager.updateGroupName(DefaultStudioImportManager.java:400) at com.atlassian.studio.importer.DefaultStudioImportManager.postImportStudify(DefaultStudioImportManager.java:298) at com.atlassian.jira.studio.importer.StudioImport.doImport(StudioImport.java:100) ... Caused by: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null) at com.atlassian.jira.jql.parser.DefaultJqlQueryParser.parseClause(DefaultJqlQueryParser.java:135) at com.atlassian.jira.jql.parser.DefaultJqlQueryParser.parseQuery(DefaultJqlQueryParser.java:37) at sun.reflect.GeneratedMethodAccessor274.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.atlassian.jira.ProxyAdapter$ProxiedComponentInvocationHandler.invoke(ProxyAdapter.java:167) at $Proxy141.parseQuery(Unknown Source) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:410) ... 122 more Caused by: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null) at com.atlassian.jira.jql.parser.antlr.LexerErrorHelper.handleError(LexerErrorHelper.java:54) at com.atlassian.jira.jql.parser.antlr.JqlLexer.recover(JqlLexer.java:121) at com.atlassian.jira.jql.parser.antlr.JqlLexer.recover(JqlLexer.java:127) at com.atlassian.jira.jql.parser.antlr.JqlLexer.mERROR_RESERVED(JqlLexer.java:1511) at com.atlassian.jira.jql.parser.antlr.JqlLexer.mTokens(JqlLexer.java:2207) at org.antlr.runtime.Lexer.nextToken(Lexer.java:84) at org.antlr.runtime.CommonTokenStream.fillBuffer(CommonTokenStream.java:119) at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:238) at com.atlassian.jira.jql.parser.antlr.JqlParser.query(JqlParser.java:191) at com.atlassian.jira.jql.parser.DefaultJqlQueryParser.parseClause(DefaultJqlQueryParser.java:124) ... 129 more Caused by: MismatchedSetException(46!=null) at com.atlassian.jira.jql.parser.antlr.JqlLexer.recover(JqlLexer.java:126) ... 136 more {noformat} It would appear that one of the filters being loaded has invalid JQL. I don't think this should stop them from being loaded from the database by the {{DatabaseIterable}} though. This error occurred after a fresh JIRA import (that's probably how the corrupt filter got in there), during the Studio import process. \\ \\ *Cause* An invalid character gets stored into *searchrequest* the database, for example the query is stored like this: {code} fixVersion = 3.0 {code} * this causes problems as JIRA cannot properly parse the 3.0 Instead, what should be stored is: {code} fixVersion = "3.0" {code} * It is not known how the JQL gets improperly stored into the db

    Atlassian JIRA | 7 years ago | James Roper [Atlassian]
    com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException:com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null)

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      com.atlassian.jira.jql.parser.JqlParseException:com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedSetException(46!=null)

      at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv()
    2. com.atlassian.jira
      TransformingEnclosedIterable.foreach
      1. com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:415)
      2. com.atlassian.jira.issue.search.OfBizSearchRequestStore.convertGVToRequest(OfBizSearchRequestStore.java:389)
      3. com.atlassian.jira.issue.search.OfBizSearchRequestStore.access$000(OfBizSearchRequestStore.java:48)
      4. com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get(OfBizSearchRequestStore.java:84)
      5. com.atlassian.jira.issue.search.OfBizSearchRequestStore$1.get(OfBizSearchRequestStore.java:82)
      6. com.atlassian.jira.ofbiz.DatabaseIterator.pullNext(DatabaseIterator.java:69)
      7. com.atlassian.jira.ofbiz.DatabaseIterator.populateNextIfNull(DatabaseIterator.java:78)
      8. com.atlassian.jira.ofbiz.DatabaseIterator.hasNext(DatabaseIterator.java:41)
      9. com.atlassian.jira.util.collect.CollectionUtil.foreach(CollectionUtil.java:41)
      10. com.atlassian.jira.util.collect.CloseableIterator$Functions.foreach(CloseableIterator.java:58)
      11. com.atlassian.jira.ofbiz.DatabaseIterable.foreach(DatabaseIterable.java:45)
      12. com.atlassian.jira.util.collect.TransformingEnclosedIterable.foreach(TransformingEnclosedIterable.java:29)
      12 frames
    3. com.atlassian.studio
      DefaultStudioImportManager.postImportStudify
      1. com.atlassian.studio.importer.DefaultStudioImportManager.updateGroupName(DefaultStudioImportManager.java:400)
      2. com.atlassian.studio.importer.DefaultStudioImportManager.postImportStudify(DefaultStudioImportManager.java:298)
      2 frames
    4. com.atlassian.jira
      StudioImport.doImport
      1. com.atlassian.jira.studio.importer.StudioImport.doImport(StudioImport.java:100)
      1 frame