SQL Server DB Collation - Inconsistent Documentation Edited

I completed a clean install of Jira 7.3.8 using MS SQL Server as the DB on the backend. Based on the documentation in the below two reference articles, Latin1_General_CI_AI is one of the two supported Collations:

 

https://confluence.atlassian.com/adminjiraserver072/connecting-jira-applications-to-sql-server-2012-828787572.html

https://confluence.atlassian.com/adminjiraserver073/connecting-jira-applications-to-sql-server-2012-861253047.html

 

After some initial config of my 7.3.8 system, I proceeded to upgrade to 7.6.2. Post upgrade I received the following warning accessing Jira for the first time:

The following warnings should be fixed, but you can choose to ignore them and continue starting JIRA.
Database: Your database is using an unsupported collation
Your mssql database is currently using an unsupported collation: Latin1_General_CI_AI. You should change this to a supported collation:
SQL_Latin1_General_CI_AI
SQL_Latin1_General_CP437_CI_AI

 

Can anyone advise which is actually correct (Latin1_General_CI_AI or SQL_Latin1_General_CI_AI) as there is clearly a discrepancy in the documentation vs the startup check.

 

1 answer

0 vote

Hi David,

It seems that you are being affected by JRASERVER-59378.

At this time please vote on JRASERVER-59378 and for the time being ignore the Error in the logs and confirm the supported collation with the JIRA Instance Health Add-on per the workaround in JRASERVER-59378.

Cheers,

Branden

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

13,127 views 15 13
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you