Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

(SQL) Error after upgrade to 7.13 (from 7.8)

Hello,

We've reiceved an error after trying to upgrade to 7.13 coming from 7.8 

"

Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade. Upgrade error message: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DenormalisedSpacePermissionsUpgradeTask@6b5c9791 failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [DROP TRIGGER IF EXISTS denormalised_space_permission_trigger]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'IF'.
"
We're on SQL Server 2014(120) with this database, could that be why? I did revert back to before the upgrade but haven't tried a second time yet.

1 answer

1 accepted

2 votes
Answer accepted
Alexis Robert Community Leader Sep 08, 2021

Hi @Ernst,Axel , 

 

the upgrade fails because Confluence 7.13 is not compatible with SQL Server 2014, as you can see in the Supported Platforms page : https://confluence.atlassian.com/doc/supported-platforms-207488198.html#SupportedPlatforms-Databases

 

I would advise doing the SQL upgrade first to SQL Server 2016 and then trying again the upgrade.

 

Let me know if this helps, 

 

--Alexis

Thanks Alexis,

I thought something like that. I'll upgrade them to an Azure SQL DB, no problem.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

67 views 0 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you