Space banner

 

This documentation supports the 19.08 version of Remedy IT Service Management Suite.

To view an earlier version, select the version from the Product version menu.

Aggregation

For information about aggregation in this release, see Aggregation.

Info

  • (For Microsoft SQL Server database) When adding an nText type of field to a report, 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.
    Also ensure that you select the Show Duplicates option to avoid an error. A list of nText fields is available here.

  • (For Oracle database) When adding a Character Large Object (CLOB) type of field to a report, 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.; ORA-00932: inconsistent datatypes: expected - got CLOB . Please check the SQL syntax and try again.
    Also ensure that you select the Show Duplicates option to avoid an error. A list of CLOB fields is available here.

Was this page helpful? Yes No Submitting... Thank you

Comments