nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Instance Health Checks

Sabel Systems

I keep getting this error in the Jira console. Running ver 8.4.1 and using SQL server 2014

The database collation 'SQL_Latin1_General_CP1_CI_AS' and table collation 'SQL_Latin1_General_CP1_CI_AS' are not supported by Jira

I have read several posts about the same message.

What is the fix?

Accepted answers

Alexis Robert

Hi @Sabel Systems ,

this means that your database collation is not configured properly, you are using a Case Insensitive collation whereas Confluence only supports Case Sensitive as you can see here : https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html#DatabaseSetupforSQLServer-2.Createadatabaseanddatabaseuser

You will need to ask your database admin to fix the database collation.

Let me know if this works,

--Alexis

All comments

Alexis Robert

Hi @Sabel Systems ,

You will need to ask your database admin to fix the database collation.

Let me know if this works,

--Alexis

Sabel Systems

Are there steps that someone could share to do this? I set the database up for this instance.

Sabel Systems

If I run this command, it breaks JIRA when it tries to start:



ALTER DATABASE <database-name> COLLATE SQL_Latin1_General_CP1_CS_AS

Alexis Robert

Hi @Sabel Systems ,

the clean way to do this is to do a full XML export in Confluence first, and then setup Confluence with a new database (with the correct collation) and import the data.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server