# Waiting for remote **URL:** \ **Category:** General Questions\ **Tags:** exalate, migrated\_question\ **Created:** [November 4, 2024, 7:25am UTC](https://community.exalate.com/t/waiting-for-remote/4811 "2024-11-04T07:25:23Z")\ **Posts on this page:** 2\ **Page:** 1
**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:25am UTC](https://community.exalate.com/t/waiting-for-remote/4811/1 "2024-11-04T07:25:23Z")
_Originally asked by GG on 16 August 2021 [(original question)](https://oldcommunity.exalate.com/questions/30051009)_ * * * Hi, Some Issues do not sync and are in the “WATING FOR REMOTE”. I see the following error in the Exalate log. What is the problem? [2021-08-15 18:05:52,202] \ There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:14.00.1000 - minor version:0 - major version:14 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.3.1 java.sql.SQLException: The ntext data type cannot be selected as DISTINCT because it is not comparable. com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:14.00.1000 - minor version:0 - major version:14 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.3.1 java.sql.SQLException: The ntext data type cannot be selected as DISTINCT because it is not comparable. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:142) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:296) at sun.reflect.GeneratedMethodAccessor308.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 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:179) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 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:179) at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy3492.find(Unknown Source) at com.exalate.persistence.message.MessageChunkRepository.getStreamWithStatus(MessageChunkRepository.java:96) at com.exalate.persistence.message.MessageChunkRepository.getStreamWithStatusUnbatching(MessageChunkRepository.java:85) at com.exalate.replication.services.message.worker.MessageUnbatcherActor$$anonfun$com$exalate$replication$services$message$worker$MessageUnbatcherActor$$waitingForAfterTheLastMessage$1.$anonfun$applyOrElse$3(MessageUnbatcherActor.scala:66) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at com.exalate.replication.services.utils.ActorLoggingService.tryWithLoggedBugs(ActorLoggingService.scala:18) at com.exalate.replication.services.message.worker.MessageUnbatcherActor$$anonfun$com$exalate$replication$services$message$worker$MessageUnbatcherActor$$waitingForAfterTheLastMessage$1.applyOrElse(MessageUnbatcherActor.scala:60) at akka.actor.Actor.aroundReceive(Actor.scala:535) at akka.actor.Actor.aroundReceive$(Actor.scala:533) at com.exalate.replication.services.message.worker.MessageUnbatcherActor.aroundReceive(MessageUnbatcherActor.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.SQLException: The ntext data type cannot be selected as DISTINCT because it is not comparable. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:943) at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541) at net.sourceforge.jtds.jdbc.MSCursorResultSet.\(MSCursorResultSet.java:154) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:452) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at [net.java.ao](http://net.java.ao).EntityManager.find(EntityManager.java:671) at [net.java.ao](http://net.java.ao).EntityManager.find(EntityManager.java:621) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:140) … 39 more * * * #### Comments: > **Ariel Aguilar commented on 16 August 2021** > > > Hi GG, > > It looks there is a problem with the SQL database, I have found information that might be helpful for you: > > [https://www.ryadel.com/en/sql-ntext-data-type-cannot-be-selected-distinct-because-comparable-fix-mssql-tsql/](https://www.ryadel.com/en/sql-ntext-data-type-cannot-be-selected-distinct-because-comparable-fix-mssql-tsql/) > > Kind regards, > > Ariel ---
**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:25am UTC](https://community.exalate.com/t/waiting-for-remote/4811/2 "2024-11-04T07:25:24Z")
_Answer by GG on 21 August 2021_ Hi, Thanks for your reply. I will try it And I will inform you of the result. Regards * * *