Cannot delete Rapid Board

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

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

The following appears in the 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'.

Cause

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

Resolution

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>;

Last modified on Jun 3, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.