Unable to Restore Backup into MS SQL Server
Symptoms
The following error is thrown by JIRA in the browser during the restore of a backup, when using Microsoft SQL Server:
Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.)
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE portalpage SET ppversion = ? WHERE id = ? (Invalid column name 'id'.)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByPrimaryKey(DefaultOfBizDelegator.java:552)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build437.doUpgrade(UpgradeTask_Build437.java:63)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:508)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:419)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:356)
Cause
The problem is caused by the incorrect collation type configured in the MS SQL Server.
Resolution
Ensure JIRA is connected to a MS SQL Server database with the required collation type as specified in the following documentation:
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.