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!
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/#/
SQL 2019.
Thanks I'll submit that now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great, they should be able to provide you with an alter script to run on the DB and fix the scheme issue.
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.