Unable To View The Audit History For A Specific Study

(Doc ID 1201426.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version: 4.5.3 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.


You wish to review the audit history in RDC Onsite Data Entry. When you click the history tab to review the audit history you receive the following error.


X Error
XMLHttp request failed: 9433348515 (Servlet error: SQL Exception. Unable to proceed further

The error line from the delog0.log file from the application server throws the following:

at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RXC.RDC", line 1938
ORA-06512: at "RXC.RDC_ANCILLARY", line 1167
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:183)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:872)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3000)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3092)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4285)
at oracle.pharma.rdc.de.service.dps.Discrepancy.getRespDataForDiscHist(Discrepancy.java:79)
... 12 more

Responsibility: RDC
Base Release/Patchset:

OCCURRENCE PATTERNS: happens intermittently within given studies.

WORKAROUNDS: None available


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