BICS : After upgrade When Using Specific Dimension Query Error thrown - "None of the dimension tables are compatible with the query request Job" (Doc ID 2157946.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 and later
Information in this document applies to any platform.

Symptoms

BICS query failing when using the Job dimension.
No issues prior to BICS upgrade.

Query Error thrown:

 Error
  View Display Error
    You may be able to evaluate this query if you remove one of the following column references: Job.Job ID <br>
    Please have your System Administrator look at the log for more details on this error. (HY000)
+ Error Details
   Error Codes: :U9IM8TAC:OI2DL65P
    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: 14077] None of the dimension tables are compatible with the query request Job.
    [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Job.
    Please have your System Administrator look at the log for more details on this error. (HY000)
    Please have your System Administrator look at the log for more details on this error.

Changes

 BICS upgrade occurred over weekend

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms