# Exalate problem

**URL:** <https://community.exalate.com/t/exalate-problem/4883>\
**Category:** General Questions\
**Tags:** exalate, migrated\_question\
**Created:** [November 4, 2024, 7:29am UTC](https://community.exalate.com/t/exalate-problem/4883 "2024-11-04T07:29:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![xl8bot](https://dub1.discourse-cdn.com/flex018/user_avatar/community.exalate.com/xl8bot/32/324_2.png) [@xl8bot](https://community.exalate.com/u/xl8bot)\
**Post date:** [November 4, 2024, 7:29am UTC](https://community.exalate.com/t/exalate-problem/4883/1 "2024-11-04T07:29:28Z")

</div>

_Originally asked by Ardalanrazzaghi on 03 October 2021 [(original question)](https://oldcommunity.exalate.com/questions/37553486)_

* * *

Hi

We want to use the Exalate plugin  
Jira version:8.13.2  
Exalate version:5.2.2-j8  
we saw some error :

2021-09-25 15:29:37,564+0330 exalate-akka.actor.default-dispatcher-7 ERROR qc.sysadmin 928x72772x1 kt37lz \*.\*.\*.\* /rest/plugins/1.0/ [c.exalate.node.JiranodeLoggingService] There was a SQL exception thrown by the Active Objects library:  
Database:  
- name:Oracle  
- version:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production  
- minor version:2  
- major version:12  
Driver:  
- name:Oracle JDBC driver  
- version:12.2.0.1.0

```
java.sql.SQLSyntaxErrorException: ORA\-00932: inconsistent datatypes: expected \- got CLOB

```

com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:  
Database:  
- name:Oracle  
- version:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production  
- minor version:2  
- major version:12  
Driver:  
- name:Oracle JDBC driver  
- version:12.2.0.1.0  
java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB  
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:152)  
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:302)  
… 3 filtered  
at java.lang.reflect.Method.invoke(Method.java:498)  
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)  
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)  
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)  
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)  
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)  
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)  
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)  
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)  
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)  
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)  
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)  
at com.sun.proxy.$Proxy6507.find(Unknown Source)  
at com.exalate.persistence.message.MessageQueueRepository.getStreamWithStatusBatchingPerConnectionId(MessageQueueRepository.java:130)  
at com.exalate.replication.services.message.worker.MessageBatcherActor$$anonfun$com$exalate$replication$services$message$worker$MessageBatcherActor$$waitingForAfterTheLastMessage$1.$anonfun$applyOrElse$3(MessageBatcherActor.scala:62)  
at com.exalate.replication.services.utils.ActorLoggingService.tryWithLoggedBugs(ActorLoggingService.scala:18)  
at com.exalate.replication.services.message.worker.MessageBatcherActor$$anonfun$com$exalate$replication$services$message$worker$MessageBatcherActor$$waitingForAfterTheLastMessage$1.applyOrElse(MessageBatcherActor.scala:59)  
at akka.actor.Actor.aroundReceive(Actor.scala:535)  
at akka.actor.Actor.aroundReceive$(Actor.scala:533)  
at com.exalate.replication.services.message.worker.MessageBatcherActor.aroundReceive(MessageBatcherActor.scala:31)  
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:575)  
at akka.actor.ActorCell.invoke(ActorCell.scala:545)  
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:270)  
at akka.dispatch.Mailbox.run(Mailbox.scala:231)  
at akka.dispatch.Mailbox.exec(Mailbox.scala:243)  
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)  
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)  
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)  
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)  
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB

```
    at oracle.jdbc.driver.T4CTTIoer11\.processError(T4CTTIoer11\.java:494\)  
    at oracle.jdbc.driver.T4CTTIoer11\.processError(T4CTTIoer11\.java:446\)  
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054\)  
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623\)  
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612\)  
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226\)  
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59\)  
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747\)  
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904\)  
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082\)  
    at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4646\)  
    at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10203\)  
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3775\)  
    at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343\)  
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822\)  
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165\)  
    at org.apache.commons.dbcp2\.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83\)  
    at org.apache.commons.dbcp2\.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83\)  
    at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:42\)  
    at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeQuery$5(DiagnosticPreparedStatement.java:59\)  
    at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:69\)  
    at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55\)  
    at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeQuery(DiagnosticPreparedStatement.java:59\)  
    at [net.java.ao](http://net.java.ao).ForwardingPreparedStatement.executeQuery(ForwardingPreparedStatement.java:40\)  
    at [net.java.ao](http://net.java.ao).ParameterMetadataCachingPreparedStatement.executeQuery(ParameterMetadataCachingPreparedStatement.java:10\)  
    at [net.java.ao](http://net.java.ao).EntityManager.find(EntityManager.java:750\)  
    at [net.java.ao](http://net.java.ao).EntityManager.find(EntityManager.java:700\)  
    at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:150\)  
    ... 38 more  

```

Caused by: Error : 932, Position : 16, Sql = SELECT DISTINCT RELATION.“POST\_EXALATE\_PROCESSOR”,RELATION.“INCOMING\_PROCESSOR”,RELATION.“CREATE\_SYNC\_PANEL\_LINKS”,RELATION.“AUTHENTICATION\_REQUIRED”,RELATION.“LOCAL\_URL”,RELATION.“CREATE\_LINKS”,RELATION.“RECEIVE\_PROTOCOL”,RELATION.“CHANGE\_PROCESSOR”,RELATION.“INVITATION\_SECRET”,RELATION.“DATA\_FILTER”,RELATION.“DESCRIPTION”,RELATION.“CREATE\_PROCESSOR”,RELATION.“AUTHENTICATION\_TOKEN”,RELATION.“INVITATION\_STATUS”,RELATION.“FIELD\_VALUES”,RELATION.“REMOTE\_PASSWORD”,RELATION.“VERSION”,RELATION.“NAME”,RELATION.“REMOTE\_USERNAME”,RELATION.“LOCAL”,RELATION.“ID”,RELATION.“SEND\_PROTOCOL”,RELATION.“ENCRYPTED\_REMOTE\_PASSWORD”,RELATION.“STATUS” FROM “AO\_08F1AF\_RELATION” RELATION JOIN “AO\_08F1AF\_MESSAGE” EXALATE\_MESSAGE ON RELATION.“ID” = EXALATE\_MESSAGE.“CONNECTION\_ID” WHERE EXALATE\_MESSAGE.“STATUS” = :1 AND RELATION.“STATUS” = :2 , OriginalSql = SELECT DISTINCT RELATION.“POST\_EXALATE\_PROCESSOR”,RELATION.“INCOMING\_PROCESSOR”,RELATION.“CREATE\_SYNC\_PANEL\_LINKS”,RELATION.“AUTHENTICATION\_REQUIRED”,RELATION.“LOCAL\_URL”,RELATION.“CREATE\_LINKS”,RELATION.“RECEIVE\_PROTOCOL”,RELATION.“CHANGE\_PROCESSOR”,RELATION.“INVITATION\_SECRET”,RELATION.“DATA\_FILTER”,RELATION.“DESCRIPTION”,RELATION.“CREATE\_PROCESSOR”,RELATION.“AUTHENTICATION\_TOKEN”,RELATION.“INVITATION\_STATUS”,RELATION.“FIELD\_VALUES”,RELATION.“REMOTE\_PASSWORD”,RELATION.“VERSION”,RELATION.“NAME”,RELATION.“REMOTE\_USERNAME”,RELATION.“LOCAL”,RELATION.“ID”,RELATION.“SEND\_PROTOCOL”,RELATION.“ENCRYPTED\_REMOTE\_PASSWORD”,RELATION.“STATUS” FROM “AO\_08F1AF\_RELATION” RELATION JOIN “AO\_08F1AF\_MESSAGE” EXALATE\_MESSAGE ON RELATION.“ID” = EXALATE\_MESSAGE.“CONNECTION\_ID” WHERE EXALATE\_MESSAGE.“STATUS” = ? AND RELATION.“STATUS” = ?, Error Msg = ORA-00932: inconsistent datatypes: expected - got CLOB

```
    at oracle.jdbc.driver.T4CTTIoer11\.processError(T4CTTIoer11\.java:498\)  
    ... 66 more  

```

2021-09-25 15:29:39,866+0330 pool-101-thread-1 WARN qc.sysadmin 928x72772x1 kt37lz \*.\*.\*.\* /rest/plugins/1.0/ [c.a.j.cache.request.RequestCacheRecorderImpl] Invalid use of RequestCache by thread: pool-101-thread.Incorrect usage of JIRA API. You can only create/use:

We changed the Oracle JDBC driver from 12.2 to 19.3,but a similar error was received

* * *

---

<div class="post-metadata">

**Author:** ![xl8bot](https://dub1.discourse-cdn.com/flex018/user_avatar/community.exalate.com/xl8bot/32/324_2.png) [@xl8bot](https://community.exalate.com/u/xl8bot)\
**Post date:** [November 4, 2024, 7:29am UTC](https://community.exalate.com/t/exalate-problem/4883/2 "2024-11-04T07:29:29Z")

</div>

_Answer by Francis Martens (Exalate) on 03 October 2021_

This is a known problem and has been fixed in version 5.2.4 (JIRANODE-3379)  
Can you give it a try?

* * *