Oracle error - ORA-00932: inconsistent datatypes: expected - got CLOB

Description

I am receiving the following error which seems to be inhibiting the transition between multiple states.

I understand the warning, due to not having the transition ID in the description, but the documentation indicated that it was recommended, not required... and it's just a warning in the log so that shouldn't be what's inhibiting the transition. What seems to be the killer is the actual error. The whole error is quite long and I can supply the whole log if requested.

2012-08-22 20:19:40,558 http-15080-4 WARN mrotenbu 1219x104x1 1q1wgqy 172.31.248.197 /browse/ETNA-459 [innovalog.jmcf.fields.AbstractTransitionSearchField] com.innovalog.jmcf.fields.ActionExecutionCallerField: could not find transition name or ID in custom field description
2012-08-22 20:19:40,563 http-15080-4 ERROR mrotenbu 1219x104x1 1q1wgqy 172.31.248.197 /browse/ETNA-459 [innovalog.jmcf.fields.WorkflowHistoryDAO] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ci.OLDVALUE, cg.CREATED FROM changeitem ci INNER JOIN changegroup cg ON ci.groupid=cg.ID WHERE cg.issueid=? AND ci.field='workflow'ORDER BY CREATED DESC (ORA-00932: inconsistent datatypes: expected - got CLOB
)
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ci.OLDVALUE, cg.CREATED FROM changeitem ci INNER JOIN changegroup cg ON ci.groupid=cg.ID WHERE cg.issueid=? AND ci.field='workflow'ORDER BY CREATED DESC (ORA-00932: inconsistent datatypes: expected - got CLOB
)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:605)
at com.innovalog.jmcf.fields.WorkflowHistoryDAO.findWorkflowEntry(WorkflowHistoryDAO.java:95)
at com.innovalog.jmcf.fields.ActionExecutionCallerField.getValueFromIssue(ActionExecutionCallerField.java:43)
at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:355)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.getCustomFieldRenderLayoutItem(StandardFieldScreenRendererFactory.java:143)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.createFieldScreenRenderer(StandardFieldScreenRendererFactory.java:104)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.createFieldScreenRenderer(StandardFieldScreenRendererFactory.java:73)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.createFieldScreenRenderer(StandardFieldScreenRendererFactory.java:50)
at com.atlassian.jira.issue.fields.screen.FieldScreenRendererFactoryImpl.getFieldScreenRenderer(FieldScreenRendererFactoryImpl.java:49)
at sun.reflect.GeneratedMethodAccessor494.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

Environment

Oracle 11g, JIRA 5.0.6

Customer Info

None

Assignee

Unassigned

Reporter

Matthew Rotenbury

Labels

Internal Complexity

Unknown

Internal Value

Unknown

Requires documentation

None

Impact

None

Fix versions

Affects versions

Priority

Critical
Configure