Exalate problem

Originally asked by Ardalanrazzaghi on 03 October 2021 (original question)


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


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?