OBIEE Datatype Error

Question

Hello Experts,

One OBIEE Report is working fine in the Windows OS (OBIEE). The same report is not working in Linux OS(OBIEE). I have taken the same rpd and catalog and placed it into Linux box where obiee is up and running. While testing we have noticed that one report is failed with the below error. The same report is working on the windows server. I was thinking it was due to the NLS setting issue in the database?

Windows and Linux  OBIEE Version: 12.2.1.2.0

Error Message:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 59001. [nQSError: 59001] Join operation is not permitted on operand(s). (HY000)

State: HY000. Code: 46035. [nQSError: 46035] Datatype(INTEGER) nullable(0) unicode(1) external char(0) conversion to datatype(VARCHAR) nullable(0) unicode(1) external char(0) is not supported. (HY000)

Any clue?

User_P0XGZ · Answer

okay

GayathriAnand-Oracle · Answer

@User_P0XGZ This is an old post. Please open a new post and provide details of the issue seen.

Thanks

Gayathri

User_P0XGZ · Answer

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 59001. [nQSError: 59001] Join operation is not permitted on operand(s). (HY000)

State: HY000. Code: 46035. [nQSError: 46035] Datatype(CHAR) nullable(0) unicode(1) external char(0) conversion to datatype(INTEGER) nullable(0) unicode(1) external char(0) is not supported. (HY000)

OBI 12c analysis is throwing this error? Where could be the issue?