Cannot remove data from Jira DB Table

Thomas Hardin

We are in the process of migrating data from an older version of Jira, however; when we attempt to create a snapshot of the project with issues, we get an error that indicates a filter no longer exists. 

We conducted a search for the board, with the board owner, in Jira and cannot find it. After searching the DB with a select query, "select * from AO_60DB71_RAPIDVIEW where id = '63'", we get an error that indicates the following:

[Code: 0, SQL State: 42P01] ERROR: relation "ao_60db71_rapidview" does not exist
Position: 15

What's odd is that I can open the table and find the board by scrolling through the list, but I cannot delete it.

I'm using Configuration Manager for my migration and it shows the board when you navigate through the snapshot options. 

Thoughts anyone?

Andy Heinzer

I recognize the specific SQL error you posted.   This happens because these AO tables in the Jira database are different from the rest of the tables.  At least in a Postgresql database, you always have to refer to them when encapsulated by double quotes.  Instead of your query, try this:

select * FROM "AO_60DB71_RAPIDVIEW";

This should at least let you see all the entries of that table, and you can refine that down to

select * FROM "AO_60DB71_RAPIDVIEW" where "ID"=63;

Even the column names of these tables also have to be in double quotes.

 

I would also recommend checking out the KB Boards Are Not Visible After the Filter is Deleted It appears to be very much on topic for the scenario you describe.