Receiving error when migrating from Confluence Server to Confluence Cloud

Question

When attempting to use the Confluence Data Migration Assistant, we receive 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.exception.GenericJDBCException: Error accessing table metadata 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.GenericJDBCException: Error accessing table metadata
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)

caused by: org.hibernate.exception.GenericJDBCException: Error accessing table metadata
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)

caused by: java.sql.SQLException: The database name component of the object qualifier must be the name of the current database.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

We are using SQL Server. I saw an article regarding case sensitivity in SQL Server, but it seems to have disappeared from the internet. I have already verified, per that article, that the database name in the configuration file matches, case sensitive, the database name in SQL Server:

From the configuration file:

From the database query:

Joshua Rehm · Answer

Hello,

Is there anything else that we could look into for this? This is holding up both our JIRA and Confluence migration to the cloud.

Thank you,

- Josh

Joshua Rehm · Answer

Hi Dan,

Neither of these links are are related to my issue. One is due to a lock error caused by starting a migration, which we haven't done because we can't get the migration tool to even start. The other is related to MySQL databases. We are on MSSQL Server.

I saw an article regarding my issue, but I can't find it now. Its solution was to make sure the database name in the configuration file and SQL Server were identical, including case. As indicated by my post, I have done this but we are still receiving the error.

Attempting to use the support link you provided only redirects me back to here. I anticipate this is because our server edition is using the free 10 user license of Confluence.

Thank you

- Josh

Dan Breyen · Answer

Hi Joshua, check out these articles:

Confluence-Migration-Assistant-Error

Confluence-upgrade-failed

Hope that helps.  I'd also make sure your Migration Asst is up to date.

The article is for a Conf Server upgrade, but it seems to be related.  If that doesn't work, and you don't get any other solutions, you could open a ticket w/ Support (support.atlassian.com) and select 'Migration Support'.