Cannot delete Rapid Board
Creating a Rapid Board failed, leaving an incomplete Rapid Board. The incomplete Rapid Board cannot be deleted
The following appears in the
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.
- 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>;