Upgrade 7.4.14 to 7.13.5 Error

Question

Hello,

I've upgraded from 7.4.14 to 7.13.5 but when I try to start confluence I just get a generic "Pre-upgrade validation failed. Check the Confluence application logs for more details. You'll need to fix these problems and restart Confluence before you can upgrade. Upgrade error message: Cannot update schema" error.

There are two repeating errors in the logs.

2022-05-19 12:07:03,067 ERROR [pool-3-thread-4] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Invalid object name 'DENORMALISED_STATE'.

and

2022-05-19 12:07:03,067 ERROR [pool-3-thread-4] [security.denormalisedpermissions.impl.DenormalisedPermissionStateManagerImpl] reloadServiceState reloadServiceState failed: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Any help resolving these so I can get it back up and running would be much apperciated!

Brant Schroeder · Answer

Great, they should be able to provide you with an alter script to run on the DB and fix the scheme issue.

Ben · Answer

SQL 2019.

Thanks I'll submit that now.

Brant Schroeder · Answer

@Ben

What SQL server are you using?  The issue is that the database scheme was not properly updated.  I would suggest submitting a support ticket to Atlassian.  They will be able to help you with a SQL command to rectify the issue.  https://support.atlassian.com/contact/#/