My Oracle Support Banner

nQSError: 12061 Communication Error Connecting To Remote End Point In OAS While Running Dashboard Reports (Doc ID 2929968.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Oracle Analytics Server - Version 2022 ( and later
Information in this document applies to any platform.


OAS - Issue after upgrading Java as part of Jan 2023 OAS bundle patch upgrade.
As part of the Jan Bundle patch upgrade, Java is upgraded to Java SE 8 Update 361 but then reverted back to previous Java version.

All the services are coming up with no issue. Users can login to OAS analytics/dv.

But the dashboard reports are failing with the following error

Odbc driver returned an error (SQLDriverConnectW).
Error Details
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 12002. [nQSError: 12002] Socket communication error at call=connection: (Number=111) Connection refused (HY000)
State: HY000. Code: 12061. [nQSError: 12061] Communication error connecting to remote end point. (HY000)"

DV connection to the database also failing. Subject areas are not showing up while creating analysis.

Connection from sql plus client on the same machine as the OAS setup is working ok. There is no connectivity issue with DB host and port. Curl test to DB host and port is successful from the same OAS machine.

BI end points were verified, they are all ok.


 Prior to OAS Jan 2023 bundle patch Java upgrade and rollback, OAS October 2022 bundle patch was also applied partially and then due to conflict the patches were rolled back.


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

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