Recieved Errror XMLHttp Request Failed Error In RDC (Doc ID 1456887.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical Remote Data Capture Option - Version 4.5.3 and later
Information in this document applies to any platform.

Symptoms

ISSUE:
--------
Trying to open a CRF, the following error message is displayed: XMLHttp request failed: 2481063279 (Servlet error: Failed to get Connection.)."

 

Following error stack is reported in the Data Entry log:

 

</message>
</record>
<record>
 <date>2012-05-03T06:27:46</date>
 <millis>1336040866441</millis>
 <sequence>4111</sequence>
 <logger>oracle.pharma.rdc.de.servlet.RuntimeController</logger>
 <level>SEVERE</level>
 <class>oracle.pharma.rdc.de.servlet.RuntimeController</class>
 <method>doPost</method>
 <thread>14</thread>
 <message>[16847435712016500] Exception thrown from service while processing command cmdDocData with parameters {"dciId":"58201","dciVersion":"1","dciTs":"2010-03-10 10:19:53.0","dciLang":"en_US","dciUnlock":"0","id":"cmdDocData_0"}</message>
</record>
<record>
 <date>2012-05-03T06:27:46</date>
 <millis>1336040866441</millis>
 <sequence>4112</sequence>
 <logger>oracle.pharma.rdc.de.servlet.RuntimeController</logger>
 <level>SEVERE</level>
 <class>oracle.pharma.rdc.de.servlet.RuntimeController</class>
 <method>doPost</method>
 <thread>12</thread>
 <message>[16847435712016500] Exception thrown from service while processing command getHtmlForCRF with parameters {"dciId":"58201","dciVersion":"1","dciTs":"2010-03-10 10:19:53.0","dciLang":"en_US","dciUnlock":"0","id":"getHtmlForCRF_0"}</message>
</record>
<record>
 <date>2012-05-03T06:27:46</date>
 <millis>1336040866441</millis>
 <sequence>4113</sequence>
 <logger>oracle.pharma.rdc.de.servlet.RuntimeController</logger>
 <level>SEVERE</level>
 <class>oracle.pharma.rdc.de.servlet.RuntimeController</class>
 <method>doPost</method>
 <thread>14</thread>
 <message>[4327643735] [16847435712016500] Exception in RuntimeController
oracle.pharma.rdc.de.exception.FailedOperationException: SQL Exception. Unable to proceed further.
at oracle.pharma.rdc.de.service.dps.DcfStandardText.getStdTextLovCount(DcfStandardText.java:102)
at oracle.pharma.rdc.de.service.dps.DataProviderService.getRdciDocData(DataProviderService.java:185)
at oracle.pharma.rdc.de.service.dps.DataProviderService.processCommand(DataProviderService.java:231)
at oracle.pharma.rdc.de.servlet.RuntimeController.doPost(RuntimeController.java:574)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:824)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:224)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Io exception: Connection reset by peer: socket write error
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:286)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:885)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1153)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2932)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3023)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4132)
at oracle.pharma.rdc.de.service.dps.DcfStandardText.getStdTextLovCount(DcfStandardText.java:87)
... 12 more
</message>
</record>
<record>
 <date>2012-05-03T06:27:46</date>
 <millis>1336040866457</millis>
 <sequence>4114</sequence>
 <logger>oracle.pharma.rdc.de.servlet.RuntimeController</logger>
 <level>SEVERE</level>
 <class>oracle.pharma.rdc.de.servlet.RuntimeController</class>
 <method>doPost</method>
 <thread>12</thread>
 <message>[2481063279] [16847435712016500] Exception in RuntimeController
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.service.cps.ContentProviderService.getCrf(ContentProviderService.java:193)
at oracle.pharma.rdc.de.service.cps.ContentProviderService.processCommand(ContentProviderService.java:101)
at oracle.pharma.rdc.de.servlet.RuntimeController.doPost(RuntimeController.java:574)
at oracle.pharma.rdc.de.servlet.RuntimeController.doGet(RuntimeController.java:820)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:824)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:224)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Closed Connection
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.OraclePooledConnection.getConnection(OraclePooledConnection.java:288)
at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:362)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:285)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:178)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:158)
at oracle.pharma.rdc.de.util.ConnectionManager.checkOutInternal(ConnectionManager.java:284)
at oracle.pharma.rdc.de.util.ConnectionManager.getConnection(ConnectionManager.java:212)
... 13 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