OBIEE 12c: Logins Fail in a Cluster when OBIS1 is Down (Doc ID 2330289.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

In a 2-node cluster with OBIEE 12.2.1.2.0 where the nodes are located in different Data Centers ...
Note: horizontal scale-out across geographic data centers is not supported.

When the BI Server (obis1) is down on the Primary node, it is expected that users would still be able to login successfully to OBIEE as the BI Server (obis2) on the Secondary node is still running.  However, user logins fail and the following errors are observed in the logs:-

See the Presentation Server log file:-

---------------------------------------------------------------------------------------------------------

[OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] ... Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 73025. [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[
File:checkauthentication.cpp
...
]]

---------------------------------------------------------------------------------------------------------

 
See the Cluster Controller log file:-

---------------------------------------------------------------------------------------------------------

[OBICCS] [ERROR:1] ... [71102] No server instance can be assigned to the client ...

---------------------------------------------------------------------------------------------------------

Changes

Cause

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