My Oracle Support Banner

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

Last updated on JUNE 08, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.