Backup jira data failure

[Luuk van de Ven]

When i start the jira data backup feature in v8.7.1. I get the following error:

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

Does anybody know how to solve this error?

Logile:

2020-06-24 20:53:51,282+0200 http-nio-8080-exec-2 WARN Luuk 1253x227708x4 18nt8r4 0:0:0:0:0:0:0:1 /secure/admin/XmlBackup.jspa [c.a.j.w.action.util.XmlBackup] The filename that will be used for exporting is: 'D:\Atlassian\Application Data\JIRA\export\BackupJira.zip'
2020-06-24 20:54:06,221+0200 http-nio-8080-exec-3 ERROR anonymous 1253x227690x1 1e6tq4v 192.168.100.225 /rest/usermanagement/1/authentication [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Column Index out of range, 2 > 1. ))
com.atlassian.cache.CacheException: org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Column Index out of range, 2 > 1. ))
at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:212)
at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:163)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao.getUserWithAttributes(OfBizUserDao.java:884)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao.findByNameWithAttributes(OfBizUserDao.java:249)
at com.atlassian.jira.crowd.embedded.ofbiz.DelegatingUserDao.findByNameWithAttributes(DelegatingUserDao.java:73)
at com.atlassian.jira.crowd.embedded.ofbiz.IndexedUserDao.findByNameWithAttributes(IndexedUserDao.java:64)
at com.atlassian.jira.crowd.embedded.ofbiz.DelegatingUserDao.findByNameWithAttributes(DelegatingUserDao.java:73)
at com.atlassian.jira.crowd.embedded.ofbiz.SwitchingUserDao.findByNameWithAttributes(SwitchingUserDao.java:30)
at com.atlassian.crowd.directory.AbstractInternalDirectory.authenticate(AbstractInternalDirectory.java:193)
at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.authenticateUser(DirectoryManagerGeneric.java:273)
at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.authenticateUser(ApplicationServiceGeneric.java:181)
... 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.$Proxy556.authenticateUser(Unknown Source)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy4007.authenticateUser(Unknown Source)
at com.atlassian.crowd.plugin.rest.service.controller.AuthenticationController.authenticateUser(AuthenticationController.java:46)
at com.atlassian.crowd.plugin.rest.service.resource.usermanagement.AuthenticationResource.authenticateUser(AuthenticationResource.java:54)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
... 18 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)
... 32 filtered
at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:55)
... 8 filtered
at com.atlassian.jira.plugin.mobile.web.filter.MobileAppRequestFilter.doFilter(MobileAppRequestFilter.java:59)
... 4 filtered
at com.atlassian.jira.plugin.mobile.login.MobileLoginSuccessFilter.doFilter(MobileLoginSuccessFilter.java:54)
... 3 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.atlassian.ratelimiting.internal.filter.RateLimitFilter.doFilter(RateLimitFilter.java:73)
... 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)
... 3 filtered
at com.atlassian.crowd.plugin.rest.filter.SeraphDisablerFilter.doFilter(SeraphDisablerFilter.java:30)
... 3 filtered
at com.atlassian.crowd.plugin.rest.filter.BasicApplicationAuthenticationFilter.doFilter(BasicApplicationAuthenticationFilter.java:88)
... 19 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:212)
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:203)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:134)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:123)
... 4 filtered
at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:37)
... 8 filtered
at com.atlassian.crowd.plugin.rest.filter.RestServiceVersionFilter.doFilter(RestServiceVersionFilter.java:75)
... 3 filtered
at com.atlassian.ratelimiting.internal.filter.RateLimitPreAuthFilter.doFilter(RateLimitPreAuthFilter.java:71)
... 3 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)
Caused by: org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Column Index out of range, 2 > 1. ))
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:274)
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:51)
at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.<init>(DefaultOfBizListIterator.java:167)
at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.<init>(DefaultOfBizListIterator.java:161)
at com.atlassian.jira.ofbiz.DefaultOfBizListIterator.iterator(DefaultOfBizListIterator.java:153)
at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:230)
at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.asList(SelectQueryImpl.java:164)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao$UserAttributesCacheLoader.load(OfBizUserDao.java:1073)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao$UserAttributesCacheLoader.load(OfBizUserDao.java:1064)
at com.atlassian.cache.memory.MemoryCacheManager$2.load(MemoryCacheManager.java:192)
at com.atlassian.cache.memory.DelegatingCache.lambda$get$0(DelegatingCache.java:163)
at com.atlassian.cache.memory.DelegatingCache.lambda$get$1(DelegatingCache.java:191)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4876)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3528)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2277)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044)
at com.google.common.cache.LocalCache.get(LocalCache.java:3952)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4871)
at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:178)
... 325 more
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while getting value: (Column Index out of range, 2 > 1. )
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:700)
at org.ofbiz.core.entity.EntityListIterator.currentGenericValue(EntityListIterator.java:181)
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:267)
... 345 more
Caused by: java.sql.SQLException: Column Index out of range, 2 > 1.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
at com.mysql.jdbc.ResultSetImpl.checkColumnBounds(ResultSetImpl.java:764)
at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5251)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5173)
at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:199)
at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:199)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:610)
... 347 more
2020-06-24 20:54:08,352+0200 http-nio-8080-exec-2 INFO Luuk 1253x227708x4 18nt8r4 0:0:0:0:0:0:0:1 /secure/admin/XmlBackup.jspa [c.a.j.bc.dataimport.DefaultExportService] Data export completed in 17067ms. Wrote 397068 entities to export in memory.
2020-06-24 20:54:08,353+0200 http-nio-8080-exec-2 INFO Luuk 1253x227708x4 18nt8r4 0:0:0:0:0:0:0:1 /secure/admin/XmlBackup.jspa [c.a.j.bc.dataimport.DefaultExportService] Attempting to save the Active Objects Backup

[Daniel Eads]

Hi @Luuk van de Ven,

I can see from your previous post on Community that you were interested in backing up Jira with XML in order to switch from MySQL to MS SQL.

It looks like there may be a problem with the current MySQL database causing this error. Would you be able to run the database integrity checker in Jira? Documentation for it is available here, but for your convenience I've copied the instructions to find and use it:

1. Choose  > System. 
2. Select System support > Integrity checker to open the Integrity Checker page.
   The integrity checker has a number of 'integrity checks' that look for common inconsistencies in Jira's stored data.
   
3. Select one or more items whose data you would like to check the integrity of and click the 'Check' button.
4. After the selected checks run, the preview screen will be shown.
   The screen provides details about the existing data inconsistencies. If any inconsistencies were found, the 'Fix' button will also appear on the page. The messages in red describe inconsistencies that the check will correct if it is chosen and the 'Fix' button is clicked. Messages that appear in yellow are warnings that the check will not correct; Jira will auto-recover from these inconsistencies when an action is taken on an issue.
   Select any inconsistencies that you would like to correct, then click the 'Fix' button.
    Please Note: We strongly recommend taking a backup of your data before correcting any data inconsistencies.
5. If any inconsistencies were found and you chose to correct them, you will be presented with a summary screen describing all the corrective actions that have taken place.

That's a good starting point for an error like this. Let me know the results!

Cheers,
Daniel

[Luuk van de Ven]

Hi Daniel,

Thanks for the answer.

And indeed, we are investigating a switch from mySQL DB to MSSQL DB.

But I also want to use this backup for testing the cloud version of Jira

I did a selected the "select all" from the Intigrety checker screen and pressed the check button. After a while this screen appears with no errors.

I did again try to make a backup via system -> backup system but got the same error again.

[Daniel Eads]

Thanks for the test results @Luuk van de Ven !

Given the passing checks, we might need to try and recreate the problem locally using a native database backup (using mysqldump). Typically we'd go about this with a support case - having a Starter license means that we're not able to work through our standard support channel to do a technical investigation on your setup. We can circle back on this if necessary.

You mentioned you're interested in testing out Jira Cloud however and were interested in using the backup as a Cloud import. I think the best option might be to instead use the Jira Cloud Migration Assistant - we provide this as a free app for Jira Server to do the heavy lifting with a cloud migration. The wizard in the app walks you through all the necessary steps. Would you be able to go through the migration assistant and see if it completes correctly?

Thanks,
Daniel

[Luuk van de Ven]

Hi Daniel,

Last weekend I tried to make a conversion from our server system to the Jira cloud with the Jira Cloud Migration Assistant.

I got stuck at the last step where the system warns me about the potential of more than 10 users.

There are indeed 12 users defined in Jira , which is an combination of users for Jira software, Servicedesk, Bitbucket and Bamboo.

If I count the users for Jira software and helpdesk I come to 8 users in total, so that should match.

I did not complete the migration assistant because it reports it will fail if there are more than 10 users.

Can I complete the migration assistant, or do you have a better idea?

[Daniel Eads]

Hi Luuk,

The migration assistant should allow you to complete even if you go over the user limit for your Cloud site. Once the migration is complete, you can deactivate/unlicense the extra users from Jira Cloud.

Cheers,
Daniel

[Luuk van de Ven]

Hi Daniel,

Thanks for the answer.

Because i didn't get an answer, i completed the migration last weekend. It indeed completed successfully.

After short testing I missed all the helpdesk projects so I couldn't complete my testing. even some of the necessary applications didn't come over.

So I'm stuck again on making my backup, which is still giving the same error.
Can you point me out to the datafile to look for?
Or what is the way to solve this issue?