Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

The dashboard error is occurring intermittently.

Received Response
34
Views
1
Comments
User_P0XGZ
User_P0XGZ Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

OBIEE 12C Analysis/Dashboard is giving below error:

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)

image.png


The solution offered in oracle doc: Document 2817949.1 is also not helpful. We are getting error while intermittently the dashboard/analysis is working fine.
Below is the solution offered by oracle which is not working in this scenario.

Update the prefix of the affected analysis, but adding the following code in the Prefix section in the Advanced tab:
set variable OBIS_USE_EAGER_JOIN=0

Can I get help on resolving this?

Tagged:

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics & AI Coach

    Hello @User_P0XGZ ,

    It looks like this question was missed. Your error with conversion to datatype(INTEGER) in the error is a little different than the error in the KM article you mentioned. Although this KM is also not identical, it does mentioned a conversion to a Numeric datatype.

    See:

    Datasets Created With Direct Database Connection Don't Update Column Data Type In Case Of Data Model Change (Doc ID 2941120.1)

    Regards,

    John