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 Join to answer
Community showcase
Emilee Spencer
Published 8 hours ago in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

30 views 0 3
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