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 creating a report in Smart Reporting against Incident Management View, the following error is encountered:
"Error retrieving results An error occurred retrieving the results from the database."
"ERROR (552): The SQL database operation failed.; ORA-00932: inconsistent datatypes: expected got CLOB"
Whenever a CLOB data type fields like 'Notes', 'Detailed Description', 'Resolution' fields are added in the report, it may result into an error depending on the SQL query generated due to limitations around the use of CLOB fields that are specific to Oracle.
- Go to Administration > Admin console > Data Source > connection > ARSystem
- Open the AR System data source go to "Custom Parameters" and add parameter: rowLimit=10000, save the changes.