Forums

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

Upgrade 7.4.14 to 7.13.5 Error

Ben
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 19, 2022

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!

1 answer

0 votes
Brant Schroeder
Community Champion
May 19, 2022

@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/#/

Ben
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 20, 2022

SQL 2019.

 

Thanks I'll submit that now.

Brant Schroeder
Community Champion
May 20, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events