My Oracle Support Banner

OBIEE 12c: Unable To Query MSAS Cube After Applying Patch P26796833_122130_Linux-x86-64 (Doc ID 2447650.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

On:Oracle Business Intelligence Enterprise Edition

After applying the patch p26796833_122130_Linux-x86-64.zip

All the dashboards with any analysis written using the Cube as a data source are failing immediately.

Dashboards that use a traditional database as the data source e.g. Oracle RDBMS are still working.

Below is the Error recorded

Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
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: 12002. [nQSError: 12002] Socket communication error at call=select or poll: (Number=115) time out after 0 seconds (HY000)
State: HY000. Code: 12010. [nQSError: 12010] Communication error connecting to remote end point: address = dlonwbobis55; port = 80. (HY000)
State: HY000. Code: 46119. [nQSError: 46119] Failed to open HTTP connection to server dlonwbobis55 at port 80. (HY000)
SQL Issued: SELECT 0 s_0, "FBI - FUM"."Time"."Fiscal Period" s_1, "FBI - FUM"."- FUM"."FUM Closing" s_2, "FBI - FUM"."- FUM"."FUM Opening" s_3 FROM "FBI - FUM" WHERE ("Time"."Fiscal Period" BETWEEN 201701 AND 201706) FETCH FIRST 10000001 ROWS ONLY

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.