Details
-
Bug
-
Resolution: Fixed
-
Low
-
None
-
None
-
None
-
1
-
Severity 2 - Major
Description
Issue Summary
This is reproducible on Data Center: yes
Steps to Reproduce
- Setup a Jira instance with Oracle
- Setup an AR plan with a mix of private and public filters
- 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
- duplicates
-
MIG-1008 Customer is unable to choose the 'Advanced Roadmap Plan' while migrating from Server to Cloud via JCMA
- Closed
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...