Error in Smart Reporting when reporting against unlimited/CLOB field

Version 1
    Share:|

    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:

    ITSM In-App Reporting


    APPLIES TO:

    Smart Reporting



    PROBLEM:

    Error Message:
    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.


    SOLUTION:

    We have known issue, where any custom field added in reporting or OOB field whose datatype is ‘CLOB’ and whenever we create a report with these fields. It throws an error: 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.

    Here ‘Notes’ field datatype is ‘CLOB’ and due to this it throws an error.

    Workaround: Request to Check “Show Duplicate Records” option (Highlighted in green rectangle box in screenshot attached) and run the report.

    R&D team is working on this to fix this in upcoming release. 


    Article Number:

    000116477


    Article Type:

    Solutions to a Product Problem



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