Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Datatype Error
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?
Answers
-
Are you really talking about a "report" which means a BI Publisher report object? Or do you mean an "analysis" which means an OBIEE analysis object? Two different technologies, two different object types.
Please be specific and don't use the terms interchangeably. They do have serious meaning and imoplications.
0 -
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?0 -
@User_P0XGZ This is an old post. Please open a new post and provide details of the issue seen.
Thanks
Gayathri
0 -
okay
0
