Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Error in access issues after changing database collation

Анна Шварцман August 3, 2021

JIRA: v7.13.1

DB: Microsoft SQL

We changed DB collation from: Hebrew_CI_AS to: Latin1_General_CI_AI

according to 

https://confluence.atlassian.com/jirakb/how-to-fix-the-collation-of-microsoft-sql-server-database-for-jira-manually-776646810.html

After that we cannot access to the issues by <JIRA-URL>/browse/<JIRA-ISSUE>

We got "ERROR OCCURRED" on the Chrome window and in the log:

2021-08-03 17:50:29,069 http-nio-8080-exec-18 ERROR 1070x38178x1 jhlrja 172.24.2.207 /browse/DIGITAL-10910 [c.a.j.web.servlet.InternalServerErrorServlet] {errorId=937ad155-c5eb-40a9-81fa-e74a3ca14ac7, interpretedMsg=, cause=com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedTokenException(144!=34), stacktrace=com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: com.atlassian.jira.jql.parser.JqlParseException: com.atlassian.jira.jql.parser.antlr.RuntimeRecognitionException: MismatchedTokenException(144!=34)

What can be reason for this behavior?

Thanks in advance

 

0 answers

Suggest an answer

Log in or Sign up to answer