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

Migration of Advanced Roadmaps on Oracle fails

    XMLWordPrintable

Details

    • 1
    • Severity 2 - Major

    Description

      Issue Summary

      This is reproducible on Data Center: yes

      Steps to Reproduce

      1. Setup a Jira instance with Oracle
      2. Setup an AR plan with a mix of private and public filters
      3. Attempt to migrate using project by project migration

      Expected Results

      Migration succeeds

      Actual Results

      Failure with a Database Syntax exception

      Caught SQLSyntaxErrorException for select distinct "AO_D9132D_ISSUE_SOURCE"."PLAN_ID"
      ...
      SQL Error [932] [42000]: ORA-00932: inconsistent datatypes: expected - got CLOB

      full trace

      2022-03-15 15:34:48,890-0400 https-xyz-abc-8443-exec-14 url: /rest/migration/latest/advanced-roadmaps/plans/; user: user: ********* INFO ********* 934x57084x6 ***** 10.xx.xx.x /rest/migration/latest/advanced-roadmaps/plans/ [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: Caught SQLSyntaxErrorException for select distinct "AO_D9132D_ISSUE_SOURCE"."PLAN_ID" from "AO_D9132D_ISSUE_SOURCE" "AO_D9132D_ISSUE_SOURCE" where "AO_D9132D_ISSUE_SOURCE"."SOURCE_TYPE" = ? and not ("AO_D9132D_ISSUE_SOURCE"."SOURCE_VALUE" in  or "AO_D9132D_ISSUE_SOURCE"."SOURCE_VALUE" in  or "AO_D9132D_ISSUE_SOURCE"."SOURCE_VALUE" in or "AO_D9132D_ISSUE_SOURCE"."SOURCE_VALUE" in (or "AO_D9132D_ISSUE_SOURCE"."SOURCE_VALUE" in
               at com.atlassian.jira.migration.export.db.advancedroadmaps.PlanDataReader.getAllPlanIDsForPrivateFilterIssueSource$lambda-11(PlanDataReader.kt:139)
               at com.atlassian.jira.migration.export.db.advancedroadmaps.PlanDataReader.getAllPlanIDsForPrivateFilterIssueSource(PlanDataReader.kt:130)
               at com.atlassian.jira.migration.export.db.advancedroadmaps.PlanDataReader.pagination(PlanDataReader.kt:90)
               at com.atlassian.jira.migration.serverdataextractors.AdvancedRoadmapsDataResource.listPlans(AdvancedRoadmapsDataResource.kt:56)
      2022-03-15 15:34:48,925-0400 https-xyz-abc-8443-exec-23 url: /rest/migration/latest/user-interface/log; user: ****** ERROR ****** 934x57086x5 ****** 10.xx.x.x /rest/migration/latest/user-interface/log [c.a.j.migration.userinterface.UserInterfaceLoggingResource] Loader Component error - Error: Request failed with status code 500
              at t.exports (https://abc-test.someurl.org:8443/s/o7sydh/813013/62m8v1/1.6.8/_/download/resources/com.atlassian.jira.migration.jira-migration-plugin:static-resources/fe-resources/vendors.80904690ae541d91481d.js:155:3048676)
              at t.exports (https://abc-test.someurl.org:8443/s/o7sydh/813013/62m8v1/1.6.8/_/download/resources/com.atlassian.jira.migration.jira-migration-plugin:static-resources/fe-resources/vendors.80904690ae541d91481d.js:186:1298)
      ...
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              bmorgan Benjamin Morgan
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: