incompatible sort order

Sulochana

Hi Team,

I  am getting error while running union reports in Obiee 11g .Below is the error message for the same

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59107] Set operation failed due to incompatible sort order. (HY000)

I have tried all options still its not working and getting same error

Below are the options i have used

1)

Verified SORT_ORDER and SORT_ORDER_LOCALE parameters in the NQSCONFIG.INI file.

Then go to database features tab in RPD  and changed SORT_ORDER_LOCALE parameter to Spanish.

Above one also didnt work

2)

Verified SORT_ORDER and SORT_ORDER_LOCALE parameters in the NQSCONFIG.INI file.

Then go to database features tab in RPD  and changed SORT_ORDER_LOCALE parameter to Empty

No luck

Any one give me suggestion for the same please

Thanks,

Sulochana

Jerry Casey

Have you tried bringing the sort column outside of the union?  By that, I mean going to the header level and using the "Add a Result column" option.  If it's the fourth column, refer to it as "saw_3" (first column is saw_0).  Sort on that instead of the original column.

If that doesn't work, add a function to it, like SUM(saw_3 by saw_0), or MAX(saw_3 by 1), whatever is appropriate, and check the "treat as attribute" box (which you won't see until after you try running the first option.

Both of these have fixed union sorting situations for me.