JIRA Upgrade from 5.2 to 6.3.1 [FAILED]

Hello,

i upgraded my 5.2 version of JIRA to 6.3.1 version. But when connecting i get the following error code:

Could not connect to database
2014-07-28 15:28:03 error
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY FROM project (Unknown column 'ORIGINALKEY' in 'field list')
An error occurred performing JIRA upgrade
2014-07-28 15:28:04 error
Error occurred during export before upgrade: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY FROM project ORDER BY pname (Unknown column 'ORIGINALKEY' in 'field list')
 If necessary, auto-export can be disabled; see http://www.atlassian.com/software/jira/docs/latest/upgrade/autoexport.html
com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY FROM project ORDER BY pname (Unknown column 'ORIGINALKEY' in 'field list')
	at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:60)
	at com.atlassian.jira.project.CachingProjectManager.getProjectObjects(CachingProjectManager.java:227)
	at com.atlassian.jira.project.CachingProjectManager.getProjectCount(CachingProjectManager.java:238)
	at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntities(DefaultSaxEntitiesExporter.java:90)
	at com.atlassian.jira.bc.dataimport.DefaultExportService.exportJIRA(DefaultExportService.java:202)
	at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:88)
	at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:70)
	at com.atlassian.jira.bean.export.AutoExportImpl.exportData(AutoExportImpl.java:95)
	at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:387)
	at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:346)
	at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:106)
	at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:54)
	at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:42)
	at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:133)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:324)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:214)
	at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:115)
	at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:31)
	at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:78)
	at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
	at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:73)
	at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY FROM project ORDER BY pname (Unknown column 'ORIGINALKEY' in 'field list')
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:364)
	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findAll(WrappingOfBizDelegator.java:206)
	at com.atlassian.jira.project.DefaultProjectManager.getProjects(DefaultProjectManager.java:518)
	at com.atlassian.jira.project.ProjectCache.refreshProjectList(ProjectCache.java:119)
	at com.atlassian.jira.project.ProjectCache.init(ProjectCache.java:96)
	at com.atlassian.jira.project.ProjectCache.(ProjectCache.java:82)
	at com.atlassian.jira.project.CachingProjectManager$ProjectCacheSupplier.get(CachingProjectManager.java:434)
	at com.atlassian.jira.project.CachingProjectManager$ProjectCacheSupplier.get(CachingProjectManager.java:429)
	at com.atlassian.cache.memory.MemoryCacheManager$1$1.load(MemoryCacheManager.java:63)
	at com.atlassian.cache.memory.MemoryCacheManager$1$1.load(MemoryCacheManager.java:59)
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3573)
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2350)
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2313)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2228)
	at com.google.common.cache.LocalCache.get(LocalCache.java:3970)
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
	at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4834)
	at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:56)
	... 31 more
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter, ASSIGNEETYPE, AVATAR, ORIGINALKEY FROM project ORDER BY pname (Unknown column 'ORIGINALKEY' in 'field list')
	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:605)
	at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:851)
	at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:725)
	at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:901)
	at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:879)
	at org.ofbiz.core.entity.GenericDelegator.findAll(GenericDelegator.java:802)
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:360)
	... 48 more
Anyone has suggestions? Thanks!

3 answers

1 accepted

This widget could not be displayed.

This may be along the lines of the problem I had recently with an upgrade where the database wasn't set to the correct language.

See this answer - https://answers.atlassian.com/questions/294657/invalid-column-name-creator-after-installing-a-fresh-jira

Check the settings for the database, they may have the incorrect language support pack.

This widget could not be displayed.

Problem solved. Ticket can be closed now.

Hey Theo,

You cannot close tickets here. You can mark Steve's answer as correct if it helped you resolve the issue. Simply click on the tick mark you see on Steve's answer to mark it correct :)

This widget could not be displayed.

Can I ask you how to solve this problem? thanks.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

269 views 5 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you