BICS - RDC connection fails with [nQSError: 12002] Socket communication error

(Doc ID 2229766.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 and later
Information in this document applies to any platform.

Goal

After configure of RDC, What is cause of Socket communication error seen with failing connection to BICS ?

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 12002] Socket communication error at call=send: (Number=9) Bad file descriptor
Please have your System Administrator look at the log for more details on this error. (HY000)


But if the Query is run from the back end, its running fine.

Solution

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