com.atlassian.jira.exception.DataAccessException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • When there is an invalid search filter in JIRA, the upgradeTask 13 will got stuck upon upgrading/installing JIRA Agile. The following error will be thrown in atlassian-jira.log: {code} 2014-03-07 16:06:34,368 localhost-startStop-1 ERROR [sal.core.upgrade.PluginUpgrader] Upgrade failed: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(8@[467:1: operator returns [Operator operator] : ( EQUALS | NOT_EQUALS | LIKE | NOT_LIKE | LT | GT | LTEQ | GTEQ | IN | IS NOT | IS | NOT IN | WAS | WAS NOT | WAS IN | WAS NOT IN | CHANGED );]) com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(8@[467:1: operator returns [Operator operator] : ( EQUALS | NOT_EQUALS | LIKE | NOT_LIKE | LT | GT | LTEQ | GTEQ | IN | IS NOT | IS | NOT IN | WAS | WAS NOT | WAS IN | WAS NOT IN | CHANGED );]) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:471) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.convertGVToRequest(OfBizSearchRequestStore.java:445) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.access$000(OfBizSearchRequestStore.java:57) .... {code} There is no easy way to find the invalid filter in JIRA. In this case, we have two options # The upgrade task should not care with the invalid JIRA filter # Improve the error logging to point out the offending filter
    via by Vicky Kharisma [Atlassian],
  • When there is an invalid search filter in JIRA, the upgradeTask 13 will got stuck upon upgrading/installing JIRA Agile. The following error will be thrown in atlassian-jira.log: {code} 2014-03-07 16:06:34,368 localhost-startStop-1 ERROR [sal.core.upgrade.PluginUpgrader] Upgrade failed: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(8@[467:1: operator returns [Operator operator] : ( EQUALS | NOT_EQUALS | LIKE | NOT_LIKE | LT | GT | LTEQ | GTEQ | IN | IS NOT | IS | NOT IN | WAS | WAS NOT | WAS IN | WAS NOT IN | CHANGED );]) com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(8@[467:1: operator returns [Operator operator] : ( EQUALS | NOT_EQUALS | LIKE | NOT_LIKE | LT | GT | LTEQ | GTEQ | IN | IS NOT | IS | NOT IN | WAS | WAS NOT | WAS IN | WAS NOT IN | CHANGED );]) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:471) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.convertGVToRequest(OfBizSearchRequestStore.java:445) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.access$000(OfBizSearchRequestStore.java:57) .... {code} There is no easy way to find the invalid filter in JIRA. In this case, we have two options # The upgrade task should not care with the invalid JIRA filter # Improve the error logging to point out the offending filter
    via by Vicky Kharisma [Atlassian],
  • 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
    via by James Roper [Atlassian],
  • 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
    via by James Roper [Atlassian],
    • com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: NoViableAltException(8@[467:1: operator returns [Operator operator] : ( EQUALS | NOT_EQUALS | LIKE | NOT_LIKE | LT | GT | LTEQ | GTEQ | IN | IS NOT | IS | NOT IN | WAS | WAS NOT | WAS IN | WAS NOT IN | CHANGED );]) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.getSearchQueryFromGv(OfBizSearchRequestStore.java:471) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.convertGVToRequest(OfBizSearchRequestStore.java:445) at com.atlassian.jira.issue.search.OfBizSearchRequestStore.access$000(OfBizSearchRequestStore.java:57)
    No Bugmate found.