Calendars not listed in Calendar Insights calendar list

Issue #2 resolved
Former user created an issue

Hello, Using the plugin for the first time. When I select "Insights" button no calendars are listed for the space, though calendars exist - I get a blank list.

I'm seeing several resource load errors in the javascript on the rest calls that appear to be database query related.

URL:
.../rest/calendar-insight-services/1.0/calendar-insight/calendars?startIndex=0&pageSize=10&key=&_=1467743653240

<message> There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:12.00.4213 - minor version:0 - major version:12 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.2.2 java.sql.SQLException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. </message>

<message> There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:12.00.4213 - minor version:0 - major version:12 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.2.2 java.sql.SQLException: Argument data type ntext is invalid for argument 1 of lower function. </message>

<message> There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:12.00.4213 - minor version:0 - major version:12 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.2.2 java.sql.SQLException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. </message>

System config:

Confluence v5.9.11 Calendar Insights v1.2.0

Comments (5)

  1. Brian Keefe

    Just installed and seeing the same thing with:

    • Confluence Server 5.9.12
    • Team Calendars 5.3.11
    • Insights 1.2.0 (trial license)
  2. Log in to comment