Cloud Migration Assistant Error - Table Already Exists

[CTCD Apps Manager]

Hi,

We planned to migrate our Confluence server to Cloud version and I tried to assess it via Cloud Migration tools. However when I access the link (Atlassian Cloud > Migration Assistant) I received system error caused by Table 'MIG_ANALYTICS_EVENT' already exists.

I already updated the tools into version 3.2.5

Following is the complete error:

org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getInitialState' in class com.atlassian.migration.agent.web.AppAction threw exception com.atlassian.util.concurrent.LazyReference$InitializationException: javax.persistence.PersistenceException: Failed to update database schema at /templates/app.vm[line 21, column 44]
    at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:228)

caused by: com.atlassian.util.concurrent.LazyReference$InitializationException: javax.persistence.PersistenceException: Failed to update database schema
    at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)

caused by: javax.persistence.PersistenceException: Failed to update database schema
    at com.atlassian.migration.agent.store.jpa.impl.LiquibaseSchemaUpgrader.upgrade(LiquibaseSchemaUpgrader.java:35)

caused by: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/db-changelog/8-analytics-event.xml::8-analytics-event::MPT: Reason: liquibase.exception.DatabaseException: Table 'MIG_ANALYTICS_EVENT' already exists [Failed SQL: CREATE TABLE tdconfluencedb.MIG_ANALYTICS_EVENT (id VARCHAR(255) NOT NULL, eventTimestamp BIGINT NOT NULL, eventType VARCHAR(255) NOT NULL, event LONGTEXT NOT NULL, CONSTRAINT PK_MIG_ANALYTICS_EVENT PRIMARY KEY (id))]
    at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)

caused by: liquibase.exception.DatabaseException: Table 'MIG_ANALYTICS_EVENT' already exists [Failed SQL: CREATE TABLE tdconfluencedb.MIG_ANALYTICS_EVENT (id VARCHAR(255) NOT NULL, eventTimestamp BIGINT NOT NULL, eventType VARCHAR(255) NOT NULL, event LONGTEXT NOT NULL, CONSTRAINT PK_MIG_ANALYTICS_EVENT PRIMARY KEY (id))]
    at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)

caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'MIG_ANALYTICS_EVENT' already exists
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

[Rob Horan]

@CTCD Apps Manager would you mind sharing the outcome?

[Kishan Sharma]

You will need Atlassian team's help on this, please raise a support ticket to Atlassian Support.