Jira server throws column name SQLException on upgrade or installation

お困りですか?

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

コミュニティに質問

症状

  • Database Server used is Microsoft SQL Server
  • atlassian-jira.log に次のメッセージが表示される。
 java.sql.SQLException: Invalid column name '<column_name>'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)

診断と原因

Identify the collation used for the JIRA database in MS SQL Server by executing the following SQL query and substituting JIRADB with the database used in your installation. The name of the database could be identified from the database configuration file at $JIRA_HOME/dbconfig.xml.

SELECT name, collation_name FROM sys.databases WHERE name='JIRADB';

The recommended collation for the JIRA database in MS SQL Server is SQL_Latin1_General_CP437_CI_AI. The SQL Exception occurs due to collation problems

  • When an case sensitive collation is used. The text "_CS_" in the collation name indicates case sensitive collation instead of "_CI" for a case insensitive one.
  • The exception is also observed with accent sensitive – indicated by "AS" – collations like Turkish_CI_AS.

ソリューション

オプション 1

Change the database collation to the recommended SQL_Latin1_General_CP437_CI_AI using the following Microsoft documentation:

オプション 2

Create a new database for JIRA using the recommended collation SQL_Latin1_General_CP437_CI_AI using the following documentation:

Configure JIRA to use this database and re-try the installation or upgrade.

最終更新日 2019 年 9 月 25 日

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

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