Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confluence Server to Cloud Migration Tool Error

PulseI May 18, 2022

Server: 6.2.3

 

Installation of Tool Successful. 

Upon opening tool presented with an error.

 

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: org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation 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.exception.SQLGrammarException: Unable to build DatabaseInformation
    at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)

caused by: org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)

caused by: org.postgresql.util.PSQLException: The column name start_value was not found in this ResultSet.
    at org.postgresql.jdbc.PgResultSet.findColumn(PgResultSet.java:2589)

1 answer

1 vote
James Richards
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 18, 2022

Hi @PulseI

Are you running CCMA on a H2 database? This isn't recommended and you should be doing the testing and production migration on an external database like PostgreSQL.

Regards,
James.

PulseI May 19, 2022

No. Here is our DB setup. 

Screen Shot 2022-05-20 at 3.07.11 pm.png

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

What version of Confluence are you running? If you have version 8.4.20 of PostgreSQL then that's not going to work.

The minimum version of Confluence that runs Confluence Cloud Migration Assistant is 5.10.0, and it has a minimum version of PostgreSQL of 9.2

See

Please upgrade your database to the minimum supported version for your version of Confluence and try again.

James.

PulseI May 22, 2022

Will do, thanks for your help. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events