Oracle Error (ora-932) after upgrade to 6.0

Renato Schmid February 5, 2013

After upgrading 5.2.5 to 6.0 I'm getting the following error:

Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT OLDVALUE FROM changeitem WHERE FIELD=? (ORA-00932: inconsistent datatypes: expected - got CLOB

)

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT OLDVALUE FROM changeitem WHERE FIELD=? (ORA-00932: inconsistent datatypes: expected - got CLOB

)

at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:489)

at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:124)

at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6031.updateChangeItemValues(UpgradeTask_Build6031.java:72)

at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6031.doUpgrade(UpgradeTask_Build6031.java:50)

at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:676)

at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:529)

at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:459)

at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:402)

at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:336)

at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100)

at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:49)

at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:105)

at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:323)

at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:211)

at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:96)

at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:23)

at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:62)

at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33)

at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:57)

at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:54)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)

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(FutureTask.java:334)

at java.util.concurrent.FutureTask.run(FutureTask.java:166)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:679)

Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT OLDVALUE FROM changeitem WHERE FIELD=? (ORA-00932: inconsistent datatypes: expected - got CLOB

)

at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:605)

at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1061)

at org.ofbiz.core.entity.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:175)

at org.ofbiz.core.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:999)

at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:484)

... 29 more

2 answers

1 accepted

3 votes
Answer accepted
JohnA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 5, 2013

Hi Renato,

I've been doing some investigation into this issue for you and it seems like it might be a known issue related to the JIRA Misc Custom Fields plugin, as described here: https://innovalog.atlassian.net/browse/JMCF-44

However, as you have just upgraded to JIRA 6 I suspect the problem may simmply by that the plugin isn't compatible with that version beacause the plugin appears to only be compatible with JIRA upto v5.2.5 so I would suggest trying to disable that plugin and see whether the issue persists or not: https://marketplace.atlassian.com/plugins/com.innovalog.jmcf.jira-misc-custom-fields

If this doesn't resolve your issue then I would recommend that you open a ticket with Support so that we can investigate the issue, but please mention this Answer so that we can update the solution for the next person who might face the same issue.

All the best,
John

0 votes
Renato Schmid February 11, 2013

It was a new installation with no additional plugins installed. But we decided to go back to version 5.2.5 and wait for the official version 6.

Thanks for your help.

Renato

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events