No boards are currently available after Jira server migration to another server

[Erol Karaboga]

I have migrated the Jira server to another server by restoring data. After migration I click the boards and it says : No boards are currently available . Has anyone faced this issue?

[Erol Karaboga]

Hi @Trudy Claspill  I saw the logs when import the xml backup to the new server. MAybe due to below error I can't see the boards and filters. During importing

2023-02-24 14:59:25,818+0000 JiraImportTaskExecutionThread-1 ERROR erolkaraboga 896x418x1 ue3ye9  /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore
com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin> (table AO_33A75D_IT_EVENTS):
at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:429)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.close(DataImporter.java:434)
at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:120)
at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:41)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:71)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:64)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:29)
at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:64)
at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:44)
at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:70)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:151)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:574)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:749)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:323)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.unsafeCall(DataImportAsyncCommand.java:82)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:64)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:30)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:177)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:149)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
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: java.sql.BatchUpdateException: Duplicate entry '1' for key 'AO_33A75D_IT_EVENTS.PRIMARY'
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.cj.util.Util.handleNewInstance(Util.java:192)
at com.mysql.cj.util.Util.getInstance(Util.java:174)
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:816)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:418)
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:795)
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
at com.atlassian.jira.ofbiz.sql.StatementWrapper.executeBatch(StatementWrapper.java:154)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeBatch$17(DiagnosticPreparedStatement.java:146)
at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:70)
at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeBatch(DiagnosticPreparedStatement.java:146)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:422)
... 24 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'AO_33A75D_IT_EVENTS.PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:795)

During re-indexing:

curity.groups.GroupManager, com.atlassian.jira.security.roles.ProjectRoleManager, com.atlassian.jira.bc.user.search.UserSearchService, com.atlassian.jira.issue.fields.rest.json.beans.JiraBaseUrls, com.atlassian.
jira.user.UserHistoryManager, com.atlassian.jira.user.UserFilterManager, com.atlassian.jira.util.I18nHelper, com.atlassian.jira.issue.fields.rest.json.UserBeanFactory)'
at io.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:156)
at io.atlassian.util.concurrent.LazyReference.get(LazyReference.java:116)
at io.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:95)
at com.atlassian.jira.plugin.AbstractJiraModuleDescriptor.getModule(AbstractJiraModuleDescriptor.java:167)
at com.atlassian.plugin.manager.SafeModuleExtractor.getModule(SafeModuleExtractor.java:52)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(Unknown Source)
at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.base/java.util.stream.ReferencePipeline.collect(Unknown Source)
at com.atlassian.plugin.manager.SafeModuleExtractor.getModules(SafeModuleExtractor.java:37)
at com.atlassian.plugin.manager.EnabledModuleCachingPluginAccessor.getEnabledModulesByClass(EnabledModuleCachingPluginAccessor.java:172)
at com.atlassian.plugin.manager.ForwardingPluginAccessor.getEnabledModulesByClass(ForwardingPluginAccessor.java:46)
at com.atlassian.plugin.manager.ProductPluginAccessor.getEnabledModulesByClass(ProductPluginAccessor.java:16)
at com.atlassian.jira.plugin.customfield.CustomFieldTypeModuleDescriptorsImpl.getUnorderedCustomFieldTypes(CustomFieldTypeModuleDescriptorsImpl.java:36)
at com.atlassian.jira.plugin.customfield.CustomFieldTypeModuleDescriptorsImpl.getCustomFieldTypes(CustomFieldTypeModuleDescriptorsImpl.java:28)
at com.atlassian.jira.issue.managers.CachingCustomFieldManager.getCustomFieldTypes(CachingCustomFieldManager.java:202)
at com.atlassian.jira.startup.AnalyticsLauncher.getJiraStatsAnalyticsEvent(AnalyticsLauncher.java:110)
at com.atlassian.jira.startup.AnalyticsLauncher.lambda$runStartAnalyticsJob$0(AnalyticsLauncher.java:75)
at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:134)
at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:106)
at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:90)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:435)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJob(CaesiumSchedulerService.java:430)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJobWithRecoveryGuard(CaesiumSchedulerService.java:454)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:382)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:66)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:60)
at 

[Trudy Claspill]

@Erol Karaboga 

I do not have a lot of experience with migrating data from one Jira server to another, and have not seen this error before.

Have you tried contacting Atlassian Support directly for assistance?

https://support.atlassian.com/contact/#/

[Trudy Claspill]

If anybody wants to get some more context on this, it is a continuation of questions from another post:

https://community.atlassian.com/t5/Jira-Work-Management-Questions/Not-seen-the-projects-after-migrating-the-Jira-to-another-server/qaq-p/2271496