Forums

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

Receiving error when migrating from Confluence Server to Confluence Cloud

Joshua Rehm August 11, 2023

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:image.png

From the database query:
image.png

 

2 answers

0 votes
Joshua Rehm August 17, 2023

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

0 votes
Dan Breyen
Community Champion
August 11, 2023

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'.

Joshua Rehm August 15, 2023

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
6.3.1
TAGS
AUG Leaders

Atlassian Community Events