SQL Server migration fails due to wrong Database user permissions
プラットフォームについて: Data Center のみ。 - This article only applies to Atlassian apps on the Data Center プラットフォーム。
この KB は Data Center バージョンの製品用に作成されています。Data Center 固有ではない機能の Data Center KB は、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。 Server* 製品のサポートは 2024 年 2 月 15 日に終了しました。Server 製品を実行している場合は、 アトラシアン Server サポート終了 のお知らせにアクセスして、移行オプションを確認してください。
*Fisheye および Crucible は除く
問題
Migration to external SQL Server database fails with UI error below:
Creating table definitions...
Problem with create tables script C:\atlassian-fisheye-crucible\sql\SQLSERVER2008\schema\tables_76.sql
Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script C:\atlassian-fisheye-crucible\sql\SQLSERVER2008\schema\tables_76.sqlThe following is logged in fisheye-debug.log
2012-07-10 10:23:03,240 ERROR [ThreadPool1 ] fisheye.app DBEditHelper-doGet - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script C:\atlassian-fisheye-crucible\sql\SQLSERVER2008\schema\tables_76.sql
com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script C:\atlassian-fisheye-crucible\sql\SQLSERVER2008\schema\tables_76.sql
at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:292)
at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:138)
at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:91)
at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:73)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cru_base_star_model (cru_star_id int not null, cru_item_type nvarchar(80) not null, cru_string_key1 nvarchar(255) null, cru_string_key2 nvarchar(255) null, cru_string_key3 nvarchar(255) null, cru_string_key4 nvarchar(255) null, cru_string_key5 nvarchar(255) null, cru_int_key1 int null, cru_int_key2 int null, cru_int_key3 int null, cru_int_key4 int null, cru_int_key5 int null, cru_text_key1 nvarchar(max) null, cru_text_key2 nvarchar(max) null, cru_user_name nvarchar(255) null, cru_date_created numeric(19,0) null, cru_label nvarchar(255) null, primary key (cru_star_id));"
(CREATE TABLE permission denied in database 'fisheyedb'.), please contact http://www.atlassian.com/support/
at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:483)
at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:414)
at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:286)
... 10 more
Caused by: java.sql.SQLException: CREATE TABLE permission denied in database 'fisheyedb'.
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)
... 12 more原因
The migration script tries to create a table in the Fisheye database, but the user doesn't have permission to create tables.
ソリューション
Make sure that the user that Fisheye uses to connect to the database has all the needed permission. Please refer to our documentation about Migration to SQL Server for more information.
この内容はお役に立ちましたか?