missing table [MIG_ANALYTICS_EVENT]

[Erich Stöckli]

Hello everyone

After updating "Confluence Cloud Migration Assistant" to version 3.3.3 we get the following 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: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [MIG_ANALYTICS_EVENT] at /templates/app.vm[line 21, column 44]
at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223)

caused by: com.atlassian.util.concurrent.LazyReference$InitializationException: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [MIG_ANALYTICS_EVENT]
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)

caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [MIG_ANALYTICS_EVENT]
at org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateTable(AbstractSchemaValidator.java:121)

We've already tried the steps mentioned in these articles: 

[MIG-189] Migration assistant fails in Confluence if not all MIG_ tables exist - Create and track feature requests for Atlassian products.

[CONFSERVER-58124] Cloud Migration Assistant app shows up in the list of apps even after being uninstalled - Create and track feature requests for Atlassian products.

In our case we did:

• uninstalled "Confluence Cloud Migration Assistant"
• stopped the confluence service
• dropped the MIG_* tables
• deleted the chache folders (MIG-189)
• started the confluence service
• installed "Confluence Cloud Migration Assistant"

As a result, the MIG_* tables are created, but we get the same error again.
A previous version (3.2.1) worked, but has to be updated in order to migrate to the cloud.

Are there any ideas or workarounds how to get the newest version of "Confluence Cloud Migration Assistant" installed?

Thanks in advance

[James Richards · Accepted solution]

Hi @Erich Stöckli

Thanks for contacting Atlassian Community. I just did a test upgrade and install and it worked fine. I was running on PostgreSQL. 

What database are you running so we can try and reproduce the error?

Regards,
James.

[Erich Stöckli]

Hi @James Richards

We are running Microsoft SQL Server Standard 2016 (Version 13.0.4001.0).

Regards,
Erich

[James Richards]

Hi,

What version of Confluence are you running? We need to make sure SQL Server 2016 is supported.

See https://confluence.atlassian.com/doc/supported-platforms-207488198.html for versions.

James.

[Erich Stöckli]

Hi,

We are currently still using Confluence 6.2.1.

Regards,
Erich

[James Richards]

Hi,

From

* https://confluence.atlassian.com/display/CONF62/Supported+Platforms

Confluence 6.2 only supports SQL Server 2012, 2014. I'd recommend upgrading Confluence first of all to make sure everything is on the same version level.

Regards,
James.

[Erich Stöckli]

Thank you very much for the support. The update to Confluence 6.15 and Confluence Cloud Migration Assistant 3.3.4 has now solved the problem for us and the migration to the cloud is now working.

Regards,
Erich