Connection To Discoverer 11g Intermittently Fails With "Cannot retrieve connection list" (Doc ID 1565315.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2016***

Symptoms


When trying to login to Discoverer below error is encountered intermittently

A connection error.
- error while creating the session, check for other errors.
- oracle.discoiv.connections.ConnectionStoreException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out
- weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out
- weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out
unable to retrieve connection list
- Cannot retrieve connection list. Check the Discoverer application log for more details.

 

The WLS_DISCO-diagnostic.log and diagnostic.log show following exceptions:

[2013-05-23T11:28:42.729+03:00] [WLS_DISCO] [ERROR] [] [ORACLE.DISCOVERER.VIEWER] [tid: Discoverer Viewer BG Worker 0] [userId: <anonymous>] [ecid: 0000JvFDLLsF^6S_uDT4iX1HbNt4000002,0] [APP: discoverer#11.1.1.2.0] error.connection.failed[[
oracle.discoverer.applications.viewer.controllers.ControllerException: error.connection.failed
Caused by: oracle.discoverer.applications.viewer.model.ConnectionException: error.creating.session
Caused by: oracle.discoiv.direct.DiscovererDirectException: oracle.discoiv.connections.ConnectionStoreException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out
Caused by: oracle.discoiv.connections.ConnectionStoreException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out
Caused by: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out

[2013-05-23T11:28:49.220+03:00] [WLS_DISCO] [ERROR] [] [ORACLE.DISCOVERER.VIEWER] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 00053GxwnhGF^6S_uDDCiX0002y^000092,0:1] [APP: discoverer#11.1.1.2.0] [URI: /discoverer/app/urlapi] error.retreiving.conn.list[[
oracle.discoverer.applications.framework.ApplicationException: error.retreiving.conn.list
Caused by: oracle.discoverer.applications.viewer.model.ConnectionException: conn.store.not.avail

 

Cause

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