Collation Conflict During Page Creation When Using MS SQL Server Database

お困りですか?

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

コミュニティに質問

問題

  1. After an upgrade or database migration, when creating a page and clicking the Save button, the page is lost.
  2. Another symptom might be that you're able to create a new page, but cannot edit and save existing pages.
  3. The database in use is Microsoft SQL Server.

atlassian-confluence.log に次のエラーが返される。

2012-05-01 19:53:49,934 ERROR [TP-Processor5] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP850_BIN" in the equal to operation.
 -- referer: http://localhost:8080/pages/docreatepage.action | url: /pages/docreatepage.action | userName: admin | action: docreatepage

診断

古いデータベースで次のクエリを実行します。何らかの結果が返される場合は Confluence の新しいバージョンにアップグレードする前に照合を調整する必要があります。

SELECT object_name(object_id) as TableName, name as ColumnName, collation_name
FROM sys.columns
WHERE collation_name <> 'SQL_Latin1_General_CP1_CS_AS'
AND object_name(object_id) NOT LIKE 'sys%'
AND object_name(object_id) NOT LIKE 'queue%'
AND object_name(object_id) NOT LIKE 'file%'
AND object_name(object_id) NOT LIKE 'spt%'
AND object_name(object_id) NOT LIKE 'MSrep%'

 

原因

This issue is caused by a conflict between the collation of some table columns.

ソリューション

There are several solutions:

Make sure to backup your Confluence database before trying any of those methods.

  1. Follow the steps on the "How to fix the collation of a MSSQL Confluence Database"
  2. Export an xml backup and import it into a new instance of the same version of Confluence, which has the correct collation settings as described in this article. This solution may not work for larger instances.
  3. Use the Collation Changer Tool. Note that this is a third party tool and not supported by Atlassian. Use at your own risk.
  4. Your DB admin may be able to fix your database using a data migration tool.
  5. Contact an Atlassian Expert who can give you hands on assistance.
最終更新日: 2017 年 10 月 19 日

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

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