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:
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
Hi Joshua, check out these articles:
Confluence-Migration-Assistant-Error
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'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.