'UNKNOWN ERROR HAPPENED / FAILED TO GET CONNECTION' ERROR WHEN OPENING HTML CRFS.

(Doc ID 559352.1)

Last updated on JANUARY 17, 2012

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.6.0 and later   [Release: 4.6 and later ]
Oracle Clinical Remote Data Capture Option - Version: 4.5.3 and later    [Release: 4.5 and later]
Oracle Clinical Remote Data Capture Option - Version: 4.6.2 and later    [Release: 4.6.2 and later]
Information in this document applies to any platform.
Checked for relevance on 17-Mar-2010

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

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