OBIEE 12c: Error "nQSError: 69018" Occurred When Testing Cluster Connect
Last updated on JUNE 23, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Error: [nQSError: 69018] Connection succeeded but xxxxxxxxx:xxxxx failed to respond occurred when testing Cluster Connect of System DSN for Oracle BI Server.
Steps to reproduce the issue:
1. Launch ODBC Data Source Administrator.
2. Go to the [System DSN] tab -> [Add]
3. Check [Clustered DSN] and Add Primary/Secondary Controller information and port
4. Press [Test Cluster Connect].
5. Error message returns
[nQSError: 69018] Connection succeeded but xxxxxxxxx:xxxxx failed to respond
The message mentions the response from Secondary Controller is failed. ex)Secondary Controller:xx.xxx.xx.48:9508
When you shutdown the Primary Controller (ex. xx.xxx.xx.44:9508), then the response from the Primary Controller failed.
Checked [Clustered DSN] option when configuring ODBC data source.
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