Issue Transitions Tab wrong after JIRA database migration

[Brian Price]

We migrated one project from one JIRA database to a second JIRA database. However, the status values between the two were different. We have been able to use SQL scripts to correct the recorded status values on the migrated project. However, the Issue Transitions tab does not show the correct status information.

We un-installed the plug-in, restarted the JIRA server and re-installed the plug-in. This had no effect.

Is there something we can do to correct the information displayed by the Issue Transitions Tab.

[Nic Brough -Adaptavist-]

It's likely that your SQL scripts missed things, including one or both of the tables in the history (changeitem and changegroup) and the workflows (tables starting OS_)

[Harry Chan]

You'd have to look at the tables that store the history data. That's where the transition tab reads the information. There are probably a few other places to look out for.