Details
-
Bug
-
Resolution: Timed out
-
Low
-
None
-
None
-
5
-
Severity 3 - Minor
-
2
Description
Issue Summary
Unable to migrate all boards due missing of OLD_DONE_ISSUES_CUTOFF column on AO_60DB71_RAPIDVIEW column
Steps to Reproduce
- Install Jira v7.7
- Create some Software projects
- Enable the dark features to migrate all boards and filters
- Migrate the projects to Cloud using Jira Cloud Migration Assistant
Expected Results
Migration goes through successfully
Actual Results
- Migration couldn't pass the pre-flight check and shows error in the logs:
2021-08-02 11:26:43,569 pool-56-thread-25 ERROR admin 686x1445x1 znp2rw 0:0:0:0:0:0:0:1 /rest/migration/latest/check/d7383ebaab1aa90bcace13fda8e0cfec06565b0d [c.a.j.m.export.framework.DefaultExportFailureHandler] d7383ebaab1aa90bcace13fda8e0cfec06565b0d: Exporting referenced entities by Project KAN failed com.querydsl.core.QueryException: Caught PSQLException for select distinct "AO_60DB71_RAPIDVIEW"."ID", "AO_60DB71_RAPIDVIEW"."NAME", "AO_60DB71_RAPIDVIEW"."SAVED_FILTER_ID", "AO_60DB71_RAPIDVIEW"."CARD_COLOR_STRATEGY", "AO_60DB71_RAPIDVIEW"."OLD_DONE_ISSUES_CUTOFF", "AO_60DB71_RAPIDVIEW"."OWNER_USER_NAME", "AO_60DB71_RAPIDVIEW"."SHOW_DAYS_IN_COLUMN", "AO_60DB71_RAPIDVIEW"."SHOW_EPIC_AS_PANEL", "AO_60DB71_RAPIDVIEW"."SPRINTS_ENABLED", "AO_60DB71_RAPIDVIEW"."SWIMLANE_STRATEGY" from "public"."AO_60DB71_RAPIDVIEW" "AO_60DB71_RAPIDVIEW" order by "AO_60DB71_RAPIDVIEW"."ID" asc limit ? offset ? . . . . . . Caused by: org.postgresql.util.PSQLException: ERROR: column AO_60DB71_RAPIDVIEW.OLD_DONE_ISSUES_CUTOFF does not exist Position: 161 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446) ... 50 more
Notes
- JCMA supports version 7.6.0 or later as documented here
- However, OLD_DONE_ISSUES_CUTOFF column is meant for "Hide completed issues older than" feature, and it was introduced on 7.6.5, 7.8.2, 7.9.0 and later. Some versions between 7.6 - 7.9 don't have this feature.
- Managed to reproduce the error on 7.7.0 & 7.8.0. The migration works on 7.6.5.
- Affected version:
7.6.0, 7.6.1, 7.6.2, 7.6.3, 7.6.4 7.7.0, 7.7.1, 7.7.2, 7.7.3, 7.7.4 7.8.0, 7.8.1
Workaround
Upgrade to 7.6.5, 7.8.2, 7.9.0 or later, which contain "Hide completed issues older than" feature
Attachments
Issue Links
- mentioned in
-
Page Loading...