We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-1340

AO_D9132D_PLAN SQL exception error thrown while creating JCMA plan for Jira

    • 10
    • Minor
    • 35

      Issue Summary

      A spurious Advanced Roadmaps error is thrown when attempting to create a migration plan.

      Steps to Reproduce

      Environment details unclear.

      Replicated in three cases with:

      • JCMA 1.7.8 and JCMA 1.8.0
      • Jira Software 8.5.1+
      • Reproduced in Oracle 12c and SQL Server
      • Advanced Roadmaps is not installed, potentially previously trialled at one stage
      1. Open Jira Cloud Migration Assistant
      2. Create new migration plan

      Expected Results

      • Migration plan can be created
      • Error is not thrown

      Actual Results

      The below exception is thrown in the atlassian-jira.log file:

      2023-03-08 12:02:27,995 http-nio-8080-exec-9 ERROR xxxxxxx 722x26848x1 pf233v 10.10.10.10 /rest/migration/latest/check/652cddcfbd12eefb1002acbd60f84efb95b12f51 [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: Caught SQLSyntaxErrorException for select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= ?
      com.querydsl.core.QueryException: Caught SQLSyntaxErrorException for select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= ?
      	at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
      	at com.querydsl.sql.Configuration.translate(Configuration.java:459)
      	at com.querydsl.sql.AbstractSQLQuery.iterateSingle(AbstractSQLQuery.java:410)
      	at com.querydsl.sql.AbstractSQLQuery.iterate(AbstractSQLQuery.java:342)
      	at com.querydsl.sql.ProjectableSQLQuery.fetchOne(ProjectableSQLQuery.java:397)
      	at com.querydsl.core.support.FetchableQueryBase.fetchFirst(FetchableQueryBase.java:51)
      	at com.atlassian.jira.migration.export.db.advancedroadmaps.PlanDataReader.hasPlans$lambda$0(PlanDataReader.kt:65)
      	at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(DatabaseAccessorImpl.java:69)
      	at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:87)
      	at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(DefaultTransactionalExecutor.java:43)
      	at com.atlassian.jira.database.DatabaseAccessorImpl.runInManagedTransaction(DatabaseAccessorImpl.java:131)
      	... 2 filtered
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
      	at com.sun.proxy.$Proxy552.runInManagedTransaction(Unknown Source)
      	... 2 filtered
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:131)
      	at com.sun.proxy.$Proxy552.runInManagedTransaction(Unknown Source)
      	at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.runInStartedOrExistingTransaction(JiraHostConnectionAccessor.java:130)
      	at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:60)
      	at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:40)
      	at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(DatabaseAccessorImpl.java:67)
      	at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInTransaction(DatabaseAccessorImpl.java:43)
      	at com.atlassian.pocketknife.api.querydsl.DatabaseAccessor.run(DatabaseAccessor.java:201)
      	at com.atlassian.jira.migration.export.db.advancedroadmaps.PlanDataReader.hasPlans(PlanDataReader.kt:61)
      	at com.atlassian.jira.migration.preflight.PreflightService.hasARPlans(PreflightService.kt:552)
      	at com.atlassian.jira.migration.preflight.PreflightService.getChecksToRemove(PreflightService.kt:438)
      	at com.atlassian.jira.migration.preflight.PreflightService.executeChecksForDraftPlan(PreflightService.kt:199)
      	at com.atlassian.jira.migration.preflight.PreflightService.executeChecksForDraftPlan$default(PreflightService.kt:179)
      	at com.atlassian.jira.migration.preflight.rest.PreflightResource.executeChecks(PreflightResource.kt:56)
      	... 3 filtered
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	... 19 filtered
      	at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:159)
      	... 1 filtered
      	at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:69)
      	... 36 filtered
      	at com.atlassian.diagnostics.internal.platform.monitor.http.HttpRequestMonitoringFilter.doFilter(HttpRequestMonitoringFilter.java:55)
      	... 8 filtered
      	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
      	... 46 filtered
      	at com.resolution.atlasplugins.samlsso.servlet.RedirectToSsoFilter.doFilter(RedirectToSsoFilter.java:60)
      	... 3 filtered
      	at com.atlassian.troubleshooting.thready.filter.AbstractThreadNamingFilter.doFilter(AbstractThreadNamingFilter.java:46)
      	... 14 filtered
      	at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
      	... 1 filtered
      	at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
      	... 16 filtered
      	at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)
      	... 19 filtered
      	at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
      	... 10 filtered
      	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
      	... 4 filtered
      	at com.atlassian.troubleshooting.thready.filter.AbstractThreadNamingFilter.doFilter(AbstractThreadNamingFilter.java:46)
      	... 3 filtered
      	at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
      	... 26 filtered
      	at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
      	... 25 filtered
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
      	at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:42)
      	at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeQuery$5(DiagnosticPreparedStatement.java:59)
      	at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:69)
      	at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55)
      	at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeQuery(DiagnosticPreparedStatement.java:59)
      	at com.querydsl.sql.AbstractSQLQuery.iterateSingle(AbstractSQLQuery.java:370)
      	... 283 more
      Caused by: Error : 942, Position : 52, Sql = select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= :1 , OriginalSql = select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= ?, Error Msg = ORA-00942: table or view does not exist
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      	... 305 more
      

      Workaround

      Install a compatible version of Advanced Roadmaps - Marketplace link

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            Uploaded image for project: 'Migration Platform'
            1. Migration Platform
            2. MIG-1340

            AO_D9132D_PLAN SQL exception error thrown while creating JCMA plan for Jira

              • 10
              • Minor
              • 35

                Issue Summary

                A spurious Advanced Roadmaps error is thrown when attempting to create a migration plan.

                Steps to Reproduce

                Environment details unclear.

                Replicated in three cases with:

                • JCMA 1.7.8 and JCMA 1.8.0
                • Jira Software 8.5.1+
                • Reproduced in Oracle 12c and SQL Server
                • Advanced Roadmaps is not installed, potentially previously trialled at one stage
                1. Open Jira Cloud Migration Assistant
                2. Create new migration plan

                Expected Results

                • Migration plan can be created
                • Error is not thrown

                Actual Results

                The below exception is thrown in the atlassian-jira.log file:

                2023-03-08 12:02:27,995 http-nio-8080-exec-9 ERROR xxxxxxx 722x26848x1 pf233v 10.10.10.10 /rest/migration/latest/check/652cddcfbd12eefb1002acbd60f84efb95b12f51 [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: Caught SQLSyntaxErrorException for select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= ?
                com.querydsl.core.QueryException: Caught SQLSyntaxErrorException for select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= ?
                	at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
                	at com.querydsl.sql.Configuration.translate(Configuration.java:459)
                	at com.querydsl.sql.AbstractSQLQuery.iterateSingle(AbstractSQLQuery.java:410)
                	at com.querydsl.sql.AbstractSQLQuery.iterate(AbstractSQLQuery.java:342)
                	at com.querydsl.sql.ProjectableSQLQuery.fetchOne(ProjectableSQLQuery.java:397)
                	at com.querydsl.core.support.FetchableQueryBase.fetchFirst(FetchableQueryBase.java:51)
                	at com.atlassian.jira.migration.export.db.advancedroadmaps.PlanDataReader.hasPlans$lambda$0(PlanDataReader.kt:65)
                	at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(DatabaseAccessorImpl.java:69)
                	at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:87)
                	at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(DefaultTransactionalExecutor.java:43)
                	at com.atlassian.jira.database.DatabaseAccessorImpl.runInManagedTransaction(DatabaseAccessorImpl.java:131)
                	... 2 filtered
                	at java.lang.reflect.Method.invoke(Method.java:498)
                	at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
                	at com.sun.proxy.$Proxy552.runInManagedTransaction(Unknown Source)
                	... 2 filtered
                	at java.lang.reflect.Method.invoke(Method.java:498)
                	at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:131)
                	at com.sun.proxy.$Proxy552.runInManagedTransaction(Unknown Source)
                	at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.runInStartedOrExistingTransaction(JiraHostConnectionAccessor.java:130)
                	at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:60)
                	at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:40)
                	at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(DatabaseAccessorImpl.java:67)
                	at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInTransaction(DatabaseAccessorImpl.java:43)
                	at com.atlassian.pocketknife.api.querydsl.DatabaseAccessor.run(DatabaseAccessor.java:201)
                	at com.atlassian.jira.migration.export.db.advancedroadmaps.PlanDataReader.hasPlans(PlanDataReader.kt:61)
                	at com.atlassian.jira.migration.preflight.PreflightService.hasARPlans(PreflightService.kt:552)
                	at com.atlassian.jira.migration.preflight.PreflightService.getChecksToRemove(PreflightService.kt:438)
                	at com.atlassian.jira.migration.preflight.PreflightService.executeChecksForDraftPlan(PreflightService.kt:199)
                	at com.atlassian.jira.migration.preflight.PreflightService.executeChecksForDraftPlan$default(PreflightService.kt:179)
                	at com.atlassian.jira.migration.preflight.rest.PreflightResource.executeChecks(PreflightResource.kt:56)
                	... 3 filtered
                	at java.lang.reflect.Method.invoke(Method.java:498)
                	... 19 filtered
                	at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:159)
                	... 1 filtered
                	at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:69)
                	... 36 filtered
                	at com.atlassian.diagnostics.internal.platform.monitor.http.HttpRequestMonitoringFilter.doFilter(HttpRequestMonitoringFilter.java:55)
                	... 8 filtered
                	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
                	... 46 filtered
                	at com.resolution.atlasplugins.samlsso.servlet.RedirectToSsoFilter.doFilter(RedirectToSsoFilter.java:60)
                	... 3 filtered
                	at com.atlassian.troubleshooting.thready.filter.AbstractThreadNamingFilter.doFilter(AbstractThreadNamingFilter.java:46)
                	... 14 filtered
                	at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
                	... 1 filtered
                	at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
                	... 16 filtered
                	at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)
                	... 19 filtered
                	at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
                	... 10 filtered
                	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
                	... 4 filtered
                	at com.atlassian.troubleshooting.thready.filter.AbstractThreadNamingFilter.doFilter(AbstractThreadNamingFilter.java:46)
                	... 3 filtered
                	at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
                	... 26 filtered
                	at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
                	... 25 filtered
                	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
                	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
                	at java.lang.Thread.run(Thread.java:748)
                Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                
                	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
                	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
                	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
                	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
                	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
                	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
                	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
                	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
                	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
                	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
                	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
                	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
                	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
                	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
                	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
                	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
                	at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:42)
                	at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeQuery$5(DiagnosticPreparedStatement.java:59)
                	at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:69)
                	at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55)
                	at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeQuery(DiagnosticPreparedStatement.java:59)
                	at com.querydsl.sql.AbstractSQLQuery.iterateSingle(AbstractSQLQuery.java:370)
                	... 283 more
                Caused by: Error : 942, Position : 52, Sql = select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= :1 , OriginalSql = select * from (   select "AO_D9132D_PLAN"."ID" from "AO_D9132D_PLAN" "AO_D9132D_PLAN" ) where rownum <= ?, Error Msg = ORA-00942: table or view does not exist
                
                	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
                	... 305 more
                

                Workaround

                Install a compatible version of Advanced Roadmaps - Marketplace link

                        500296872af8 Youyou Cheng
                        887e911e3c81 Jimmy Van
                        Votes:
                        1 Vote for this issue
                        Watchers:
                        10 Start watching this issue

                          Created:
                          Updated:
                          Resolved:

                            500296872af8 Youyou Cheng
                            887e911e3c81 Jimmy Van
                            Affected customers:
                            1 This affects my team
                            Watchers:
                            10 Start watching this issue

                              Created:
                              Updated:
                              Resolved: