We couldn't start JIRA

Hi there, We are using Jira Software and Jira Service Desk since october and today we found a problem accessing JIRA.

We were using the same collation described in the documentation and Jira and Jira Service Desk was running until today!

https://confluence.atlassian.com/adminjiraserver075/connecting-jira-applications-to-sql-server-2014-935390859.html

We are using the server version in Windows.

This is the message:

 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


Review our documentation for more information on supported collations.

 

1 answer

1 vote

Hi Isaac,

It may be that some tables or some other aspect of the database have ended up with the incorrect collation even though your database is overall correct.

Could you please have a look at Does this apply to me? from How to fix the collation of a Microsoft SQL Database. It should let you know what part of the database isn't correct and then the steps to correct it.

I hope this helps!

Kind regards,

Shannon

Hi there Shannon,

I finally found the real problem, we did not have free space on the database server!!! Then JIRA can't start because it can not write on the database but shows the error commented in the post.

Thanks for your reply!

Thank you for letting us know, Isaac! 

Have a pleasant week.

Shannon

Suggest an answer

Log in or Sign up to answer
Community showcase
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...

17,662 views 18 20
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