Running Queries Against Multiple ADW DataSource Connections In Oracle Analytics Cloud Intermittently Fails With ORA-12529 Error
(Doc ID 2720533.1)
Last updated on OCTOBER 26, 2020
Applies to:Oracle Analytics Cloud - Version 105.7.0 and later
Information in this document applies to any platform.
The below error is experienced in the UI intermittently when querying from any of the multiple ADW data source connection created in Data Visualization:
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 12529, message: ORA-12529: TNS:connect request rejected based on current filtering rules at OCI call OCIServerAttach. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)
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