Hi wm community,
We are getting the following error in our Production system randomly around once a month for the last 3 months:
[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource mbl.connections.loanIQ.common.adapters.jdbc:conn_loanIQ_common. [ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource mbl.connections.loanIQ.common.adapters.jdbc:conn_loanIQ_common. [ADA.1.204] Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleDataSource". IO Error: Socket read timed out
Max Pool Size = 10
Block Timeout = 60000
Expire Timeout = 60000
The error would happen, and then subsequent pollings would work again. This doesn’t seem to be connection pool related since that gives a different error:
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource The pool doesn't have a connection available for the request.
This adapter only polls once every 5 minutes, there are no one else using this connection pool. There are no errors in the DB logs and it hasn’t exceeded any DB thresholds either.
I’ve found some similar threads on the Oracle forums also, but none had any reasonable solutions:
Has anyone experienced similar issues or can offer some insight?