Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-729

Migrate all boards feature is not working in some versions

    XMLWordPrintable

Details

    • 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

      1. Install Jira v7.7
      2. Create some Software projects
      3. Enable the dark features to migrate all boards and filters
      4. 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

          Activity

            People

              Unassigned Unassigned
              cteh Ting (Chiou Ting Teh)
              Votes:
              3 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: