update failed

[license_all]

Atlassian Confluence 6.13.0 to 7.14.1.

The installer exits without errors. the web opens with an error:

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@42daa83a 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'.

[Marcio Ribeiro]

Hi @license_all

I think you are using a version of SQL Server that is not supported by Confluence: https://confluence.atlassian.com/conf714/supported-platforms-1087525830.html#SupportedPlatforms-Databases

Confluence 7.14.1 only Supports SQL Server 2016 and 2017.

If you are using an unsupported version, please, upgrade your Database before you upgrade Confluence.

Best Regards

[Fabian Lim]

Hi @license_all

I would recommend you open up a ticket with atlassian support here and provide them with logs: https://support.atlassian.com/contact/?postauth=true#/

Regards