Set operation failed due to incompatible sort order

SonPat99

Dear GURUS,

I am using OBIEE 12.2.1.4.19X version.

I have created a Dashboard with a Variable Prompt and a UNION Report (Union of 3 reports).

I am trying to create a metadata search report based on Table, Table Name, Report, Subject Area, Report Column Name.

This works great when I am searching for a few strings as below:

However, this report gives an error when I am searching JE...

Also, there is NO Sort Order defined in the Union Report.

Request you to kindly help me.

Note: I have also referred a few other sites for the answer, but none of them worked.

There are no Measures used in the report as well.

User_W8LRQ

Hi Sonpat ,

I would request you to share the solution for this I am also stucked with same issue .

Thanks

Shivani

[Deleted User]

https://community.oracle.com/tech/apps-infra/discussion/comment/16825143#Comment_16825143

This is a 2 year old, dead thread. If you have a question, please open your own thread and clearly and precisely explain your issue, your environment details with exact version number etc. and manage your question there.