Confluence upgrade path for 5.6.3 => 6.15.3

[Dmitry Martynkin]

Hello, I was trying to upgrade Confluence 5.6.3 to 6.15.3 Server running on Windows VM using latest installer. 

However, I ran into problems. It appears that the SQL database structure changed.

Confluence cannot be started after upgrade. 

Some examples of the log:

2019-04-23 21:00:00,450 ERROR [scheduler_Worker-1] [crowd.manager.application.ApplicationServiceGeneric] findUserByName com.atlassian.cache.CacheException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [S0002]; error code [208]; Invalid object name 'scheduler_clustered_jobs'.; nested exception is java.sql.SQLException: Invalid object name 'scheduler_clustered_jobs'.
com.atlassian.crowd.exception.DirectoryInstantiationException: com.atlassian.cache.CacheException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [S0002]; error code [208]; Invalid object name 'scheduler_clustered_jobs'.; nested exception is java.sql.SQLException: Invalid object name 'scheduler_clustered_jobs'.

The article https://confluence.atlassian.com/doc/upgrading-confluence-4578.html suggests there could be a direct upgrade.

Can somebody suggest a workaround?

Thank you.

[JP _AC Bielefeld Leader_]

Hi,

did you check that your database server version is still supported?

Best

JP

[Dmitry Martynkin]

Thank you for suggestion.

We run SQL Server 2014 SP2 in SQL Server 2012 compatibility mode.

According to https://confluence.atlassian.com/doc/supported-platforms-207488198.html, Confluence 6.15 supports SQL 2012

[JP _AC Bielefeld Leader_]

Hi,

Microsoft SQL Server is not the preferred database for Confluence / Jira. Did you try an export backup of your Confluence site & reimport on a new Confluence installation?

Otherwise I would opt for opening a ticket with Atlassian.

Best

JP