Upgrading Confluence to 5.3 or above fails with "Incorrect syntax near the keyword 'where'"
Problem
- Upgrading Confluence to 5.3 fails with "Incorrect syntax near the keyword 'where'".
- The database in use is Microsoft SQL Server 2005.
The following appears in the atlassian-confluence.log:
2013-10-03 08:57:12,030 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.UserMappingLowerUsernameSchemaUpgradeTask@1e665b5 failed during the UPGRADE phase due to: StatementCallback; bad SQL grammar [create unique index user_mapping_unq_lwr_username on user_mapping(lower_username) where lower_username is not null]; nested exception is java.sql.SQLException: Incorrect syntax near the keyword 'where'.
com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.UserMappingLowerUsernameSchemaUpgradeTask@1e665b5 failed during the UPGRADE phase due to: StatementCallback; bad SQL grammar [create unique index user_mapping_unq_lwr_username on user_mapping(lower_username) where lower_username is not null]; nested exception is java.sql.SQLException: Incorrect syntax near the keyword 'where'.
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.executeUpgradeStep(AbstractUpgradeManager.java:278)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.runUpgradeTasks(AbstractUpgradeManager.java:214)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:159)
at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:50)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
Cause
Microsoft SQL Server 2005 is no longer supported after Confluence 5.3 release.
Resolution
You will need to upgrade your MS SQL Server 2005 to a supported version, as described in our Supported Platforms page.
Last modified on Nov 2, 2018
Powered by Confluence and Scroll Viewport.