Atlassian Cloud Migration Assistant - system error

[Yieng]

Cause

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:223)

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: liquibase.exception.LockException: liquibase.exception.DatabaseException: Column, parameter, or variable #2: Cannot find data type BOOLEAN. [Failed SQL: CREATE TABLE MIG_DB_CHANGELOG_LOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_MIG_DB_CHANGELOG_LOCK PRIMARY KEY (ID))]

[Ramona Scripcaru]

Hi @Yieng !

The Cannot find data type BOOLEAN is a known issue with MS SQL Server 2008:

• (CORE-3224) SQL Server 2008: Cannot find data type BOOLEAN

The SQL Server 2008 is an unsupported platform for the Migration Assistant. Can you confirm if this is the platform that you have and if so, can you please upgrade your database to the MSSQL 2012 in order for the Confluence Cloud Migration Assistant to work?

You can check all supported platforms on:

• https://confluence.atlassian.com/conf62/supported-platforms-902075330.html

Cheers!

Ramona

Atlassian Cloud team