OBIEE 12c: Answers Query Failed With Timeout Error With JDBC Datasource
(Doc ID 2428788.1)
Last updated on NOVEMBER 30, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12c]
Information in this document applies to any platform.
Answers query failed with timeout error with JDBC datasource
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: 46169. [nQSError: 46169] An HTTP operation to host:port timed out after 60 seconds. Operation aborted. (HY000)
- Open uploaded RPD using BI Admin Tool
- Load Java Data Sources
- Enter Hostname, Port, UserName, Password
- Then go to the Physical Database
- Connection Pool has the correct url info for the JNDI data source
Reports are working fine with JDBC datasource when queries take less than 60 sec.
But if query runs more than 60 sec it timeouts.
Environment details: OBIEE 188.8.131.52.0
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