Database Collation health check fails in Jira Server when using SQL Server

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

目的

This check retrieves the collation of the database and determines if it is within the list of collations supported by Atlassian. This article focuses on Microsoft SQL Server. For more about details please check Database Collation Health Check fails in Jira Server.

結果の確認 

The database collation '<collation>' and table collation '<collation>' are supported by JIRA.

The database is configured using a supported collation.

The database collation '<collation>' and table collation '<collation>' are not supported by JIRA.

The JIRA instance is using an unsupported configuration. See the Resolution section for steps on how to resolve this issue.

The database collation '<collation>' is unsupported by JIRA. The table collation '<collation>' is supported by JIRA.

The JIRA instance is using an unsupported configuration. See the Resolution section for steps on how to resolve this issue.

The table collation '<collation>' is unsupported by JIRA. The database collation '<collation>' is supported by JIRA.

The JIRA instance is using an unsupported configuration. See the Resolution section for steps on how to resolve this issue.

ソリューション 

To fix this, the database collation needs to be corrected. The best and recommended way to achieve this is:

  1. Create a new database with the required collation as per the appropriate documentation in Connecting JIRA to a Database.
  2. Follow our Switching Databases to migrate JIRA from the old databases (with the incorrect collation) to the new one, with the correct collation.

Supported Collations in Microsoft SQL Server

  • SQL_Latin1_General_CP437_CI_AI
  • Latin1_General_CI_AI

How to Verify Table Collations

SELECT DISTINCT C.collation_name 
FROM   sys.tables AS T 
       INNER JOIN sys.columns C 
               ON T.object_id = C.object_id 
WHERE  collation_name IS NOT NULL; 

How to Verify Database Collations

SELECT DISTINCT C.collation_name 
FROM   sys.tables AS T 
       INNER JOIN sys.columns C 
               ON T.object_id = C.object_id 
WHERE  collation_name IS NOT NULL; 

There is a known bug where Latin1_General_CI_AI is displayed as an unsupported database in JIRA. The bug fix is released on JIRA 7.8.0  JRASERVER-59378 - Getting issue details... STATUS

説明This check retrieves the collation of the database and determines if it is within the list of collations supported by Atlassian. This article focuses on Microsoft SQL Server.
製品Jira, Confluence, Bamboo, Bitbucket, Fisheye, Crucible
プラットフォームサーバー
最終更新日 2019 年 9 月 25 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.