OBIEE 12c: Logins Fail in a Cluster when OBIS1 is Down
(Doc ID 2330289.1)
Last updated on JUNE 24, 2024
Applies to:
Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 and laterInformation 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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |