Backing up jira failed

admin teamapt

when I try backing up jira from the web ui, i always get this error

There was a problem backing up data for the null plugin.

Below is the logs collected from atlassian-jira.log

2021-02-10 12:52:30,401 http-nio-127.0.0.1-8080-exec-26 ERROR dirivbogbe@teamapt.com 763x3716x1 rds6ly 127.0.0.1 /secure/admin/XmlBackup.jspa [c.a.j.bc.dataimport.DefaultExportService] Error during Active Objects Backup

com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin>:

at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26)

at com.atlassian.dbexporter.jdbc.JdbcUtils.withNoAutoCommit(JdbcUtils.java:57)

at com.atlassian.dbexporter.exporter.DataExporter$1.call(DataExporter.java:52)

at com.atlassian.dbexporter.exporter.DataExporter$1.call(DataExporter.java:49)

at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:29)

at com.atlassian.dbexporter.exporter.DataExporter.export(DataExporter.java:49)

at com.atlassian.dbexporter.DbExporter.exportData(DbExporter.java:51)

at com.atlassian.activeobjects.backup.ActiveObjectsBackup.save(ActiveObjectsBackup.java:110)

at com.atlassian.jira.bc.dataimport.DefaultExportService.exportActiveObjects(DefaultExportService.java:202)

at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:90)

at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:71)

at com.atlassian.jira.web.action.util.XmlBackup.doExecute(XmlBackup.java:100)

... 1 filtered

at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)

... 7 filtered

at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

... 48 filtered

at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)

... 4 filtered

at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:62)

... 12 filtered

at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)

... 47 filtered

at com.resolution.atlasplugins.samlsso.servlet.RedirectToSsoFilter.doFilter(RedirectToSsoFilter.java:60)

... 18 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)

... 39 filtered

at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)

... 5 filtered

at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.lambda$invokeFilterChain$0(CustomerContextSettingFilter.java:181)

at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.rteInvoke(ReentrantThreadLocalBasedCodeContext.java:136)

at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.runOutOfContext(ReentrantThreadLocalBasedCodeContext.java:89)

at com.atlassian.servicedesk.internal.utils.context.CustomerContextServiceImpl.runOutOfCustomerContext(CustomerContextServiceImpl.java:47)

at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.outOfCustomerContext(CustomerContextSettingFilter.java:174)

at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:130)

at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:121)

... 4 filtered

at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:37)

... 8 filtered

at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)

... 4 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:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Please help.

Joshua Sneed Contegix

Hi Teamapt,

First, Contact Partner Program support if you have a valid SEN. Second, in a jira export there is entities.xml with Jira issue data and a .pdata file with plugin data. I don't have much to go on, but my guess is there is an abandoned table in the database with data that causes the export service to fail. Look in the UI in Admin > System > Plugin Data Storage for the first 'set' of tables. These are 'orphaned' tables left behind by plugins no longer installed and they can be dropped from the database. Follow proper database backup protocols, but I think dropping those tables will help. It is also worth updating all plugins. Cheers!