Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

missing table [MIG_ANALYTICS_EVENT]

Erich Stöckli March 7, 2022

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

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
0 votes
Answer accepted
James Richards
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 7, 2022

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 March 7, 2022

Hi @James Richards

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

Regards,
Erich

James Richards
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 10, 2022

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 March 11, 2022

Hi,

We are currently still using Confluence 6.2.1.

Regards,
Erich

James Richards
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 20, 2022

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 March 23, 2022

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

Like James Richards likes this
TAGS
AUG Leaders

Atlassian Community Events