OBIEE 12c: Logins Fail in a Cluster when OBIS1 is Down

(Doc ID 2330289.1)

Last updated on DECEMBER 01, 2017

Applies to:

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

Symptoms

In a 2-node cluster with OBIEE 12.2.1.2.0 where the nodes are located in different Data Centers ...

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 ...

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

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