1 Reply Latest reply on Oct 25, 2018 4:20 AM by Marek Ceizel

    ERROR (552): The SQL database operation failed.; The text data type cannot be selected as DISTINCT because it is not comparable.

    Shashank Tiwari

      1. Checked for AR getlist setting in AR Configuration, and set it to 2000, In that case JDBC will fetch only 2000 rows for every query (Refer below screen), Set it in the AR some higher value so it can get more number of rows.

       

       

      2. Verified the parameter in AR Data Source connection, AR System data source in Smart Reporting from Administration panel and added rowLimit=10000 , now query will fetch 10000 rows.

       

       

      3. Have selected the Show Duplicate records and we were able to get the data of all long text fields.

       

       

      4. It is recommended to select  'Show Duplicate records' for all CLOB fields available in the Smart reporting

       

       

       

       

      5-Group by implicitly performs distinct operation and is a limitation of SQL server.

      6-When adding an nText/ long Text type of field, do not use an aggregate field or DISTINCT data type. Otherwise, the following error is displayed:

      An exception occured: ERROR (552): The SQL database operation failed.; The ntext data type cannot be selected as DISTINCT because it is not comparable.. Please check the SQL syntax and try again.