Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

incompatible sort order

SulochanaDec 3 2018 — edited Dec 3 2018

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

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

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

Added on Dec 3 2018

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

1,316 views