Remedy Smart Reporting - ORA-00932 inconsistent datatypes: expected - got CLOB

Version 2
    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 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.


    SOLUTION:

    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.

     


    Article Number:

    000116477


    Article Type:

    Solutions to a Product Problem



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