I'm getting error when restoring Jira cloud server-backup to Data Center

[Saiteja Chityala]

Hi,

I'm getting the below error while trying to restore a backup from the cloud to the data center. 

There was a problem restoring ActiveObjects data for the <unknown plugin> plugin. Importing table AO_E24DEA_HOLIDAY failed. Please check the log for details.

Below is the atlassian-jira.log

2023-12-12 14:46:30,781+0000 pool-49-thread-19 ERROR [c.a.j.m.tracking.utils.ThreadUtils] uncaught exception in periodic executor
com.atlassian.cache.CacheException: com.querydsl.core.QueryException: Caught JdbcSQLSyntaxErrorException for select "MIGRATION"."MIGRATION_ID", "MIGRATION"."PLAN_ID", "MIGRATION"."START_MIGRATION_CONTEXT_JSON", "MIGRATION"."IN_PROGRESS_STATUS_JSON", "MIGRATION"."OUTCOME_JSON", "MIGRATION"."APP_OUTCOME_JSON", "MIGRATION"."STARTED_BY", "MIGRATION"."CREATED_TIMESTAMP", "MIGRATION"."UPDATED_TIMESTAMP", "MIGRATION"."PROTOCOL_JSON", "MIGRATION"."USER_MIGRATION_START_TIME", "MIGRATION"."USER_MIGRATION_END_TIME" from "PUBLIC"."AO_6FF49D_MIGRATION_ENTITY" "MIGRATION" where "MIGRATION"."OUTCOME_JSON" is null
at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:214)
at com.atlassian.cache.impl.metrics.InstrumentedCache.get(InstrumentedCache.java:78)
at com.atlassian.jira.cache.stats.CacheWithStats.get(CacheWithStats.java:52)
at com.atlassian.jira.migration.tracking.polling.InProgressMigrationIds.sequence(InProgressMigrationIds.kt:65)
at com.atlassian.jira.migration.tracking.polling.Poller.doPoll(Poller.kt:66)
at com.atlassian.jira.migration.tracking.polling.AbstractPoller.execute(AbstractPoller.kt:67)
at com.atlassian.jira.migration.tracking.polling.AbstractPoller.access$execute(AbstractPoller.kt:18)
at com.atlassian.jira.migration.tracking.polling.AbstractPoller$startPolling$1.invoke(AbstractPoller.kt:38)
at com.atlassian.jira.migration.tracking.polling.AbstractPoller$startPolling$1.invoke(AbstractPoller.kt:38)
at com.atlassian.jira.migration.tracking.utils.ThreadUtils.safeExecutePeriodicallyUntilStopped(ThreadUtils.kt:39)
at com.atlassian.jira.migration.tracking.polling.AbstractPoller.startPolling(AbstractPoller.kt:37)
at com.atlassian.jira.migration.tracking.MigrationTracker.addAndStartWorkPoller$lambda$4$lambda$3(MigrationTracker.kt:78)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.querydsl.core.QueryException: Caught JdbcSQLSyntaxErrorException for select "MIGRATION"."MIGRATION_ID", "MIGRATION"."PLAN_ID", "MIGRATION"."START_MIGRATION_CONTEXT_JSON", "MIGRATION"."IN_PROGRESS_STATUS_JSON", "MIGRATION"."OUTCOME_JSON", "MIGRATION"."APP_OUTCOME_JSON", "MIGRATION"."STARTED_BY", "MIGRATION"."CREATED_TIMESTAMP", "MIGRATION"."UPDATED_TIMESTAMP", "MIGRATION"."PROTOCOL_JSON", "MIGRATION"."USER_MIGRATION_START_TIME", "MIGRATION"."USER_MIGRATION_END_TIME" from "PUBLIC"."AO_6FF49D_MIGRATION_ENTITY" "MIGRATION" where "MIGRATION"."OUTCOME_JSON" is null
at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
at com.querydsl.sql.Configuration.translate(Configuration.java:459)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502)
at com.atlassian.jira.migration.migration.MigrationRepository.getInProgressMigrations$lambda$12(MigrationRepository.kt:143)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(DatabaseAccessorImpl.java:69)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:109)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(DefaultTransactionalExecutor.java:64)
at com.atlassian.jira.database.DatabaseAccessorImpl.runInManagedTransaction(DatabaseAccessorImpl.java:134)
at jdk.internal.reflect.GeneratedMethodAccessor144.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at jdk.proxy3/jdk.proxy3.$Proxy478.runInManagedTransaction(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor144.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:130)
at jdk.proxy3/jdk.proxy3.$Proxy478.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:61)
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.migration.MigrationRepository.getInProgressMigrations(MigrationRepository.kt:136)
at com.atlassian.jira.migration.tracking.polling.InProgressMigrationIds.sequence$lambda$4(InProgressMigrationIds.kt:66)
at com.atlassian.cache.memory.DelegatingCache.lambda$get$1(DelegatingCache.java:193)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4925)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3571)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2313)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2190)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2080)
at com.google.common.cache.LocalCache.get(LocalCache.java:4012)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4920)
at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:180)
... 16 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "AO_6FF49D_MIGRATION_ENTITY" not found; SQL statement:
select "MIGRATION"."MIGRATION_ID", "MIGRATION"."PLAN_ID", "MIGRATION"."START_MIGRATION_CONTEXT_JSON", "MIGRATION"."IN_PROGRESS_STATUS_JSON", "MIGRATION"."OUTCOME_JSON", "MIGRATION"."APP_OUTCOME_JSON", "MIGRATION"."STARTED_BY", "MIGRATION"."CREATED_TIMESTAMP", "MIGRATION"."UPDATED_TIMESTAMP", "MIGRATION"."PROTOCOL_JSON", "MIGRATION"."USER_MIGRATION_START_TIME", "MIGRATION"."USER_MIGRATION_END_TIME" from "PUBLIC"."AO_6FF49D_MIGRATION_ENTITY" "MIGRATION" where "MIGRATION"."OUTCOME_JSON" is null [42102-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398)
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8379)
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8363)
at org.h2.command.Parser.readTableOrView(Parser.java:8358)
at org.h2.command.Parser.readTablePrimary(Parser.java:1863)
at org.h2.command.Parser.readTableReference(Parser.java:2334)
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2772)
at org.h2.command.Parser.parseSelect(Parser.java:2878)
at org.h2.command.Parser.parseQueryPrimary(Parser.java:2762)
at org.h2.command.Parser.parseQueryTerm(Parser.java:2633)
at org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2612)
at org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2605)
at org.h2.command.Parser.parseQueryExpression(Parser.java:2598)
at org.h2.command.Parser.parseQuery(Parser.java:2567)
at org.h2.command.Parser.parsePrepared(Parser.java:724)
at org.h2.command.Parser.parse(Parser.java:689)
at org.h2.command.Parser.parse(Parser.java:661)
at org.h2.command.Parser.prepareCommand(Parser.java:569)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:696)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:696)
at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.prepareStatement(DelegatingConnection.java:37)
at com.atlassian.jira.ofbiz.sql.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:42)
at com.atlassian.jira.diagnostic.connection.DiagnosticConnection.prepareStatement(DiagnosticConnection.java:45)
at com.atlassian.jira.database.AbstractDelegatingConnection.prepareStatement(AbstractDelegatingConnection.java:42)
at com.atlassian.sal.core.rdbms.WrappedConnection.prepareStatement(WrappedConnection.java:170)
at com.atlassian.pocketknife.internal.querydsl.SpecificBehaviourConnection.prepareStatement(SpecificBehaviourConnection.java:232)
at com.querydsl.sql.AbstractSQLQuery.getPreparedStatement(AbstractSQLQuery.java:318)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:439)
... 48 more

[Jack Brickey]

Hi @Saiteja Chityala , I would suggest contacting Atlassian Support directly. If you are not listed as a technical contact reach out to your admin.

[Andy Heinzer]

Hi @Saiteja Chityala 

I created a support case on your behalf over in https://getsupport.atlassian.com/servicedesk/customer/portal/41/PSSRV-98534

Someone from our support team will likely reach out to request more detailed log information to better troubleshoot the problem here.

Andy