Cannot delete Rapid Board

お困りですか?

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

コミュニティに質問

症状

Creating a Rapid Board failed, leaving an incomplete Rapid Board. The incomplete Rapid Board cannot be deleted

atlassian-jira.log に次のエラーが返されます。

java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "fk_ao_60db71_column_rapid_view_id". The conflict occurred in database "<database_name>", table "jiraschema.AO_60DB71_COLUMN", column 'RAPID_VIEW_ID'.

原因

The cause of this issue is not known at this time.

ソリューション

Please be sure to back up your database prior to making changes.


  1. First, we must determine the Rapid Board ID of the missing board:


SELECT ID FROM ao_60db71_rapidview WHERE NAME = '<your rapid board name>';

2. Then, delete all entries from the Column list for that board:

DELETE FROM ao_60db71_column WHERE RAPID_VIEW_ID = <your rapid view ID from step 1>;

最終更新日 2020 年 6 月 3 日

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

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