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.ForwardingPreparedStatement.executeQuery(ForwardingPreparedStatement.java:40) at net.java.ao.ParameterMetadataCachingPreparedStatement.executeQuery(ParameterMetadataCachingPreparedStatement.java:10) at net.java.ao.EntityManager.find(EntityManager.java:750) at 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
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.ForwardingPreparedStatement.executeQuery(ForwardingPreparedStatement.java:40)
at net.java.ao.ParameterMetadataCachingPreparedStatement.executeQuery(ParameterMetadataCachingPreparedStatement.java:10)
at net.java.ao.EntityManager.find(EntityManager.java:750)
at 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