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

This widget could not be displayed.

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
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,488 views 10 12
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