Jira 7.7.0 (AO 1.5.0)
Any Jira using AO version > 0.28.5
Any Oracle supported version
Install Portfolio 2.13.1
In database table AO_D9132D_SCENARIO_ISSUE_LABEL:
Remove index from LABEL column
Remove LABEL column
Add LABEL column with CLOB type (don't add index)
Jira runs successfully despite different column type.
Error can be seen in the log:
AO tries to change column type. This opration fails, because it tries to remove missing index in the middle of migration. Temporary column is left in the table that makes it impossible to repeat the process. Next and subsequent Jira starts will report error:
While having both original and temporary columns created by AO you can finish migration manually by:
Dropping original column. e.g.
Renaming temporary column back to actual column
It can happen when migrating from Cloud to Server.
Code behind the problem: source