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 votes

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 Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

527 views 1 15
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot