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

[Ernst,Axel]

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.

[Alexis Robert · Accepted solution]

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

[Ernst,Axel]

Thanks Alexis,

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