Trying to get the Search to work in CRM Contact List

[Tomball Admin]

We get a System error when we use the search tool in the addon.

com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:10.50.2500 - minor version:50 - major version:10 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.2.2 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:136)

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:368)

[Philipp Eckelmann]

Hi Ben,

I just found this message here. We currently evaluate the logs you provided. Enabling the extended logging was very helpful. 

Besides the issues with our add-on there are quite a lot of SQLException mentioned in the log file. Maybe, there is also a problem with Confluence itself. You might want to send the logs also to your admins. It would be very helpful to learn what they say.

Thanks and best regards
Philipp