This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
Smart Reporting Remedy
Smart Reporting 9x
When CLOB fields are used in reports, the following error is encountered:
An exception occurred: ERROR (552): The SQL database operation failed.; ORA-00932: inconsistent datatypes: expected - got CLOB . Please check the SQL syntax and try again.
This is a known issue and due to a limitation in Oracle.
Workaround: Check “Show Duplicate Records” option (Highlighted in green rectangle box in screenshot attached) and run the report.