-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
Component/s: Admin - Sandbox - Data copy
-
None
-
1
-
Severity 3 - Minor
-
Jira Software, Jira Service Management
Issue Summary
When we are copying the production data to sandbox by following our docs , it fails after initiating and this is the screenshot of the error
Steps to Reproduce
- Follow the steps mentioned in the document
Expected Results
The sandbox refresh goes smooth without any errors
Actual Results
It fails in the UI without much errors
From the logs we see this error
msg: Import task failed: [Error occurred while running the task. Please contact support., Error running phase IMPORT_JIRA_PLUS_PLUGIN_DATA, Failure when trying to run the insert entity stage.] stack: cloud.atlassian.provisioning.exception.PermanentProvisioningFailureException: Import task failed: [Error occurred while running the task. Please contact support., Error running phase IMPORT_JIRA_PLUS_PLUGIN_DATA, Failure when trying to run the insert entity stage.] at com.atlassian.jira.internal.rest.CloudBackupManager.calculateResult(CloudBackupManager.java:816) at com.atlassian.jira.internal.rest.CloudBackupManager.startPhasedImport(CloudBackupManager.java:284) at com.atlassian.jira.internal.rest.ImportResourceV2.startPhasedImport(ImportResourceV2.java:283) at com.atlassian.jira.internal.rest.ImportResourceV2.lambda$startAsyncPhasedImport$8(ImportResourceV2.java:259) at com.atlassian.jira.internal.rest.AbstractCloudProvisionerResource.lambda$withTenantedWorkContext$0(AbstractCloudProvisionerResource.java:155) at com.atlassian.jira.internal.filter.InternalResource.withWorkContext(InternalResource.java:116) at com.atlassian.jira.internal.rest.AbstractCloudProvisionerResource.withTenantedWorkContext(AbstractCloudProvisionerResource.java:142) at com.atlassian.jira.internal.rest.ImportResourceV2.lambda$startAsyncPhasedImport$9(ImportResourceV2.java:258) at com.atlassian.jira.internal.rest.AsyncCloudTaskRunner.lambda$wrapWithSpan$0(AsyncCloudTaskRunner.java:154) at com.atlassian.jira.internal.rest.AsyncCloudTaskRunner$AsyncCloudProvisionerHelper.lambda$wrapWithLogs$23(AsyncCloudTaskRunner.java:427) at com.atlassian.jira.internal.rest.AsyncCloudTaskRunner$AsyncCloudProvisionerHelper.wrapTask(AsyncCloudTaskRunner.java:403) at com.atlassian.jira.internal.rest.AsyncCloudTaskRunner$AsyncCloudProvisionerHelper.lambda$runAsync$0(AsyncCloudTaskRunner.java:235) at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.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)
msg: Failed to export table AO_2C4E5C_MAILITEMCHUNK while performing piped import stack: com.atlassian.rdbms.dbimportexport.runner.api.ImportExportException: Failed to export table AO_2C4E5C_MAILITEMCHUNK while performing piped import at com.atlassian.rdbms.dbimportexport.ao.impl.AOImporterImpl.performPipedPluginImportForTable(AOImporterImpl.java:324) at com.atlassian.rdbms.dbimportexport.ao.impl.AOImporterImpl.parseTableXmlEventAndWriteToDb(AOImporterImpl.java:261) at com.atlassian.rdbms.dbimportexport.ao.impl.AOImporterImpl.importAOXMLToDBUsingPipedStreams(AOImporterImpl.java:189) at com.atlassian.rdbms.dbimportexport.runner.impl.ImportRunnerImpl.lambda$performPipedPluginImport$1(ImportRunnerImpl.java:137) at com.atlassian.rdbms.dbimportexport.runner.impl.JdbcUtils.executeWithAutoCommitMode(JdbcUtils.java:52) at com.atlassian.rdbms.dbimportexport.runner.impl.ImportRunnerImpl.performPipedPluginImport(ImportRunnerImpl.java:127) at com.atlassian.rdbms.dbimportexport.runner.impl.ImportRunnerImpl.runImportFromAOXMLViaStreams(ImportRunnerImpl.java:100) at com.atlassian.jira.migration.service.ImportExceptionInterceptor.invoke(ImportExceptionInterceptor.java:45) at com.atlassian.jira.bc.dataimport.PluginDataImportService.lambda$importDataFromStream$0(PluginDataImportService.java:39) at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:43) at com.atlassian.jira.bc.dataimport.PluginDataImportService.importDataFromStream(PluginDataImportService.java:38) at com.atlassian.jira.bc.dataimport.importers.plugin.XMLPluginDataImporter.restoreAo_old(XMLPluginDataImporter.java:52) at com.atlassian.jira.bc.dataimport.importers.plugin.XMLPluginDataImporter.restoreAo(XMLPluginDataImporter.java:41) at
Workaround
please contact support before following the workaround
Reduce the email retention in the source instance (this would poroduction if we are copying data from Prod to sandbox) to 14 days by going to this link https://<site-url>/secure/admin/global-mail-settings
Wait for a day and then retry the prod to sandbox copy