Problem with migrate to cloud

[Mateusz Kiszka]

Hello. I wanted to move our Jira Server to the Cloud version. During the migration I get an error that the record cannot be deleted from the database because it does not exist. What can I do?

```

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.jira.migration.jira-migration-plugin]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95) [?:?]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:86) [?:?]
	at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38) [?:?]
	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.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
    Database:
    	- name:MySQL
    	- version:8.0.32
    	- minor version:0
    	- major version:8
    Driver:
    	- name:MySQL Connector/J
    	- version:mysql-connector-j-8.0.31 (Revision: 0c86fc148d567b62266c2302bdad0f1e7a7e4eba)
    
    java.sql.SQLSyntaxErrorException: Can't DROP 'index_ao_6ff49d_inc1106621083'; check that column/key exists
	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:54) [?:?]
	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.lambda$create$0(AbstractActiveObjectsFactory.java:73) [?:?]
	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21) [?:?]
	at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:50) [classes/:?]
	at jdk.internal.reflect.GeneratedMethodAccessor277.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) [atlassian-plugins-core-5.7.3.jar:?]
	at com.sun.proxy.$Proxy328.doInTransaction(Unknown Source) [?:?]
	at jdk.internal.reflect.GeneratedMethodAccessor277.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 com.sun.proxy.$Proxy328.doInTransaction(Unknown Source) [?:?]
	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18) [?:?]
	at jdk.internal.reflect.GeneratedMethodAccessor287.invoke(Unknown Source) [?:?]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [?:?]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) [?:?]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) [spring-aop-5.3.10.jar:5.3.10]
	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:186) [spring-aop-5.3.10.jar:5.3.10]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) [spring-aop-5.3.10.jar:5.3.10]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) [spring-aop-5.3.10.jar:5.3.10]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.10.jar:5.3.10]
	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:186) [spring-aop-5.3.10.jar:5.3.10]
	at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) [?:?]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.10.jar:5.3.10]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) [spring-aop-5.3.10.jar:5.3.10]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) [spring-aop-5.3.10.jar:5.3.10]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.10.jar:5.3.10]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) [spring-aop-5.3.10.jar:5.3.10]
	at com.sun.proxy.$Proxy1362.execute(Unknown Source) [?:?]
	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:70) [?:?]
	at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32) [?:?]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:91) [?:?]
	... 6 more
Caused by: java.sql.SQLSyntaxErrorException: Can't DROP 'index_ao_6ff49d_inc1106621083'; check that column/key exists
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) [mysql-connector-j-8.0.31.jar:8.0.31]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [mysql-connector-j-8.0.31.jar:8.0.31]
	at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1334) [mysql-connector-j-8.0.31.jar:8.0.31]
	at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2084) [mysql-connector-j-8.0.31.jar:8.0.31]
	at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1245) [mysql-connector-j-8.0.31.jar:8.0.31]
	at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234) [commons-dbcp2-2.1.jar:2.1]
	at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234) [commons-dbcp2-2.1.jar:2.1]
	at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2319) [?:?]
	at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2375) [?:?]
	at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2347) [?:?]
	at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:91) [?:?]
	at net.java.ao.EntityManager.migrate(EntityManager.java:132) [?:?]
	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:52) [?:?]
	... 43 more

```

[Mateusz Kiszka]

Thank you for your answer, @Tuncay Senturk _Snapbytes_.
I will submit a ticket to technical support.

[Tuncay Senturk _Snapbytes_]

Hi @Mateusz Kiszka 

You are getting that exception from Active Objects which is the persistence layer for Jira apps.

When I check the log provided,

Can't DROP 'index_ao_6ff49d_inc1106621083'; check that column/key exists

The table starts with AO_6FF49D prefix is related to Jira Cloud Migration Assistant (JCMA) app. I'd suggest raising a ticket to Atlassian support, however, if you have access to the DB, you can check the tables starting with AO_6FF49D. Sometimes, uninstalling the app and (deleting the related tables from the database), and re-installing the app may help.

I believe the best solution is to raise a support ticket.