Deinstallation of QandA add-on and impact on restoring JIRA

[francis]

We found following issue - not sure if it is solely related to this add-on.

We evaluated QandA but decided not to use it (although it is a nice add-on)
A couple of days later we wanted to deploy our JIRA in test by restoring a backup.
We got at that moment an error

Error importing data: java.lang.IllegalArgumentException: [GenericDelegator.makeValue] could not find entity for entityName: QANDAQ

Apparently the backup still contains tables which shouldn't be there anymore after the deinstall.
Is this specific to the add-on and what should we do to ensure that the add-on is completely deinstalled ?

[Radu Dumitriu · Accepted solution]

Hi

You need to drop the tables *before* backup

-OR-

restore the backup with the plugin installed, then drop them.

Unfortunately we have no way to know when the plugin is uninstalled to drop the tables ourselves. In any case, even if I would have such event, I would be reluctant to implement such functionality (you may want to do other administrative function, not get rid of the data)

Anyway, run the following script to drop the tables:

--

DROP TABLE QANDAA;

DROP TABLE QANDAQ;

--

HTH,

Radu

P.S. Still, why not using it, if you say it's nice ?

[francis]

We need to have a workflow associated to a question, and a subtask the way to go.