GenericEntityException while JIRA upgrade

[Viktor Kuzmychov]

I'm testing JIRA upgrade and geeting below error:

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error creating GenericValue (definition fieldType 4k-varchar not found, cannot getValue for field DirectoryAttribute.value.)

Any ideas what that would be? 

I'm using server 7.12.0 and upgrading to 8.2.0

[Viktor Kuzmychov · Accepted solution]

Apparently JIRA DB has its limits, especially on Oracle. Couple of my Table Grid custom fields had configuration exceeding limit for genericconfiguration table xmlvalue field.

After reducing its length to <4000 I was able to upgrade. 

[Viktor Kuzmychov]

In log it looks like this:

2019-05-27 19:27:54,408 JIRA-Bootstrap ERROR [c.a.jira.upgrade.UpgradeLauncher] An error occurred whilst trying to upgrade JIRA.
com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error creating GenericValue (definition fieldType 4k-varchar not found, cannot getValue for field DirectoryAttribute.value.)
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:92)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizDirectoryDao.findAll(OfBizDirectoryDao.java:78)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizApplication.getDirectoryMappings(OfBizApplication.java:57)
at com.atlassian.crowd.embedded.core.CrowdDirectoryServiceImpl.findAllDirectories(CrowdDirectoryServiceImpl.java:76)
at com.atlassian.jira.user.util.DefaultUserManager.getAllUsersFromCrowd(DefaultUserManager.java:166)
at com.atlassian.jira.user.util.DefaultUserManager.getTotalUserCount(DefaultUserManager.java:104)
at com.atlassian.jira.bc.license.JiraLicenseServiceImpl.validate(JiraLicenseServiceImpl.java:74)
at com.atlassian.jira.bc.license.JiraLicenseServiceImpl.validate(JiraLicenseServiceImpl.java:140)
at com.atlassian.jira.upgrade.LicenseCheckingUpgradeService.runUpgrades(LicenseCheckingUpgradeService.java:89)
at com.atlassian.jira.upgrade.ClusterLockingUpgradeService.runUpgrades(ClusterLockingUpgradeService.java:35)
at com.atlassian.jira.upgrade.LoggingUpgradeService.lambda$runUpgradesWithLogging$0(LoggingUpgradeService.java:28)
at com.atlassian.jira.upgrade.LoggingUpgradeService.runWithTaskLogging(LoggingUpgradeService.java:43)
at com.atlassian.jira.upgrade.LoggingUpgradeService.runUpgradesWithLogging(LoggingUpgradeService.java:28)
at com.atlassian.jira.upgrade.IndexingUpgradeService.runUpgrades(IndexingUpgradeService.java:19)
at com.atlassian.jira.upgrade.DefaultUpgradeService.runUpgrades(DefaultUpgradeService.java:56)
at com.atlassian.jira.upgrade.UpgradeLauncher.upgradeIfNeeded(UpgradeLauncher.java:109)
at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:86)
at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:50)

[Viktor Kuzmychov]

8.2.1 is available now so I tried to upgrade to that one. Got this:

ORA-00932: inconsistent datatypes: expected - got CLOB