'UNKNOWN ERROR HAPPENED / FAILED TO GET CONNECTION' ERROR WHEN OPENING HTML CRFS. (Doc ID 559352.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Symptoms

i.
The following error is displayed when trying to open any HTML CRF in RDC Onsite (where the number after 'Log code' is always a different one) :

Error Which Appears in 4.5.3 :
"Unknown error happened. Please contact system administrator. [Log Code: 7001327799] Failed to get Connection"

Error Which Appears in 4.6.2 :
Error
The data entry window has encountered an unexpected error and will shut down. If the problem recurs, please report the following information for diagnostic purposes.
Log code 4112775130, internal error.

ii.
The following appears in the 'delog0.log' (4.5.3) :


oracle.pharma.rdc.de.exception.FailedOperationException: Failed to get
Connection.
at
oracle.pharma.rdc.de.util.ConnectionManager.getConnection(ConnectionManager.java:214)
at
oracle.pharma.rdc.de.servlet.DataEntryServletHelper.isCRFLocked(DataEntryServl etHelper.java:547)
at
oracle.pharma.rdc.de.servlet.InitController.doPost(InitController.java:495)
at
oracle.pharma.rdc.de.servlet.InitController.doGet(InitController.java:140)




Caused by: java.sql.SQLException: Connection Cache with this Cache Name already exists
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:239)
at
oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleConnectionCacheManager.java:188)
at
oracle.pharma.rdc.de.util.ConnectionManager.checkOutInternal(ConnectionManager.java:278)
at
oracle.pharma.rdc.de.util.ConnectionManager.getConnection(ConnectionManager.java:212) 

iii.
The following appears in the '41127751306142847082681438579' dump file (4.6.2) which was generated when the error occurred and resides in the 'opappps46\log' directory on the Application Server  :

#Starting dump of context parameters for failureId: 4112775130
#------------------------------------------------------------------

refids=51bd53b016b501883143d36ce3ce07cffcd2b04d28a181a8fe0552e09d53cd99,ops$sbains@OC462M,60131676906462250,2012Jan17170618660

#------------------------------------------------------------------

Exception Details:Failed to get Connection.
oracle.pharma.rdc.de.exception.FailedOperationException: Failed to get Connection.
at oracle.pharma.rdc.de.util.ConnectionManager.getConnection(ConnectionManager.java:215)
at oracle.pharma.rdc.de.service.dps.DataProviderService.getRdciDocData(DataProviderService.java:188)
at oracle.pharma.rdc.de.service.dps.DataProviderService.processCommand(DataProviderService.java:237)
at oracle.pharma.rdc.de.servlet.RuntimeController.doPost(RuntimeController.java:608)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Connection Cache with this Cache Name already exists
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240)
at oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleConnectionCacheManager.java:188)
at oracle.pharma.rdc.de.util.ConnectionManager.checkOutInternal(ConnectionManager.java:279)
at oracle.pharma.rdc.de.util.ConnectionManager.getConnection(ConnectionManager.java:213)
... 14 more

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.