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

Last updated on DECEMBER 05, 2019

Applies to:

Symptoms

ISSUE:
--------
Trying to open a CRF, the following error message is displayed: XMLHttp request failed: <XMLHttp_request_id> (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>[<MESSAGE_ID1>] Exception thrown from service while processing command cmdDocData with parameters {"dciId":"<DCI_ID>","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>[<MESSAGE_ID1>] Exception thrown from service while processing command getHtmlForCRF with parameters {"dciId":"<DCI_ID>","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>[<MESSAGE_ID2>] [<MESSAGE_ID1>] 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>[<MESSAGE_ID3>] [<MESSAGE_ID1>] 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

Changes

Cause

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