Remedy Smart Reporting - ERROR (552) ORA-00932: inconsistent datatypes: expected  got CLOB

Version 7
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    Smart Reporting 9x



    PROBLEM:

    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"


    SOLUTION:

    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.

    Workaround:

       
    • 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.
      
      

     


    Article Number:

    000115391


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles